Integrating Google Sheets with BlockSurvey allows you to send survey responses to a Google Sheet automatically in real-time. This is useful for tracking responses, collaborating with team members, and analyzing data efficiently.
Follow these steps to set it up:
After designing and publishing your survey, navigate to the Integrate screen in your survey.
Under the Integrations menu, click on the Connect button for Google Sheets.
Click on the Connect Google Account button.
In the popup, choose the Google account you want to connect.
Click Continue to sign in to your selected Google account.
Grant permission to BlockSurvey to access your Google Sheets by clicking Continue.
Once permissions are granted, click on the Set up Google Sheet button.
A new Google Sheet will be created automatically with the same name as your survey title.
Click on View Google Sheet to open the newly created sheet.
Submit test responses, and you will see the data automatically added to the Google Sheet in real time.
If necessary, use the toggle switch to disable Google Sheets integration. Once disabled, new responses will no longer be sent to the sheet.
Click Remove Integration to disconnect the current Google Sheet.
Note: For security reasons, BlockSurvey does not support linking to an existing Google Sheet. Granting access to an existing sheet would require permission to view all your Google Drive files. To keep your data private, BlockSurvey only creates and manages a new sheet for each survey, ensuring other files remain secure.
Try it now! By following these steps, you can seamlessly integrate Google Sheets with BlockSurvey, ensuring your survey responses are automatically recorded for easy tracking, collaboration, and analysis.