Skip to content
Contact us
  • There are no suggestions because the search field is empty.

Google Sheets connection

Automatically sync survey responses as rows to a Google Sheets spreadsheet. Each new response adds a row with all your survey data, giving you a live, always-up-to-date spreadsheet.

Overview

The Google Sheets connection appends a new row to your spreadsheet every time a survey response matches your trigger rules. It automatically creates headers based on your survey structure and keeps everything organized with frozen, bolded header rows.

Prerequisites

  • A Google account with access to Google Sheets

  • A survey with at least one question

Setup

Step 1: Connect your Google account

Select an existing connected Google account or click Connect an account to authenticate with Google via OAuth.

Step 2: Select a spreadsheet 

You can either create a new spreadsheet or use an existing one. If creating new, give your sheet a name (e.g., "Product pricing research results"). Centiment will automatically create and manage the sheet within your spreadsheet.

Step 3: Set trigger rules

Choose which response statuses should trigger a sync: complete, disqualified, or over quota. Optionally add conditions to filter specific responses.

What gets synced

Each row includes the following metadata columns alongside your survey question data:

  • Session — The unique response session ID

  • Status — Response status (complete, partial, disqualified, etc.)

  • Progress — Completion percentage

  • Started — When the response began

  • Ended — When the response was submitted

  • Duration — How long the response took

  • Collector — Which collector captured the response

  • Language — Response language

  • Timezone — Respondent's timezone

  • IP — Respondent's IP address

  • OS — Operating system

  • Browser — Browser used

  • Device — Device type

Survey questions are added as individual columns. NPS and CSAT questions get separate score and comment columns. Matrix questions are expanded into one column per row.

Backfill

When you first enable the connection, existing responses that match your trigger rules are automatically synced to the spreadsheet. This gives you a complete dataset from day one.

Good to know

  • Header rows are automatically frozen and bolded for easy reading.

  • If you add new questions to your survey, new columns are added automatically on the next sync.

  • The connection uses your Google account's permissions, so make sure you have edit access to the target spreadsheet.