Google Sheets Forbidden - perhaps check your credentials? The caller does not have permission

Questions
1

I am really stuck it keeps saying for google sheets to Forbidden - perhaps check your credentials?
The caller does not have permission. i dont understand im on the paid version and this should automatically connect? I have checked google sheets and the setting to share are all ticked to allow access? i really dont know what to do. Im told that i dont need to do anyhting on google cloud console as im doing it through n8n and therefore authisation for credentials happens automatically?

40c38e8597511c6213dd65ab9034fbf4 (1)
40c38e8597511c6213dd65ab9034fbf4 (1)1856×858 140 KB

63b7f3814b46e2f033727df06506cf9e
63b7f3814b46e2f033727df06506cf9e1269×836 79.2 KB

88ebebe2e617081734d57a2310853b29
88ebebe2e617081734d57a2310853b291293×889 80 KB

Describe the problem/error/question

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
2

Idealy you need to setup a service account when connecting sheets node and then share the google drive folder or sheet with the service account email they generate for you

1 Like
3

The jason file i download do i copy that entirely and place into credentials into n8n? i can only open this file in visual studio code, from there i am copying and pasting it. is this correct? also do i need to allow https?

4

Ive added the serivice account to google cloud console. Ive added the details to n8n in credentials. it is stuck on testing. on chapgpt it said if it carries on for more than 2 minutes there is an error. i really dont know what the error is ive added the email address. ive added json file and removed " quotation marks. im at a loss. im very disappointed as i wanted to be able to use this its been almost 2 days and im unable to do what i wanted

5

Please can you help. Ive added cleared browser, opened it in incognito. its still not verifying the details from the google cloub consle for the service account? please can anyone help?

6

All the permissions are enabled on google sheets