Some Customer Experience Insights features support the use of Google Sheets for storing data. For these compatible features, you can use Sheets as a data source or destination, instead of Cloud Storage. To do this, you share a Sheets spreadsheet with the Customer Experience Insights service account that is associated with your Google Cloud project.
Integrate Sheets
To integrate Sheets with Customer Experience Insights, do the following:
Find your Customer Experience Insights service account by going to IAM.
To reveal the Customer Experience Insights service account, check the Include Google-provided role grants box.
For more help finding your Customer Experience Insights service account, see Troubleshooting service account access.
Share your spreadsheet with your Customer Experience Insights service account's email address.
Copy the spreadsheet's URL.
Paste the spreadsheet's URL into the CX Insights console or API. The spreadsheet URL contains the spreadsheet ID, as shown in the following example:
https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit?gid=WORKSHEET_ID
Use ?gid=WORKSHEET_ID to specify a worksheet in your
spreadsheet. Specifying a worksheet is optional. If you don't specify a
worksheet, CX Insights uses the first worksheet in the spreadsheet.
Use Sheets with CX Insights
After integrating with your spreadsheet, CX Insights can read the data from your worksheet when an operation calls for it or use the entire spreadsheet. CX Insights can also create worksheet tabs. However, CX Insights can't connect to and use new spreadsheets, unless you share the spreadsheets first.