×
Request a Demo

Request a Demo

Look No Further. Get Started Today

Zonka Feedback Apps & Integrations / / Add New Survey Responses to Google Sheets

Add New Survey Responses to Google Sheets

By: Zonka Feedback

If you use Google Sheets to save data, run reports and collaborate with your team, then with the Zonka Feedback and Google Sheets integration, you can get your Survey Responses synced to Google Sheets in real-time. Integrate your Google Sheets and Zonka Feedback account and sync Survey Responses as new rows all in real-time. 

With this integration, your data syncs to Google Sheets as soon as a new Zonka Feedback Survey is filled. You can create reports, run analysis, add charts and graphs based on the survey responses in your Google Sheets to collaborate with your team. 

What you need:

  • A Zonka Feedback account
  • A Google Drive account

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.