Templates / Identify new Google Sheets rows

Identify new Google Sheets rows

Needs changes

by Tom ✓ · 4,930 views · created 2022-07-08 · Document Extraction

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: Interval. 1 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 7 nodes and runs on a fixed interval (legacy Interval node) (plus 1 other trigger). Along the way it connects Google Sheets.

How it runs

Trigger: On a fixed interval (legacy Interval node) (plus 1 other trigger).

  1. Read sheet (Google Sheets): uses Google Sheets
  2. Is new? (If): checks a condition and branches into true / false
  3. Set processed value (Edit Fields (Set)): sets or maps fields
  4. Mark Row as processed (Google Sheets): update

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:

  • Interval in Run every 5 minutes: replace with Schedule Trigger.
Removed in 3.0Replace with
Interval
Run every 5 minutes
Schedule Trigger

Nodes used (6)

From the author

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…

Excerpt from Tom's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.