Automated Monitoring & Marking in Google Sheets

somdn_product_page

This n8n workflow automates the process of monitoring a Google Sheet for new entries and marking them as processed automatically. It begins with a manual trigger for testing, but primarily runs every 5 minutes, reading data from a specified Google Sheet. The workflow checks if each row has already been processed by examining the ‘Processed’ cell. If a row is new (unprocessed), it performs an action (placeholder node) and then updates the row, marking it as processed with a timestamp. This setup is ideal for automating data review, monitoring, or ensuring data integrity in workflows that involve spreadsheet management.

Node Count

6 – 10 Nodes

Nodes Used

googleSheets, if, interval, manualTrigger, noOp, set

Reviews

There are no reviews yet.

Be the first to review “Automated Monitoring & Marking in Google Sheets”

Your email address will not be published. Required fields are marked *