Choose the spreadsheet and the columns
Create a new spreadsheet or pick one in Google Drive, name the tab, and add the context, the person's details, the AI reading and the status. The answer's ID, the time and the questions are always there.
Google Sheets integration
Survey answers in a Google Sheet that stays current
Add a row for each survey answer, with a column for each question, and keep the AI reading and the status in that row up to date as they change in Usertick.
Every answer in a sheet your team already uses
Some teams work best in a spreadsheet. With the Google Sheets integration, each answer adds a row to a tab of its own, with the time, the survey, the page, a column for each question and, if you want them, the person's details and the AI reading.
The row keeps up. When the AI reads the answer, someone corrects the reading or the status changes, Usertick rewrites those cells, so the sheet matches the inbox without anyone copying it over.
Usertick can only open the spreadsheets it creates and the ones you pick in Google Drive. The rest of your Drive stays out of reach.
- Plan
- Every plan, 1 workflow per survey on Free
- Connects through
- Sign in with Google, with access to the files you pick
- Writes
- One row for each answer, in a tab Usertick keeps
- Kept up to date
- The AI reading, the status and the assignee
How answers reach the sheet
A workflow step chooses the spreadsheet and the columns, and the row stays current.
Rows that keep up with the inbox
With Keep rows up to date on, a row is rewritten when the AI reads the answer, a teammate corrects the reading or the status changes. The answers in the row stay as they were given.
What Usertick sends to Google Sheets
The columns of the tab, in order, with the groups you choose.
ColumnWhat it holds
Response ID, Received (UTC)The answer's ID, and when it arrived as a real date and time
Survey, Source, Page URL, Device, Variant, Country, LanguageThe context group: where the answer came from
One column for each questionEach answer, numbers as numbers and choices as their labels
User ID, Email, Name, VerifiedThe person group, when your site identified them
Type, Theme, Urgency, SentimentThe AI group, rewritten when the reading changes
Status, AssigneeThe status group, rewritten when someone works on the answer
Connect Google Sheets in three steps
Connecting writes nothing by itself. Each workflow step chooses its spreadsheet.
- 1
Sign in with Google
In Usertick, open Settings, then Integrations, select Google Sheets and sign in. Usertick can open only the spreadsheets it creates and the ones you pick.
- 2
Add the step to a workflow
Add the response to a Google Sheet, create a spreadsheet or pick one, and choose the columns.
- 3
Test it, then publish
A test run creates the tab and its header row without adding a row, so you can see the columns before the first answer.
New questions get a column at the end, a renamed question renames its column, and a deleted question keeps its column, so a long-running sheet never shifts under your formulas.
Read the setup guideFrequently asked questions
Google Sheets comes with every plan, along with workflows. Free runs 1 workflow per survey.
No. Usertick adds a tab of its own to the spreadsheet, named after the survey unless you name it, and reuses a tab with that name only when it is empty.
No. Rows start with the first answer after the workflow is published. To get earlier answers, export them from Usertick.
No. Usertick looks for the answer's row before writing, so each answer has one row.
No. The sheet follows Usertick. Changes made in the sheet stay in the sheet.
The run fails with the reason, such as a spreadsheet in the trash or past Google's limit of 20 million cells, and the workflow's activity shows it.
More integrations
SegmentSend a survey event with the answers on the signed-in user to Segment, and on to the tools you connect there.
BigQueryLand each response in a BigQuery table with the same columns every time, ready to query.
Google AnalyticsSee survey completions in Google Analytics, sent through the script already on your page.
NotionAdd each response to a Notion database or a new page.
Listen better, act faster, and build what truly matters.
Start free, see what your customers mean, and get each answer to the person who can act on it.
- 150 responses a month on Free
- Every channel and AI analysis
- No card needed