Integrate your Zonka Feedback Account to Google Sheets to automatically add your Survey Responses into Google Sheets. Sort, filter and analyze your Survey Data and collaborate with your team on Google Sheets.

What do you need for this integration?

A Zonka Feedback Account - any plan
A Google Account - any plan

Setting up the Google Sheets integration with Zonka Feedback

Choose a Survey from Survey List View and head to the Integrations tab from the top navigation.

Click on 'Connect' in Google Sheets

Next, you will see the Google Sheets Integrations Detail Page where you can click 'Connect to Google Sheets' to connect your Zonka Feedback Account.

You'll be redirected to Google to log in, if you are not logged in or to choose an account if you're logged in.
Once logged in, you will see an Authorization Screen. Click on 'Allow' to give permission to Zonka Feedback to access Google Sheets.

You’ll be directed back to Zonka Feedback. Now you can Create a New Google Sheet or Choose from an Existing Google Sheet to add new Survey Responses from Zonka Feedback.

Connecting a New or Existing Google Sheet to your survey in Zonka Feedback

With the Google Sheets and Zonka Feedback Integration, you can connect any Google Sheet to a Survey to automatically add new Survey Responses to the Google Sheet. This is very handy if you're using Google Sheets to add survey responses, do analysis, create charts, run custom reports, and collaborate with your team via Google Sheets.

To Create a New Sheet to add new Survey Responses, do the following.

Once you have connected your Google Account to your Zonka Feedback Account, go to Integrations within the Survey you'd like to automate adding Survey Responses in Google Sheets for
Choose Settings to manage the Google Sheets
You will view the option to 'Create New'. Enter the Sheet Name and select if you'd like to sync the last 1,000 Survey Responses when the new sheet is created.

Once done, click on 'Save' to save the new sheet. A new Google Sheet will be created in your account and the last 1,000 Survey Responses will be synced to the sheet in different rows if selected.

To Connect an Existing Sheet to add new Survey Responses, do the following.

Once you have connected your Google Account to your Zonka Feedback Account, go to Integrations within the Survey you'd like to automate adding Survey Responses in Google Sheets for
Choose Settings to manage the Google Sheets
You will view the option to 'Choose from Existing'. Enter the Sheet URL and select if you'd like to sync the last 1,000 Survey Responses to this existing sheet
Once done, click on 'Save'. The Sheet will be connected and the last 1,000 Survey Responses will be synced if selected.

Viewing the Connected Google Sheet

To view the connected Google Sheet, do the following.

Once you have connected your Google Account to your Zonka Feedback Account, go to Integrations within the Survey you'd like to view the Connected Sheet for.

Choose Settings on Google Sheets.
You will view a button 'View Connected Sheet'. Click on it and the Google Sheet will open in a new browser tab.

Removing Google Sheets Integration

To view the connected Google Sheet, do the following.

Once you have Connected your Google Account to your Zonka Feedback Account, go to Integrations within the Survey you'd like to remove the Connected Sheet for.
Choose Settings on Google Sheets.
You will view a button 'Remove Integration' at the bottom. Click on it and the integration will be removed.

FAQs: Google Sheets integration with Zonka Feedback

Can I connect different Google Sheets for different Surveys?

Yes, you can connect different Google Sheets for different Surveys and manage the integration and settings for Google Sheets separately for separate Surveys.

What happens if I delete the Google Sheet by mistake?

The integration will not work and you will have to reconnect to a separate sheet.

In how much time do the responses get synced?

The responses get synced automatically, in real-time.

What data gets synced to the Google Sheets?

All the Survey Data gets synced to the Google Sheets. The Survey Details, Contact Details, and Survey Questions will be different columns in the Sheet and each response will be a row.

Does the data in my Google Sheets get deleted if I remove the integration?