Templates / Sync data between multiple Google Spreadsheets

Sync data between multiple Google Spreadsheets

Needs changes

by Jan Oberhauser ✓ · 5,080 views · created 2019-08-31 · File Management

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

What this workflow does

This workflow has 4 nodes and runs on a schedule (legacy Cron node). Along the way it connects Google Sheets.

How it runs

Trigger: On a schedule (legacy Cron node).

  1. Read Sheet (Google Sheets): uses Google Sheets
  2. Write Sheet (Google Sheets): update
  3. Write Sheet (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:

  • Cron: replace with Schedule Trigger.

Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).

Removed in 3.0Replace with
Cron
Cron
Schedule Trigger

Nodes used (2)

From the author

1. Triggers workflow all two minutes 1. Reads data from a Google Spreadsheet (in example Sheet Data columns A to G) 1. Write the data unchanged in two different Spreadsheets with same Sheet name and columns, expressions are optional)

Excerpt from Jan Oberhauser'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.