Michael Seymour asked 9 months ago
We worked through the steps on the instructional for integrating with Google sheets, but are still getting an error when we try to tie it to our form.
As far as I understand, we have set up everything required, but are still unable to link the sheet.
This is the error we are getting:
Oops! Please ensure you have enabled the Google Drive API and Google Sheets API in the Google cloud console.
Learn more.
The only thing I can think of is that we may need to \"push to production\" in google, but I\'m getting a warning saying that will make the app accesible to anyone with a Google account (not sure if we want that).
Any guidance someone can offer on this would be greatly appreciated.
Thank you!
Natalia Relish answered 9 months ago
Here are some steps to solve it:
Activate the Google Drive API and the Google Sheets API in the Google Cloud Console. I hope your projects are linked in the API details.
Your API permission screen is set up correctly.
If you have worries about pushing to production, set an authorization code permission screen outside while restricting access to certain users under
I hope this will be helpful for you.
Andrea Ferrari answered 7 months ago
I have the same problem, I have configured every single aspect of the api and the error is always:
The Google API connection failed. Please check the permissions in the Google API console.
The permissions are correct and there are no anomalies in the data.
Please login or Register to submit your answer
did you ever figure this out? Mine disconnects every couple of weeks for no apparent reason 🙁