Is the Google Sheets Node not working for anyone else (not a newbie)?

[sw2025]

Not a newbie to n8n - Have successfully used the G-sheets nodes many times in the past with the same credentials, never an issue.
Today I’m trying to create a new automation that requires using the G-Sheets nodes - cannot get them to work - no errors being received.
For example, I’m trying to use a simple ‘Append row in sheet’ operation…
As a test, I have entered fixed values, no expressions.
It will only output the data for the first column - nothing else is output.
I recorded this 1 minute loom video to explain the issue:

Version: 1.107.4
Would be very grateful for any insight on how to recolve this issue - cheers!

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:

[mohamed3nan]

Hi @sw2025,

The node is working as intended without any issues.

Could you try removing the items and refreshing it again?

[sw2025]

Hi Mohamed, thanks for your message.

Yes, I manually refreshed the columns to make sure they are an exact match.

Also, tried new G-Sheet nodes > refreshing the workflow > restarting my n8n instance.

Nothing has worked though, unfortunately…

To test further, I created an n8n cloud account on a free trial > added my G-Sheet credentials and tested again = the same issue.

As a further test, I created a make.com account > added my G-Sheet credentials + ran the same test and the data was added to the G-Sheet successfully.

I just recorded a new loom video to show you the tests & results between my n8n self host VS n8n cloud VS make.com

Its only working with make.com

This is happening with the ‘Append Row’ & ‘Update Row’ operations.

Thank you!

[mohamed3nan]

Hi @sw2025,

Thank you for confirming all these tests.

It looks a bit strange, but could you please try creating a new Sheet and running the workflow again, just to see if the issue persists?

[sw2025]

Thanks for checking it out, Mohammed.

This is a new sheet unfortunately, I’ve duplicated the original sheet 3 times for testing.

Also, deleted the nodes > refreshed the workflow > restarted my instance > tested it on n8n cloud too and the issue persists no matter what.

No idea what is going on… have you ever seen this before?

I’ve been using n8n for over a year with many G-Sheet operations and never encountered any issues before.

Not sure what to do.

[mohamed3nan]

Hi @sw2025,

Good news, I was able to replicate the issue exactly as you described

It comes down to how the columns are named!

For example, this column name contains a newline:

This will not be recognized by n8n which i do not know if it’s a bug or no..

However, the same name without a newline works correctly:

Please test it on your side and let me know if it works.

[sw2025]

Oh my, thanks a million!!

That is a strange one. I spent hours troubleshooting this.

Thank you so much for the guidance; it is working on my side too!

[Cardutaud]

That is why community builds for…. good job.

[mohamed3nan]

@sw2025 You’re most welcome!
If you don’t mind, could you please mark my reply as the solution?
That way, it’ll help others facing the same issue, and it also helps me on the leaderboard.
Thanks a lot!

[sw2025]

Done, thanks again!

[mohamed3nan]

Thank you, have a nice day!