Import data from Auth0 | Equals Help Center

You can use Import Scripts to import data from your Auth0 account directly into an Equals workbook.

1. Create an Auth0 personal access token

Follow the instructions here to create an Auth0 personal access token. You'll also want to write down your Client ID.

2. Add the key to a secret group

Copy the access token from the prior step. Then create a new secret group and paste the key into a new secret named auth0_api_secret. Create a second secret in the same group called auth0_api_client_id with your Client ID.

3. The code

Once you've completed the prior steps, create a new workbook, add a new import script to a sheet and copy + paste the script below. Once pasted select your secret group in the toolbar (make sure the key in the secret group is called auth0_api_secret).

/*
 - https://auth0.com/docs/api/management/v2
 - https://auth0.com/docs/api/management/v2#!/Users/get_users
*/

const equals = require("equals");
const axios = require("axios");

/*
 Page through the users and add ones that have not yet been seen to the spreadsheet
 Avoid PII
*/
const processAuth0UsersData = async () => {
    const accessToken = await getAccessToken();

    const headers = {
        'Content-Type': 'application/json',
        Authorization: `Bearer ${accessToken}`,
    };

    const perPage = 100;

    // set next page call as true so we make the initial call
    let makeNextPageCall = true;

    // set the initial page to be 0
    let page = 0;

    equals.addHeaders(["user_id", "created_at", "updated_at", "last_login", "logins_count", "subscription_purchased", "user_metadata"]);

    while (makeNextPageCall) {
        // start with make next page call as false and only set to true if we need to make more
        makeNextPageCall = false;

        //console.log(page);
      
        await axios
            .get(
                equals.getSecret("auth0_api_host")&`/api/v2/users?page=${page}&per_page=${perPage}`,
                { headers }
            )
            .then(response => {
                if (response.data.length > 0) {
                  /*
                    Add to spreadsheet
                  */
                  let users = response.data;
                  for(const user of users) {
                    //console.log(user);

                    equals.addRow([
                      user.user_id,
                      formatDate(user.created_at),
                      formatDate(user.updated_at),
                      formatDate(user.last_login),
                      user.logins_count
                    ]);
                  }
                  
                }

                // we got all we can for this page, so make another page call
                // Limit is 1000 users: https://auth0.com/docs/manage-users/user-search/view-search-results-by-page#limitation
                if (response.data.length >= perPage && page < 10) {
                    makeNextPageCall = true;
                    page += 1;
                }
            })
            .catch(error => {
                console.log(`error getting users: ${error}`);
            });
    }
};


const getAccessToken = async () => {
    const timestamp = new Date().getTime();

    let accessToken = "";

        const oauthTokenHeaders = {
            'Content-Type': 'application/x-www-form-urlencoded',
        };

        let clientId = equals.getSecret("auth0_api_client_id")
        let clientSecret = equals.getSecret("auth0_api_secret")
        let grantType = 'client_credentials'
        let audience = equals.getSecret("auth0_api_audience")

        const data = `client_id=${clientId}&client_secret=${clientSecret}&grant_type=${grantType}&audience=${audience}`;

        await axios
            .post(equals.getSecret("auth0_api_oauth_url"), data, {
                headers: oauthTokenHeaders,
            })
            .then(response => {
                accessToken = response.data.access_token;
            })
            .catch(error => {
                console.error(error);
            });

    return accessToken;
};

const formatDate = (gaDate) => {
  if (!gaDate) {
    return ""
  }
  //console.log(gaDate)
  const year = gaDate.slice(0,4);
  const month = gaDate.slice(5,7);
  const day = gaDate.slice(8,10);
  //console.log(`Boom = ${year}-${month}-${day}`)
  return `${year}-${month}-${day}`
}

await processAuth0UsersData();

Import data from Google Analytics

Import data from Intercom

Import data from Github

Import data from Plausible.io

Import data from Deputy