> For the complete documentation index, see [llms.txt](https://docs.zigpoll.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.zigpoll.com/tutorials/sync-survey-responses-to-google-sheets.md).

# Sync Survey Responses to Google Sheets

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.

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.

{% hint style="info" %}
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.
{% endhint %}

***

### Step 2: Add the Action on the Behavior Tab

1. Go to **Surveys** and select the survey you want to sync.
2. Open the **Behavior** tab and scroll to the **Actions** section.
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 slide 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.

{% hint style="info" %}
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.
{% endhint %}

***

### 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](/slides/slide-logic.md) for details.

{% hint style="info" %}
Prefer a scheduled export instead of a live, row-by-row sync? See [Automations](/tutorials/automations.md) 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](/polls/behavior-settings.md).
{% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.zigpoll.com/tutorials/sync-survey-responses-to-google-sheets.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.