Process New Google Sheet Rows with Metadata
detail.loadingPreview
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 sheetnode connects to your Google Sheet (specified bysheetId) 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 valuenode. - If Not New (False): The workflow proceeds to the
Do something herenode (which currently does nothing but can be replaced with custom logic).
- If New (True): The workflow proceeds to the
- Set Processed Value: The
Set processed valuenode adds a timestamp to the 'Processed' field for the current row. - Mark Row as Processed: The
Mark Row as processednode updates the Google Sheet with the new timestamp in the 'Processed' column, effectively marking the row as handled.
Apps Used
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.
Get This Workflow
ID: 4db354ce-5bdf...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
Automated Google Drive Backup for n8n Workflows
Automatically back up n8n workflows to Google Drive on a schedule.
Dynamic Prompt Generation from GitHub with Language Model Integration
Fetches prompts from a GitHub repository, substitutes variables, and processes them with an AI agent.
Inventory Slack Alert Workflow
Triggers an alert based on inventory changes, processes data using RAG, and logs results.