I have a 3-year old survey with a google sheet integration. I’ve never had issues before but any response submitted after 20/04 has stopped transferring to the sheet. Any advice on how to troubleshoot or re-connect? I am hesitant to make any changes as the data has many other integrations.
Best answer by Grace
View original
+5
Hi
+5
Hey
Liz is off for the rest of the week so I’ve been doing some investigating. It looks like the limit in 2 million cells per sheet, this includes cells from other tabs and any existing cells from before the integration was set up.
If that’s not it, the integration can be sensitive so it might be worth looking at our troubleshooting article here.
Have you made any changes on your Google account recently? That can sometimes have an effect apparently!
+5
Our support team usually recommend the following when the connection breaks:
First fully disconnect the integration.
Then, when you set it up again, choose "add new account" instead of the one already listed in the integration. You can still use the same account, but by adding it new, we're refreshing the authority to connect with your Google account.
You can connect the form(s) to the existing sheet in a new tab if you like, but before you do, it is important that you rename the "broken" tab to anything else. This is because the integration will name a tab in the Google sheet with the same name as your form, and if there already exists a tab with the same name, the integration cannot be completed.
Hopefully this helps and you can get the integration back up and running again, but let us know if you still have issues!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.