Stay organized with collections
Save and categorize content based on your preferences.
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:
Find your Conversational Insights service account by going to IAM.
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-08 UTC."],[[["\u003cp\u003ePre-GA features, like the one described, are subject to the "Pre-GA Offerings Terms," are provided "as is," and may have limited support.\u003c/p\u003e\n"],["\u003cp\u003eThe Data Processing and Security Terms are applicable to this offering, allowing for the processing of personal or legally regulated data.\u003c/p\u003e\n"],["\u003cp\u003eCertain Conversational Insights features support Google Sheets as a data source or destination, offering an alternative to Cloud Storage.\u003c/p\u003e\n"],["\u003cp\u003eTo use Sheets with Conversational Insights, users must share their spreadsheet with the Conversational Insights service account associated with their Google Cloud project and then provide the spreadsheet's URL.\u003c/p\u003e\n"],["\u003cp\u003eInsights can read data from or create worksheets within a shared spreadsheet, but new spreadsheets must be shared before they can be utilized by Insights.\u003c/p\u003e\n"]]],[],null,["# Enable Sheets integration\n\n| **Preview**\n|\n|\n| This feature is subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section\n| of the [Service Specific Terms](/terms/service-terms#1).\n|\n| Pre-GA features are available \"as is\" and might have limited support.\n|\n| For more information, see the\n| [launch stage descriptions](/products#product-launch-stages).\n|\n| The [Data Processing and Security Terms](/terms/data-processing-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).\n\nSome Conversational Insights features support the use of Google Sheets for\nstoring data. For these compatible features, you can use\nSheets as a data source or destination, instead of\nCloud Storage. To do this, you share a Sheets spreadsheet\nwith the Conversational Insights\n[service account](/iam/docs/service-account-overview) that is associated\nwith your Google Cloud project.\n\nIntegrate Sheets\n----------------\n\nTo integrate Sheets with Conversational Insights, do the following:\n\n1. Find your Conversational Insights service account by going to IAM.\n\n [Go to IAM](https://console.cloud.google.com/iam-admin/iam)\n2. To reveal the Conversational Insights service account, check the **Include Google-provided role grants** box.\n\n For more help finding your Conversational Insights service account,\n see [Troubleshooting service account access](/contact-center/insights/docs/known-issues).\n3. Share your spreadsheet with your Conversational Insights service account's\n email address.\n\n4. Copy the spreadsheet's URL.\n\n5. Paste the spreadsheet's URL into the Insights console or\n API. The spreadsheet URL contains the spreadsheet ID, as shown in the\n following example:\n\n https://docs.google.com/spreadsheets/d/\u003cvar translate=\"no\"\u003eSPREADSHEET_ID\u003c/var\u003e/edit?gid=\u003cvar translate=\"no\"\u003eWORKSHEET_ID\u003c/var\u003e\n\nUse `?gid=`\u003cvar translate=\"no\"\u003eWORKSHEET_ID\u003c/var\u003e to specify a worksheet in your\nspreadsheet. Specifying a worksheet is optional. If you don't specify a\nworksheet, Insights uses the first worksheet in the spreadsheet.\n| **Note:** Other information in the spreadsheet URL, such as the `resource_key` parameter, is ignored by Insights.\n\nUse Sheets with Insights\n------------------------\n\nAfter integrating with your spreadsheet, Insights\ncan read the data from your worksheet when an operation calls for it\nor use the entire spreadsheet. Insights\ncan also create worksheet tabs. However, Insights\ncan't connect to and use new spreadsheets, unless you share the spreadsheets\nfirst."]]
