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.