Google sheets doesn't append a new row

Questions
1

I’ve recently made an automation that takes data from multiple sources and then by using “code” node creates a new object with the selected data and sends it to node “Google sheets append row” It was working fine until all of a sudden it stopped appending new rows despite the fact that n8n says that the node was executed successfully.
What can I do in this case?

automation
automation1382×617 72.5 KB

node
node500×112 5.15 KB

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

We use n8n cloud, all settings are default

4

Hey @wontsay welcome to the community.

Hmm would need more info but top of my head:
1) Check the workbook/worksheet hasn’t changed. Names and locations may have changed on the google side.
2) Check the permissions for Google OAuth haven’t changed.
3) What if you run just the last node with (pinned) data. Does it write now? Could it be intermittent or happens all the time? If intermittent, you could perhaps implement retry logic after the write to double check the entry was made.

1 Like
5

Hey,
It turned out that the google was saving the data at the very end of the sheet for some reason and i couldn’t see it. problem solved :slight_smile:

2 Likes
6

Thank you so very much.
Did you find a way to make the data get appended from the beginning like normal??
I was learning n8n and on the very first, simple 2 node automation this happened, i was almost on the verge of frustration :slight_smile:

7

I have the same issue, and I notice that this happens when the execution takes a lot of time ~1m (normal is 5 sec) so n8n shows “Succeeded” but in google sheet the row didn’t append

8

Same issue on my side running the same workflow multiple times with the same set of test documents (to be parsed by an llm and appended as a row to a gsheet), I always have actual failures (reported as ok) and sometimes the same document is ok sometimes not

edit : can confirm that all 5 documents are correctly treated if I replace the gsheet node by a Postgres one

9

i removed the artificially appended rows and then made the google shets api add it itself basically

10

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