Save to SpreadSheet node not working

[Yubing_Shi]

Describe the problem/error/question

The workflow takes invoices from google drive and uses Gemini API to extract data, then save to google spreadsheet. everything works except the last step - save extracted data to a google online spreadsheet. I’ve checked my Google developer consult where both google drive and spreadsheet API is enabled.

What is the error message (if any)?

Error code

403

Full message

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

Problem in node ‘Add to Google Sheets‘

Forbidden - perhaps check your credentials?

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:

[Gallo_AIA]

From the error it seems that the credentials are incorrect.

If the credentials are correct, perhaps a match column is missing in the spreadsheet to update the reference row.

Can you give more details of the workflow? How is the last node structured?

[Yubing_Shi]

the workflow starts with API integration with Google Drive (Google Cloud Credential]; then go through a few steps including OCR with Gemini API, with extracted data from OCR, there are steps to transform data into columns for spreadsheet.

Every step along the way works until save to Spreadsheet. I just checked google sheet and google drive API are both enabled. The columns are also matched.

I also set matching column mode as automatic.

Is this node supposed to use the same API credential as first step where Google drive is integrated?

[Gallo_AIA]

That’s right, the credentials are always the same.

What you described to me all seems coherent to me.

Does the Google Sheet file have special restrictions for which N8N cannot write on it?

[Yubing_Shi]

Oh, I don’t know what’s changed. but I re-created the node. it works now.

[Gallo_AIA]

the classic “turn it off and on” method.
It always works!