Identify and Process New Google Sheets Rows

This workflow automates the identification of new rows added to a Google Sheet by leveraging a dedicated 'Processed' column and a unique row ID (e.g., 'ID' column). It starts with a manual trigger, reads all rows from the specified sheet, and uses an IF node to filter only those where the 'Processed' field is empty. New rows proceed to a customizable action (currently a NoOp placeholder for your logic, like notifications or integrations), then updates the 'Processed' column with a timestamp.

Benefits include avoiding duplicate processing, ensuring efficient data handling for growing lists, and scalability for recurring executions via cron or webhooks. It's ideal for to-do lists, lead tracking, inventory updates, or any append-only sheet, saving hours of manual checks.

Use cases: Monitor new tasks in a team to-do sheet and notify via Slack/Email; process fresh CRM leads without duplicates; track e-commerce orders or form submissions. Customize column names, sheet ID, and the 'Do something' node for integrations like email, databases, or APIs. Requires Google Sheets OAuth setup.