Blog

Community Surveys v5.7.0 brings in the new integration with Google Sheets. With this integration, you can export your survey responses to Google Sheets without much effort.

What’s more? The responses are automatically synced to the Google Sheets as and when the user completes the response, no manual intervention is needed.

How to integrate your survey with Google Sheets?

It’s simple. There are a couple of initial steps needed to enable Google Sheets integration on your site.

The first step is to create an integration app with Google Cloud Console. If you have not done it already, get yourself an OAuth 2.0 Credentials app created at https://console.developers.google.com/apis/credentials. You need to enter a callback URI when you are creating the OAuth credentials. The callback URI is based on your survey URL. e.g. https://yoursite/surveys?task=sheets.integrate

Now the next step is to copy and add your OAuth Client ID and Client Secret values in the Community Surveys options. Go to Components -> Community Surveys -> Click on the Options button on the toolbar -> Click on the Integration tab -> Enable the Google Sheets Integration option and add your OAuth details here.

That’s all, your site is enabled for Google Sheets integration and you can authorize Google Sheets with your surveys. Go to the Edit Questions page of your survey and click on the Sheets button. This will take you to your Google login page, authenticate with your GMail ID and you are good to go. A new sheet is created at your Google Sheets page https://sheets.google.com/. When a user responds to your survey, a new row is added to the sheet.

Minimum System Requirements

With this release, we are moving away from the unsupported, legacy PHP5 versions, and the minimum PHP v7.2.5 or later is required. If you are still using an outdated version of PHP, we strongly recommend you upgrade your version as soon as possible.

Please do let us know your feedback and suggestions. We hope the new features help you with your business, please share your review and rating on the Joomla Extension Directory.