Import Okta Data to Google Sheets
In this guide, we’ll walk through how to pull Okta’s API data directly into Google Sheets, using the API Connector add-on for Sheets.
We’ll first get an API key, and then set up a request.
- Before You Begin
- Part 1: Get your Okta API Key
- Part 2: Create your API Request URL
- Part 3: Pull Okta API Data into Sheets
- Part 4: Handle Pagination
- Part 5: API Documentation
Before You Begin
Click here to install the API Connector add-on from the Google Marketplace.
Part 1: Get Your Okta API Key
- While logged in to your Okta dashboard, navigate to Security > API from the top navigation bar.
- From the API menu, click Tokens, and then click Create Token.
- Give your token a name and click Create Token
- You will now be presented with your token. Congrats, you now have access to the Okta API! Copy this value and keep it handy as you’ll need it in a moment.
Part 2: Create Your Okta API Request
We’ll start by getting a list of users in your organization.
- API root: https://YOUR_DOMAIN.okta.com/api/v1
- Endpoint: /users
Putting it all together, we get the full API Request URL:
Part 3: Pull Okta API Data into Sheets
Now let’s enter that URL into API Connector.
- Open up Google Sheets and click Extensions > API Connector > Open.
- In the Create screen, enter the Request URL we just created
- Under Headers, enter three sets of key-value pairs like this:
Content-Type application/json Accept application/json Authorization SWSS YOUR_TOKEN
Replace YOUR_TOKEN with the token you got above in part 1. You must include the text ‘SWSS’ before it.
- Create a new tab and click Set Current to use that tab as your data destination.
- Name your request and click Run. A moment later you’ll see a list of your Okta users populate your Google Sheets.
Part 4: Handle Pagination
Note that the Okta API limits the number of records returned in each request. By default, only the first page of records will be returned, and each page contains a limited number of records. To access more than 100 records, use the “limit” and “after” parameters as described in the documentation.
In API Connector, you can run through these URLs automatically with pagination handling (paid feature), like this:
Part 5: API Documentation
Official API documentation: https://developer.okta.com/docs/reference/#core-okta-api