Google Sheets Connector
Use the Google Sheets Connector to pull in data stored in Google Sheets as individual entities.
This connector will bring in data your stored in Google Sheets as individual entities and automatically sync your Google Sheets data with Yext! Now you will be able to maintain your Google Spreadsheet as a source of truth.
Prior to installing the connector, make sure that:
All the data in your cells are values only. The connector will fail if any cell data contains formulas or functions.
You have linked your Google Account to Yext by going to Content > Configuration > Linked Accounts > Google. Ensure that the 5 scopes are all configured for the linked account and select "Link". Note down the linkedAccountId to use as your Google Linked Account.
Install the Connector
Visit the App Directory in the Yext Platform and search for the "Google Sheets Connector”.
Review app details on the installation landing page and click "Install".
Click "Next" to allow the connector access to your Yext account.
Provide the required information:
Data Range: Use A1 (Sheet1!A1:B2) or R1C1 (Sheet1!R1C1:R2C2) notation to indicate which cells to include in the data connector. Follow the guidelines provided here: https://developers.google.com/sheets/api/guides/concepts. If your data includes column headers, we suggest you remove that row from the data range input to avoid storing these header values as entities.
Google Linked Account: This is the ID of the linked account you added prior to download, found in the Yext platform under Configuration > Linked Accounts > Google.
Google Spreadsheet ID: This is found in the URL of your spreadsheet. For example, if the spreadsheet URL is https://docs.google.com/spreadsheets/d/111/edit, then the spreadsheet ID would = 111.
Dimension: This can be either ROWS or COLUMNS. If each row should be registered as an individual entity, then input ROWS. If each column should be registered as an individual entity, then input COLUMNS.
- Click “Authorize".
Finalize Connector Configuration
You will be redirected to the connector landing page. Select "Edit Configuration" to finalize the connector configuration.
Select "Add Transform" and click "Split Columns" as the transform type. Input each Column Name for each field that should be separated out. Use a “|” as the split delimiter.
Select "Next" to map fields to an entity type. If the entity type you would like to use is not available from the list. Add or enable the correct entity type from the Content > Configuration > Entity Type overview page.
Select "Save" and then "Run Connector" to begin the connector run and pull data in from Google Sheets.
Wait a few minutes, depending on how much data you have in your Google Sheets, and refresh the page. You’ll see a summary of the entities pulled in. Check out the new entities created into Yext Content!