Save responses to Google Sheets

Integrating Google Sheets with Responsly allows you to automatically send survey responses directly to a Google Sheets spreadsheet. This integration is particularly useful for teams that want to analyze data, share results, or manage responses in a familiar spreadsheet environment.

Table of contents

1. Why Integrate Google Sheets with Responsly?
2. Prerequisites
3. Step-by-Step Integration Guide
   • Step 1: Access Integrations in Responsly
   • Step 2: Connect Google Sheets Account
   • Step 3: Create or Select a Google Sheet
   • Step 4: Map Survey Fields to Google Sheets Columns
   • Step 5: Test the Integration
4. Managing Your Integration
5. Troubleshooting

Why Integrate Google Sheets with Responsly?

Integrating Google Sheets with Responsly offers several advantages:

• Real-time data sync: Automatically send survey responses to Google Sheets as they are submitted.
• Easy data management: Use Google Sheets’ powerful features to filter, sort, and analyze survey data.
• Collaboration: Share your Google Sheets with team members to collaborate on data analysis.
• Backup and storage: Keep a secure, cloud-based backup of all your survey responses.

Prerequisites

Before starting, ensure you have the following:

• A Responsly account with administrator access.
• A Google account to access Google Sheets.
• An existing survey in Responsly that you want to integrate with Google Sheets.

Step-by-Step Integration Guide

Step 1: Access Integrations in Responsly

1. Log in to your Responsly account.
2. Navigate to the "Connect" section from the dashboard.
3. In the list of available integrations, find and select Google Sheets.

Step 2: Connect Google Sheets Account

1. Click on "Connect Google Sheets".
2. You will be prompted to log in to your Google account (if you aren't already).
3. Allow Responsly to access your Google Sheets by clicking "Allow" when prompted.
4. Once connected, you will be returned to the Responsly integrations page.

Step 3: Create or Select a Google Sheet

1. After connecting your Google Sheets account, you will be asked to either create a new Google Sheet or select an existing one.
2. Choose the option that suits your needs:
   • Create a New Sheet: Enter a name for the new spreadsheet.
   • Select an Existing Sheet: Add a link to the existing spreadsheet.

Step 4: Map Survey Fields to Google Sheets Columns (If you use an existing spreadsheet)

1. After selecting an existing Google Sheet, you must map the fields.
2. Map each survey question to a corresponding column in your Google Sheet.
   • For example, map the "Name" survey question to the "Name" column in Google Sheets.
3. You can add new columns in Google Sheets if needed.
4. Click "Active" once you have completed the mapping.

Step 5: Test the Integration

1. To ensure everything is set up correctly, go to your Responsly survey and submit a test response.
2. Check the connected Google Sheet to verify that the response appears in the appropriate columns.
3. If the data is correctly populated, your integration is successfully set up.

Managing Your Integration

• Editing Mappings: You can revisit the mapping section to adjust which survey fields correspond to which Google Sheets columns.
• Disconnecting: If you no longer need the integration, you can disconnect it from the Integrations page in Responsly.

Troubleshooting

If you encounter any issues, try the following solutions:

• Data not appearing: Ensure that the correct Google Sheet is selected and the survey fields are properly mapped to the columns.
• Google Sheets permissions: Double-check that you have given Responsly the necessary permissions to access and modify your Google Sheets.
• Reconnecting Google Account: Sometimes, re-authenticating your Google account can resolve issues. Disconnect and reconnect the Google Sheets integration.

If you have any questions about Google Sheets integration, don't hesitate to get in touch with our team via email: karolina@responsly.com