Collect allows you to sync your responses from Collect to a Google Sheet automatically. It saves time and help you create powerful analytical reports that update in real time.
There may be instances when your Google Sheet created through Collect does not open up or sync responses. In such cases, here are a few steps you can follow to troubleshoot:
1. Check if you have changed your Gmail account password (account integrated with Collect). If yes, ensure you sign in again with the same Gmail account. Follow this article to see how to set up Collect integration with Google Sheets.
2. Check If access to Collect is given from your Google account. Follow these steps to give access to collect as a third-party app on Google account
- Go to your Gmail account.
- On the top right corner, go to your profile present on the top right corner. You will be able to see an icon with the initials of your name. Next, click on "Manage your Google Account".
- Next, click on "Security" on the left side. Scroll down and check if your Collect account has access to Google account as a third party app.
- Click on Manage third-party access to add/remove the access or see more information.
3. If it still doesn't work, remove the integration and set it up again. Follow these steps to remove the Google Sheets integration with Collect.
Step 1 : Go to "Forms" on Collect and open up the form for which you would like to remove the integration.
Step 2 : Go to Settings on the top and click on "Integrations" on the left side.
Step 3 : Click on "View Integration". A pop appears. Click on "Remove Integration".
Step 4 : Click on "Remove" to confirm.
Step 5 : After removing the integration, you can set it up again. To Step up the Integration again, follow this article.