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?