How to Process Only New Updates to the Spreadsheet?

Hello!! I need the workflow to process only the new updates in the spreadsheet, avoiding the re-analysis of already processed responses. Currently, whenever the spreadsheet is updated, the workflow reprocesses all responses, including those that have already been analyzed. The workflow should ignore already processed responses and focus only on the new entries added after each workflow execution.

As a solution: I created a binary column in my spreadsheet called ‘statusstamp’ to identify whether a row has been analyzed previously or not. I managed to filter this information with N8N, but I’m facing issues updating the spreadsheet with the ‘true’ information in the ‘statusstamp’ column.

To start with, when the flow works, it skips a row in the spreadsheet and doesn’t update the exact field I need.

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:

The ‘matching on’ column needs to be a unique identifier.