Connect Google Sheets to Kimola
min read - Updated on Oct 28, 2026You can connect Google Sheets to Kimola to analyze a spreadsheet straight from your Google Drive, without downloading it and uploading it as a file. You sign in with your Google account, pick a spreadsheet in Google's file picker, and the spreadsheet opens in the same report wizard as an uploaded file. There you choose the sheet and its columns, the classifiers and the Dimensions, and Kimola creates a Report that shows the themes in your data, the sentiment of each piece of feedback and which themes perform worst. It suits survey responses, form submissions and any feedback your team keeps in Google Sheets.
The Google Sheets integration is available in the paid packages (Basic, Standard, Business and Enterprise), not in Starter. It is one of the data sources Kimola connects to for Reports; see What are Integrations? for the others.
See kimola.com/pricing for the packages that include integrations. Kimola On-Premises doesn't offer the Google Sheets integration; there, download the spreadsheet as an .xlsx or .csv file and upload it instead.
Step 1: Sign In to Google Drive
You start from the REPORTS page. Under the upload area, Integrations lists Intercom, Zendesk and Google Sheets. Each has a check mark that is gray while the integration isn't connected and green once it is. Click Google Sheets.
Google's sign-in window opens. Choose the Google account that can open your spreadsheet and allow Kimola to see your Google Drive files. Kimola asks for read access: it opens the spreadsheet you pick and doesn't change, move or delete anything in your Drive. When you allow it, the window closes and Google's file picker opens.
Google's sign-in and the file picker open in new browser windows, so allow pop-ups for app.kimola.com.
[Screenshot: The Integrations row under the upload area of the Reports page, with Google Sheets and its check mark]
You can also connect Google Sheets in advance from ACCOUNT › Integrations. Under AVAILABLE, click the + on the Google Sheets card and allow Kimola in the Google window. The window shows "The token has been successfully saved" and closes by itself, and Google Sheets moves to ACTIVE with the date it was connected. To analyze a spreadsheet, you still start from REPORTS, and Google may ask you to confirm your account there.
The connection is saved for your team's Kimola account. Each teammate signs in with their own Google account when they open Google Sheets from REPORTS, so they can pick the spreadsheets their own account can open.
Step 2: Pick a Spreadsheet
Google's file picker shows the Google Sheets spreadsheets your account can open, including those in shared drives. Search for the spreadsheet by name or browse to it, select it and confirm. You pick one spreadsheet at a time.
The file must be a Google Sheets spreadsheet. A .csv or .xlsx file that is only stored in your Drive can't be read through the integration.
Kimola reads a copy of the whole spreadsheet, with every tab in it, and opens the report wizard on Sheets & Columns. Each tab of the spreadsheet becomes a sheet you can choose from.
Kimola analyzes its copy of the spreadsheet: changes you make in Google Sheets afterwards don't reach a Report already created from it.
Step 3: Choose Columns and Create the Report
From here the spreadsheet goes through the same steps as an uploaded file: Dataset, Classifiers, Structure, Dimensions and Review. See Create a Report Using Integrations for how the three integrations compare.
Choose the Sheet and Columns
The wizard opens on Sheets & Columns: "Here is the preview of your dataset file. Choose required columns to continue." The preview lists every tab of your spreadsheet by name, with the first one selected. Click another tab to work with that sheet; your column choices start again for the new sheet. The preview shows the first rows of the sheet, the number of rows in total and the spreadsheet's name and size.
Choose the columns from the names in the first row.
The first row of each sheet holds the column names, and every row below it is one piece of feedback. Keep the text you want to analyze in a single column; responses collected with Google Forms are already in this shape.
Text Column (required): "Column that holds the text content to analyze." For a survey, this is the open-ended question you want to analyze, such as "What could we do better?".
Url Column (optional): "Column that holds the unique web url." Choose it if each row links to its source, for example a review page.
Date Column (optional): "Column that holds the datetime value." Choose the date each response was given, such as the Timestamp column of a Google Forms spreadsheet. With a Date Column, the Report can show how topics change over time.
The other columns of the sheet aren't analyzed.
Choose Classifiers and Dimensions
In Classifiers, choose the models that label every row. The Automatic Classifier discovers the themes from your data, and the Sentiment Classifier labels the sentiment of every row. You can add other pretrained models or your own custom models, for example a model with the topics of your survey. Choose a content classifier and the Sentiment Classifier together to see the best and worst performing themes.
In Structure, decide whether a row can get more than one label. Enable Multi-label Classification suits open-ended answers, because one answer often mentions several things: the price and the delivery time, for example. See Create a Report Using Multi-Label Classification.
In Dimensions, you can choose research questions to ask of every row. They are optional. For survey responses, Motivations ("Why is this chosen or preferred?"), Pain Points ("What goes wrong or creates difficulty?") and Unmet Needs ("What is missing or desired?") are a common start. See Add Dimensions to a Report.
Review and Create the Report
The Review step shows your choices before anything is analyzed: an optional Report Title, the Report Language, the Dataset and the Required Query. Dataset names the sheet and the spreadsheet and the number of rows to analyze. When some rows have an empty Text Column, it shows how many rows have text available for analysis out of the total; only those rows are analyzed and counted in queries.
Analyzing a spreadsheet uses queries = rows × models × Dimensions.
The Report Language is the language the Report is written in: English, Spanish, French, German, Portuguese, Dutch or Turkish. The spreadsheet can be in any of the 30+ languages Kimola analyzes, whatever the Report Language.
If your package doesn't have enough queries left for every row, the step says so before you continue, and only part of the spreadsheet is analyzed if you proceed.
Confirm to start the analysis. When it is complete, Kimola shows "Here we go!" and View Report opens your Report.
The Report opens on Overview: the number of records analyzed, the sentiment, the best and worst performing themes and your Dimensions. To see which themes respondents are least satisfied with, open Performance. To analyze responses that arrive later, create a new Report from the same spreadsheet. For the whole workflow, from survey responses to an Action Plan, see How to Analyze Open-Ended Survey Responses, and for more on what Kimola does with survey data, see Survey Analysis.
Disconnect Google Sheets
You disconnect Google Sheets from your account's Integrations page. Open ACCOUNT, go to Integrations and find the Google Sheets card under ACTIVE. Click the delete icon on the card. Kimola asks "Are you sure you want to remove connection Google Sheets?" Click Yes, delete it.
Google Sheets moves back to AVAILABLE, and its check mark on REPORTS turns gray again. Reports you created from spreadsheets stay as they are, with all their results, because each Report keeps its own copy of the rows it analyzed. Clicking Google Sheets on REPORTS later signs you in again.
Disconnecting removes the connection from Kimola only. To withdraw Kimola's access to your Drive completely, remove Kimola from the third-party apps in your Google Account too.