Community Surveys v5.7 & later versions support Google Sheets integration. When a survey is integrated with Google Sheets, the user responses are automatically synced in real-time with the selected Google Sheet. You can export the Google Sheet to an Excel file or create visualizations. So here is the process to integrate your surveys with Google Sheets.
Step 1: Create Google Credentials App
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-menu?task=sheets.integrate
Step 2: Update Google credentials in the Community Surveys options
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 Integrations tab -> Enable the Google Sheets Integration option and add your OAuth details here.
Your site is enabled for Google Sheets integration and you can authorize Google Sheets with your surveys.
Step 3: Connect your survey with a Google Sheet
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. If you are already logged in, it will automatically enable the integration when you click on this button.
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.
That’s all, your survey is connected to Google Sheets.