Zapier successfully connects to Google Sheets and loads my file (spreadsheet) however, when i try to select which tab (worksheet) i want for my zap, i get an error saying “Unable to load choices”
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+11- Community Manager
Hello there
Is the spreadsheet that’s selected on a Team or Shared Drive? If yes, I’d suggest double-checking the permissions you have for it to make sure you’ve got full access to be able to both view and edit it.
If that doesn’t work and it’s not a spreadsheet that you created, then perhaps you could try making a copy of that spreadsheet and connect the Zap to that? Then share the copied version back to the person that created the original file so that they have access to it?
Please let me know whether either of those suggestions work, or if you’re able to find a different solution here!
Same problem here. I created the spreadsheet on my google drive and gave editor access to all but still error
+6- Zapier Staff
Hi
If you've changed the permissions on the Google Sheets account and the changes don't seem to be taking effect, one thing you could try is reconnecting your account here: https://zapier.com/app/connections/google-sheets. This might help refresh the connection and update the permissions.
Hope that helps! Let us know if you have any other questions. 😊
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.