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
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.
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).
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?
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