Back
Step 2: Install the Google Sheets App
Navigate to the App Directory and locate the Google Sheets Connector. Review the app listing and click Install.
Review the configuration changes summary and authorize Yext APIs by clicking Next.
Input the following information:
- Data Range, which requires A1 or R1C1 notation to indicate which cells to include in the data connector. Follow the guidelines in Google’s API documentation. If your data includes column headers, we suggest you do not include that row in the data range, to avoid storing these header values in Yext as entities.
- Google Linked Account, which is the
linkedAccountIdyou noted in the last step (under Knowledge Graph > Configuration > Linked Accounts > Google). - Google Spreadsheet ID, which is found in the URL of your spreadsheet. For example, if your spreadsheet URL is
https://docs.google.com/spreadsheets/d/111/edit, then the spreadsheet ID would be111. - Dimension, which 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.
You will be redirected to your connector overview page. Select Edit Configuration to finalize the connector configuration.
Click Add Transform and select Split Columns as the transform type. Input each Column Name for each field that should be separated out. Use a vertical pipe (|) 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 Knowledge Graph > Configuration > Entity Type overview page.
Select Save and 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 in the Knowledge Graph!