Sync Survey Responses to Google Sheets
Automatically send every new survey submission to a Google Sheet
Zigpoll can write each new survey response to a Google Sheet automatically. Once it's set up, every matching submission appends a new row to your sheet in real time — no exports, no copy-paste, no manual work.
This is handled by an action on the survey's Behavior tab. You set a condition (such as "when the survey is completed"), choose the write to google sheet action, and save. Zigpoll creates the spreadsheet for you and keeps it up to date from then on.
Step 1: Connect the Google Sheets Integration
You only have to do this once per account.
Log in to your Zigpoll dashboard.
Navigate to Integrations from the left-hand menu.
Find Google Sheets and toggle it on.
Click Click To Authenticate and sign in with your Google account.
Grant Zigpoll access. You'll be returned to Zigpoll with a "connected successfully" confirmation.
Zigpoll requests the drive.file scope, which means it can only see and edit the spreadsheets it creates for you — it cannot read the rest of your Google Drive.
Step 2: Add the Action on the Behavior Tab
Go to Surveys and select the survey you want to sync.
Open the Behavior tab and scroll to the Actions section.
Click Add Action Logic to create a new rule.
Set a condition that decides when a row should be written. For example:
Survey is completed — write a row only when the respondent finishes the whole survey.
Survey is partially or fully completed — write a row as soon as any answer is submitted.
A specific slide answer equals a value — only sync responses that match a condition you care about.
Click Add action and choose write to google sheet from the dropdown.
If write to google sheet doesn't appear in the action dropdown, the integration isn't connected yet — go back to Step 1, or click add integration at the bottom of the dropdown.
Step 3: Save
Click Save. Zigpoll automatically creates a new Google Sheet for this action, with column headers based on your survey questions. From this point on, every response that meets your condition appends a new row to that sheet automatically.
After saving, the action row shows a View Sheet link — click it to open the spreadsheet in Google Sheets at any time.
Choosing Which Columns to Sync (Optional)
By default, Zigpoll syncs every column (survey answers plus metadata). To narrow this down, click Configure columns on the saved action:
Only include selected columns — sync just the columns you check.
Exclude selected columns — sync everything except the columns you check.
Use this to keep the sheet focused on the answers and metadata you actually want to track.
Combining With Other Actions
The Google Sheets action can run alongside other actions on the same rule. For example, when a survey is completed you could write a row to Google Sheets and send a Slack notification at the same time. You can also create separate rules — each with its own condition and its own sheet — by clicking Add Action Logic again.
Syncing based on a single question's answer
The steps above run at the survey level, so the condition can be survey completion or an answer to any slide. If you'd rather trigger the sync from one specific question — for example, only write a row when a particular slide is answered a certain way — add the write to google sheet action through that slide's own logic instead.
Open the slide in the editor, click +Add Logic, set your condition, choose write to google sheet, and save. Just like the Behavior tab, Zigpoll creates the spreadsheet automatically when you save. The action still writes the full survey response (not just that slide's answer). See Slide Logic for details.
Prefer a scheduled export instead of a live, row-by-row sync? See Automations to email or push a full CSV/Google Sheets export on a recurring schedule. For all of the action options available on the Behavior tab, see Behavior Settings.
Last updated