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.