N8N Google Sheets Append Row Not Working

Hi, I tried everything but the Google Sheets node doesn’t create a new row in my Google Sheets document.
The authentication seems to be fine, I am able to retrieve the tables and columns, etc.
But when I check the Google Sheet nothing has changed, I have looked at the bottom of the sheet and there’s nothing either.

Please share your workflow


I am running it manually directly, but that’s my complete flow.

I also tried creating a new Sheet and it also doesn’t work there either.
I did the same steps as in this post: Connect N8N and Google Sheets in 5 MINUTES! (Updated for 2025)
(I don’t remember seeing anything for scopes but when I link my Google Account it says I am giving permissions to read and edit Sheets).

If I try to get rows in a different paper in that sheet that has rows, the node doesn’t return anything

Information on your n8n setup

  • **n8n version:**1.95.3
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):**Docker Compose
  • Operating system: Ubuntu

Thanks in advance :slight_smile:

Are you sure have successfuly linked your n8n with Google sheet and given the right permissions. You can try the whole process again

1 Like

Yes, I have done the full process a few times, and after the Sign In with Google button I get the Linked Successfully message.

Take a look at the screenshot you shared. Your if check is going to false which is preventing the Google sheet node from running

check why it’s going to false or temporarily remove the if and see if that works for you

I am running the Node directly by clicking on Execute Step.

running it like that still relies on previous nodes data, so it will act the same way as testing from the canvas.

Try what i suggested by removing the if temporarily to see if it works.

You were right, setting up a webhook node and calling it made the workflow work.
I appreciate the help so much, thanks liam <3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.