Problem with google sheet Credential

[Oxii]

Describe the problem/error/question

Hey I use a workflow with google sheet in it and one of my node work and the other doesnt (see image).

I don’t understand why because I enabled google slide, google drive and google sheet API

The only difference is one is append Row and the other is Update row

I am sorry if it’s easy to solve but it’s been 3 hours I am on this forum and documentation and impossible to find any solution…

What is the error message (if any)?

From Google Sheets

Error code

403

Full message

{
  "error": {
    "code": 403,
    "message": "The caller does not have permission",
    "status": "PERMISSION_DENIED"
  }
}

Information on your n8n setup

• **n8n version:**1.86.0
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• **Running n8n via (Docker, npm, n8n cloud, desktop app):**http://localhost:5678
• **Operating system:**mac

[Ekaitz_Garcia_Duran]

Sometimes, credential permissions needed in different nodes ara different and even having a credential set up, another instance of the node mey need different permissions and can end in an error, just as in your case. Just try clicking in the pencil and reconnecting to the platform. That will add the permissions needed in that node instance.

[Oxii]

thanks a lot for your help.
It didn’t work

[Olek]

Make sure you have access to the target doc. Prefer referencing docs by their ID rather than picking from the drop-down list. Same name doesn’t always mean same document.

Do you have any protected ranges on the target sheet?

[Oxii]

Hey, thanks for the help. I am sure that this is the same document and I don’t have protected ranges (I’ll double check)./

Thanks a lot for trying to help me, i’ll try another solution than google sheet, lots of people seems to have problem with google and n8n

[mohamed3nan]

Hi @Oxii

Are you sure you’ve configured the correct scopes for Google Sheets in GCP?

If you’re encountering an issue similar to the one described here: After create google sheet credential unable access my file?

you can try this solution:

N8n selfhosted on vps with own domain

It looks like you’re almost there! One extra step is to add the required OAuth scopes before clicking “Sign in with Google” Here’s a simple breakdown: First: Enable the needed API (for example, Google Drive): [image] [image] Then: Click here to check which scopes are needed: [image] After that: The “Sign in with Google” window will show the required scopes. You can search for and add each of them: [image] Finally: Continue with the “Sign in with Google” process.

[Paul_Yeo]

@mohamed3nan Thank you for your help alway.