# Exporting Survey or Form Answers to a Google Sheet

**Introduction**

Gymini allows you to export the answers from your surveys or forms to a Google Sheet, facilitating a more structured and efficient way to analyze the responses. This guide will walk you through the process of setting up this feature.

**Step-by-Step Guide**

**Step 1: Create a Survey**

* **Access the Survey Builder**: In your Gymini account, navigate to the survey builder and create a survey with various questions. For this guide, a dental survey with questions regarding services and pricing preferences was created.

**Step 2: Set Up a Trigger**

* **Create a New Trigger**: Go to "Triggers" and create a new basic rule.
* **Name the Trigger**: Give it a descriptive name, such as "Survey Dental Submitted Webhook to Google Sheet."
* **Define the Action**: Set the action to "Survey Submitted" and select the specific survey you created.

**Step 3: Set Up a Webhook in Zapier**

* **Access Zapier**: Log in to your Zapier account.
* **Create a Zap**: Start creating a new Zap and select "Webhooks by Zapier" as the trigger event.
* **Get Webhook URL**: Copy the webhook URL provided by Zapier.
* **Paste Webhook URL in Gymini**: Go back to Gymini and paste the webhook URL in the trigger setup, then save and activate the trigger.

**Step 4: Test the Survey**

* **Get Survey Link**: Find the integration link for your survey in Gymini.
* **Test the Survey**: Open the link in a new tab and fill out the survey to test it.

**Step 5: Set Up Google Sheets Action in Zapier**

* **Create a Google Sheets Action**: In Zapier, create a new action using Google Sheets to create a spreadsheet row.
* **Connect Google Account**: Connect your Google account to Zapier.
* **Create a Spreadsheet**: In your Google account, create a new spreadsheet with columns corresponding to the questions in your survey.
* **Map Fields**: In Zapier, map the fields from the survey to the columns in the Google Sheets.

**Step 6: Test the Zap**

* **Test the Zap**: In Zapier, test the Zap to ensure it is working correctly.
* **Activate the Zap**: Once tested successfully, activate the Zap in Zapier.

**Conclusion**

You have now successfully set up a system to export survey or form answers from Gymini to a Google Sheet. This setup allows you to have a structured view of all the responses, facilitating easier analysis and segmentation based on the answers provided.


---

# Agent Instructions: 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.getgymini.com/gymini/features/features-overview/forms-surveys-chat/surveys-and-forms/exporting-survey-or-form-answers-to-a-google-sheet.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.