Enable Sheets integration

Preview

This feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the Service Specific Terms. Pre-GA features are available "as is" and might have limited support. For more information, see the launch stage descriptions.

The Data Processing and Security Terms apply to this offering, which allows customers to process personal data or other data subject to legal or regulatory compliance requirements (subject to the restrictions in the GCP Terms of Service, including Section 3.3(d)(viii) regarding health information).

Some Conversational 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 Conversational Insights service account that is associated with your Google Cloud project.

Integrate Sheets

To integrate Sheets with Conversational Insights, do the following:

1. Find your Conversational Insights service account by going to IAM.

   Go to IAM

2. To reveal the Conversational Insights service account, check the Include Google-provided role grants box.

   For more help finding your Conversational Insights service account, see Troubleshooting service account access.

3. Share your spreadsheet with your Conversational Insights service account's email address.

4. Copy the spreadsheet's URL.

5. Paste the spreadsheet's URL into the 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, Insights uses the first worksheet in the spreadsheet.

Note: Other information in the spreadsheet URL, such as the resource_key parameter, is ignored by Insights.

Use Sheets with Insights

After integrating with your spreadsheet, Insights can read the data from your worksheet when an operation calls for it or use the entire spreadsheet. Insights can also create worksheet tabs. However, Insights can't connect to and use new spreadsheets, unless you share the spreadsheets first.