hi all, i am new and trying to work out my first workflow which is also a template
i am having issue witha google sheet node, the error is the following
as you can see the trouble is:
Forbidden - perhaps check your credentials?
The caller does not have permission
Error details
From Google Sheets
Error code
403
Full message
{ "error": { "code": 403, "message": "The caller does not have permission", "status": "PERMISSION_DENIED" } }
Other info
Node type
n8n-nodes-base.googleSheets
Node version
4.5 (Latest version: 4.6)
n8n version
1.100.1 (Self Hosted)
Time
7/5/2025, 1:12:17 PM
Stack trace
NodeApiError: Forbidden - perhaps check your credentials? at ExecuteContext.apiRequest (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-nodes-base@file+packages+nodes-base_@[email protected]_asn1.js@5_1af219c3f47f2a1223ec4ccec249a974/node_modules/n8n-nodes-base/nodes/Google/Sheet/v2/transport/index.ts:78:9) at processTicksAndRejections (node:internal/process/task_queues:105:5) at GoogleSheet.spreadsheetGetSheet (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-nodes-base@file+packages+nodes-base_@[email protected]_asn1.js@5_1af219c3f47f2a1223ec4ccec249a974/node_modules/n8n-nodes-base/nodes/Google/Sheet/v2/helpers/GoogleSheet.ts:129:21) at ExecuteContext.router (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-nodes-base@file+packages+nodes-base_@[email protected]_asn1.js@5_1af219c3f47f2a1223ec4ccec249a974/node_modules/n8n-nodes-base/nodes/Google/Sheet/v2/actions/router.ts:43:20) at ExecuteContext.execute (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-nodes-base@file+packages+nodes-base_@[email protected]_asn1.js@5_1af219c3f47f2a1223ec4ccec249a974/node_modules/n8n-nodes-base/nodes/Google/Sheet/v2/GoogleSheetsV2.node.ts:30:10) at WorkflowExecute.runNode (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-core@[email protected][email protected][email protected][email protected]_/node_modules/n8n-core/src/execution-engine/workflow-execute.ts:1193:9) at /usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-core@[email protected][email protected][email protected][email protected]_/node_modules/n8n-core/src/execution-engine/workflow-execute.ts:1542:27 at /usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-core@[email protected][email protected][email protected][email protected]_/node_modules/n8n-core/src/execution-engine/workflow-execute.ts:2108:11
thank you so much
Was creation of the credentials successful for this api? The one you created for sheets account?
I went into Google Cloud and create api oath2 and used the mail i am logged in into n8n. I believe the credential creation was successful but i do not see the sheets icona on credential, could that be and indicator of failed creation?
A good indication of it being successful would be seeing success message when you create credentials and then the part of the screen turning green and not red.
Also if you go to credentials you should see green at the top, showing “Connected” and “Reconnect” button. Try reconnecting just in case the creds have expired or something.
yes, i have the green box with account conneted written inside, tried reconnecting but nothing changed
Would you like to attach some screenshots, maybe we can spot something?.. of the error, of the config, credentials window (obviously without the values themself).
Did you enable the Google Sheet API ?
Create OAuth API is step1.
Then you need to enable tha Google API for Google Sheet, Drive, Calendar, Gmail one by one.
sure, apprecitae a lot your help.
i enabled both sheets and drive api
when i noticed that last message saying that i had to enable both google sheet and drive api i enabled them, with sheet i also made all the stuff with oath ect, could the problem be the fact that i didn’t with drive api?
Yes, and every google tools inside n8n needs to re-auth. You can’t use only sheet authentication, even you’re working with only one google api.
hi there, i enabled all the google api trough google cloude console, worked out the id client and client secret but still the same error
some other screenshot of my acc
What error that you caught at?
i am sorry, didn t understand the question
Based on the screenshot you provided earlier, your issue might be related to the local host in the URL. You cannot use localhost for redirect URL, if you do, that’s the issue. This needs to be a public url google can use to redirect you back to n8n instance. You can use services like ngrok, Cloudflare tunnels, tunnelto, localtunnel to expose your localhost to outside.
Alternatively, if you are running your n8n in docker in one of the hosting solutions, you need to change the WEEBHOOK_URL env variable to point to your public url of n8n instance.
idk why but after i updated my versione the credential image showed up, come other nodes now work but that one keeps not working.
yes i am running locally n8n trough a docker, which of the stretgy u provided do u suggest
So if by locally you mean you run it yourself, then
- If you have a domain with cloudflare dns already - that would definitely be the best way to go.
- if not, I’ve heard good reviews of zrok and localtunnel, the other services - I only know of, never tried nor heard other people reviewing.
