Identify new Google Sheets rows
This workflow identifies new rows in Google Sheets using a separate column keeping track of already processed rows.
For this approach to work, the sheet needs to meet two requirements: A unique identifier for each row is required A column used to differentiate new/processed rows is present
Our example sheet looks like this:
So the row identifier is named ID, the new/processed column is called Processed. Update the workflow accordingly if your columns have different names.
Now if the workflow runs, it discovers all three rows as new. After processing them, it will add a timestamp to the Processed column:
The next time the workflow is executed it will skip the existing rows and only process newly added data:
Related Templates
Demo Workflow - How to use workflowStaticData()
This workflow demonstrates how to use the workflowStaticData() function to set any type of variable that will persist wi...
Bulk Automated Google Drive Files Sharing and Direct Download Link Generation
This N8N workflow automates the process of sharing files from Google Drive. It includes OAuth2 authentication, batch pro...
USDT And TRC20 Wallet Tracker API Workflow for n8n
Overview This n8n workflow is specifically designed to monitor USDT TRC20 transactions within a specified wallet. It u...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments