This article describes how to set up the Google Sheets connector in your Customer Data Hub account.
In this article:
|Add or Update Row||✓||✓|
Go to the Connector Marketplace and add a new connector. Read the Connector Overview article for general instructions on how to add a connector.
Click Next or go to the Actions tab. This is where you configure connector actions.
This section describes how to set up parameters and options for each action.
Use the following steps to find your Google Sheets Spreadsheet ID and enable Lookup:
There is no tracking available to show which Google sheets are enabled for lookup. Once lookup is enabled, there is no method to determine that Lookup enabled for a particular sheet if you log into the account another time.
Updates to the action dynamic drop-down lists are not live and do not display in real time. For example, if you are adding a new column in Google Sheets, modifications to the sheet do not automatically inherit the changes and reflect in the drop-down list.
To view the most recent data, you can click the Refresh icon on the connectors page or deselect the spreadsheet and select it again. Using either of these methods refreshes the drop-down lists to reflect your most recent updates.