Use the API Connector add-on for Google Sheets to pull Yext Analytics data directly into a spreadsheet. After it's set up, refresh the data anytime with a single click.

Set up the API Connector add-on

1. Open Google Sheets to a blank sheet.
2. Hover over Extensions, hover over Add-ons, then click Get add-ons.

3. Search for API Connector and select the API Connector application by Mixed Analytics.

4. Click Install and follow the prompts to install the application.
5. Click Extensions, hover over API Connector, then click Open.
6. In the right side panel, click Add New to begin configuring the API request.

Create an API key

1. In your Yext account, go to the Developer Console.
2. Click + New App.
3. Enter a name for the app. Use something relevant to this connector, for example, "Google Sheets API App".
4. Click Create App.
5. Click the Permissions row, then click + Add Endpoint.
6. Select Management API > Analytics, then select Read-Only. This permission allows the connector to read Analytics data from your Yext account but not make changes to it.

7. Click Save.
8. Copy the API key. You'll use it to configure the API request in Google Sheets.

Configure the API request

1. In the API Connector add-on, set the API method to POST. This ensures analytics data is pulled from the Yext platform into Google Sheets.
2. Under API URL path, enter the following URL, replacing INSERT_API_KEY with the API key from the previous step and the vaparam with the latest version: https://api.yextapis.com/v2/accounts/me/analytics/reports?api_key=INSERT_API_KEY&v=YYYYDDMM.
3. Leave the OAuth field set to None.
4. Under Headers, use Content-Type as the New key, and application/json as the Value.
5. In Request Body insert the line of code based on the information you'd like to include. For example:

{
"metrics":
    [
    "[INSERT_METRICS]"
        ],
"dimensions": [
    "[INSERT_DIMENSIONS]"
    ],
"filters": {
    "[INSERT_FILTERS]"
    }
}

6. Under Destination sheet, select Set current, then select cell A1. This pulls the data into the current sheet starting at that cell.
7. Name the API Connector configuration so you can re-run the pull on a regular cadence.

Test the connector

1. Once the connector has been saved, click Run to pull the data.
2. Confirm that the connector runs without errors and that the expected data appears in the sheet.

After the connector is set up, click Run anytime to refresh the data in your spreadsheet.