> For the complete documentation index, see [llms.txt](https://docs.getgymini.com/gymini/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.getgymini.com/gymini/features/features-overview/forms-surveys-chat/surveys-and-forms/exporting-survey-or-form-answers-to-a-google-sheet.md).

# 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.