Persistent issue of data not being appended/updated in groups of cells for google sheets

Questions
1

I have my workflow append the final info into google sheets. It work most of the time, but sometimes the info just won’t append/update on the google sheets cell. This is a persistent issue over a large dataset of items (tens of thousands) with probably 1/20th of that having this issue. So it’s a significant problem. The actual issue seems to occur for a number of cells (10-20ish) then resolves itself. It also appears to randomly just happen at any given moment as I have some cells that remain blank as just one offs.

There’s no error message, flow works fine otherwise. This has been an issue since version 1.12.

Workflow JSON:

I get character capped when I try to paste my node. It also does not accept the standard downloaded JSON file? what’s up with that. Here’s a screenshot at least of the node, and the missing output. You can see that it just seems to not work for a number of rows then picks backup.

image
image1857×603 128 KB

image
image1859×866 76.4 KB

Share the output returned by the last node

Information on your n8n setup

  • n8n version: newest
  • Database (default: SQLite): SQlite
  • n8n EXECUTIONS_PROCESS setting (default: own, main): defualt
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker (Oracle, Cloudflare, Coolfiy with SSH)
  • Operating system: Windows 10
2

Are you updating/appending in batches or one by one?

Maybe you hit some API limits on ggl.

Can you share an image with the nodes or json?

3

One by one. I’m not at my computer rn but I’ll send tomorrow.

however, I tentatively might’ve found the issue… I need to test. But I noticed I do have duplicate leads, so I’m thinking maybe it doesn’t know where to append since there’s multiple rows with the same data. Only a thought I just noticed but that might be it.

so I’ll build a quick deduper with the http, or maybe instead of using the native ggl sheets node I can just use http to program it a bit more in depth .