Enable Sheets integration

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.

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.