Process New Google Sheet Rows with Metadata

Name: Process New Google Sheet Rows with Metadata
Rating: 5 (5 reviews)
Author: Free N8N

Advanced

23 nodes connected

detail.loadingPreview

Free N8N Temples

331 views

33 downloads

Automationautomationdata processinggoogle sheetsschedulingworkflow

Automatically processes new rows in a Google Sheet, marking them as processed and allowing for subsequent actions.

About This Workflow

This workflow is designed to efficiently manage and process data from a Google Sheet. It triggers either manually or on a schedule, reads rows from a specified sheet, checks if a row has already been processed, and if not, marks it as processed before updating the sheet. This ensures that each row is handled only once.

Key Features

Scheduled or Manual Trigger: Can be initiated automatically every 5 minutes or manually via an 'execute' button.
Google Sheets Integration: Reads data from and writes data back to a Google Sheet.
Row Processing Logic: Identifies new rows by checking for an empty 'Processed' column.
Metadata Timestamping: Adds a timestamp to the 'Processed' column to mark a row as handled.
Conditional Logic: Uses an 'If' node to differentiate between new and already processed rows.
Extensibility: Includes a 'NoOp' node for easy integration of additional processing steps.

How To Use

Trigger: Start the workflow manually by clicking 'execute' or rely on the 'Run every 5 minutes' schedule.
Read Sheet: The Read sheet node connects to your Google Sheet (specified by sheetId) and retrieves its content.
Check if New: The Is new? node checks if the 'Processed' column for each row is empty. If it's empty, it's considered a new row.
Conditional Branching:
- If New (True): The workflow proceeds to the Set processed value node.
- If Not New (False): The workflow proceeds to the Do something here node (which currently does nothing but can be replaced with custom logic).
Set Processed Value: The Set processed value node adds a timestamp to the 'Processed' field for the current row.
Mark Row as Processed: The Mark Row as processed node updates the Google Sheet with the new timestamp in the 'Processed' column, effectively marking the row as handled.

Apps Used

automation

data processing

google sheets

scheduling

workflow

Workflow JSON

{
  "id": "4db354ce-5bdf-41d1-9800-633e4d5dc79a",
  "name": "Process New Google Sheet Rows with Metadata",
  "nodes": 23,
  "category": "Automation",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.