Goal: Trying to add data to google sheet but executing the add query is throwing error "The caller does not have permission"
Steps: Tried re-autheticating the connection to sheet and even enabled public editor permission for the sheet but the error persisted.
Details: The query is like this
[{
'orderid':'test','chargeid':'test','custid':'test','empid':'test','orderdate':'test'
}]
If anyone can share pointers on how to resolve, that would be great. Thanks!
Hey @ravsgo, Welcome To the Retool Community!
I can try this demo using the following data:
[{
'orderid':'test','chargeid':'test','custid':'test','empid':'test','orderdate':'test'
}]
It works perfectly if you check and ensure your sheet name is correct.
If you encounter an error, could you provide a screenshot or more details to help me understand the issue better?
Hey, Thanks for the quick reply. I checked the sheet name and re-run, but still getting the error.
Attaching the snapshot here of error and also of the sheet.
Hello @ravsgo ,
This error occurs because the Google Sheet owner has not granted editor permissions.
Check the shared permission settings in your Google Sheet.
I am using the sheet as owner and have also provided editor access to anyone with link. Please see attached image. Am I missing something here?
Hello @ravsgo
Check your query permissions by selecting the Read and Write option.
Then, try re-authenticating. In the authorization, choose the appropriate account.
Hi @ravsgo,
Did the screenshot that @WidleStudioLLP shared for the resource level permissions resolve your issue?
