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:
- Trigger - new contact created in Sendinblue
- Get a ‘code’ from a Google Sheet row (through Get many Spreadseat Rows)
- 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 SamBView original
TIP: Make sure the GSheet tab is not locked with permissions (aka protected).
@Troy Tessalone, thanks for the reply! Unfortunately it was not protected, so I’m afraid that isn’t the problem..
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?