Ctrlk
For the complete documentation index, see llms.txt. This page is also available as Markdown.

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 Settings → Workflows → Actions 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.

  1. Log in to your Zigpoll dashboard.

  2. Navigate to Integrations from the left-hand menu.

  3. Find Google Sheets and toggle it on.

  4. Click Click To Authenticate and sign in with your Google account.

  5. 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 Workflows Tab

  1. Go to Surveys and select the survey you want to sync.

  2. Open Settings → Workflows → Actions.

  3. Click Add Action Logic to create a new rule.

  4. 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 question answer equals a value — only sync responses that match a condition you care about.

  5. 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 Changes. 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)

The action row has a columns dropdown set to all columns: every answer and every piece of metadata is synced, including questions you add later and metadata that first appears in later responses. To narrow this down, choose certain columns instead:

  • Only include selected columns — sync just the columns you check.

  • Exclude selected columns — sync everything except the columns you check.

The row then shows how many columns you chose; click it to change them. If the survey has no responses yet, the list of metadata columns is taken from another survey on your account that is set up the same way.

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 question. If you'd rather trigger the sync from one specific question — for example, only write a row when a particular question is answered a certain way — add the write to google sheet action through that question's own logic instead.

Open the question in the editor, click Add Action Logic, set your condition, choose write to google sheet, and click Update Question. Just like the Workflows tab, Zigpoll creates the spreadsheet automatically when you save. The action still writes the full survey response (not just that question's answer). See Question 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 Workflows tab, see Workflows.

Troubleshooting

  • Rows stopped appearing. Zigpoll's connection to Google may have expired. Go to Integrations, toggle Google Sheets off and on, click Click To Authenticate, sign in with the same Google account, and click Save Changes.

  • "Failed to create Google Sheet" when saving. Reconnect Google Sheets as above, then save again.

  • You want rows in your own sheet. Zigpoll can only write to the sheet it created. Use View Sheet to open it, and build on it from there.

  • You deleted the sheet. Remove the action, add it again, and save. Zigpoll creates a new sheet.

For more, including scheduled exports whose sheet name changes on each run, see Google Sheets troubleshooting.

Last updated