Process only new records
Schedules and retries mean the same data can arrive twice. Without a guard, duplicate rows stack up and every downstream report drifts from reality. An idempotent write step prevents that.
Add a Data Table Get row(s) node before the insert, then a Code filter that compares city and date — only new pairs reach the writer.
This exercise is part of the course
Intermediate Workflow Automation with n8n
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise