Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Google Sheets - "The caller does not have permission" error

  • September 14, 2021
  • 3 replies
  • 11113 views
C

Hi there,

I’m looking for some pointers on working with Google Sheets, let me outline the scenario..

I’m trying to update an attribute in my CRM (Sendinblue) for new contacts.​​​​​​ I’m taking these steps:

  1. Trigger - new contact created in Sendinblue
  2. Get a ‘code’ from a Google Sheet row (through Get many Spreadseat Rows)
  3. Update the contact attribute ‘XYZ’ with the code from Google Sheets

This connection seems to be working, however, on the Google Sheets step I’m getting the error ‘app returned “the caller does not have permission”. So it seems to me that Zapier can read the file, but somehow cannot return the information from the Google Sheet...

My Google Drive is connected to Zapier and to be sure I’ve set my Google Sheet to Public, but I’m still receiving the error and the attribute is not updating correctly.

 

Do you guys have any suggestions what to do here?

Best answer by SamB

Hey @Champ! :)

I believe the Create, Update, and Find/Create types of actions on the Google Sheets integration require full Editor permissions. So if the connected Google user account doesn’t have full edit permissions for the Google Sheet then that could be why you’re running into that “the caller does not have permission” error.

Can you double-check the permissions assigned for the connected user to confirm they have Editor permissions? 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • 34018 replies
  • September 14, 2021

Hi @Champ 

TIP: Make sure the GSheet tab is not locked with permissions (aka protected).

 

⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor
C
  • ChampBeginner
  • Author
  • Beginner
  • 1 reply
  • September 15, 2021

Hi @Troy Tessalone, thanks for the reply! Unfortunately it was not protected, so I’m afraid that isn’t the problem..

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 9662 replies
  • Answer
  • September 15, 2021

Hey @Champ! :)

I believe the Create, Update, and Find/Create types of actions on the Google Sheets integration require full Editor permissions. So if the connected Google user account doesn’t have full edit permissions for the Google Sheet then that could be why you’re running into that “the caller does not have permission” error.

Can you double-check the permissions assigned for the connected user to confirm they have Editor permissions? 

Terms & ConditionsAccessibility statement