Google Sheets - Data update fails intermittently

Questions
1

Describe the problem/error/question

I am using Google Sheets to process hundreds of data in a column A. It generates content which gets updated in the next column. I have tried adding a Column B which gets updated as Processing as soon as a data is picked up for processing but sometimes this does not get updated due to which the same row/data is repeatedly processed multiple times.
In the execution status all nodes are showing as success but data is not updated on the Google Sheet.
What is the best option to avoid this repetition of the same data multiple times.

What is the error message (if any)?

Google sheets is not getting updated due to which same data is processed multiple times.

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: 1.71.1
  • Database (default: SQLite): SQLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own, main
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Coolify
  • Operating system: Windows
2

I know this isn’t very helpful, but you should consider using a proper database stack. It is easier than it sounds.

In my opinion, there are issues that come up one way or another using spreadsheets

if your self hosted you can use redis or baserow which has a rich UI like airtable

if not self hosted you can use something like google cloud firestore which also has a UI

They are much more flexible and scalable.

Unfortunately, without you sharing your workflow, there is not much we can do in terms of trying to reproduce your error

3

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