AcademyWorkflowsOperations

Sync data between several Google Spreadsheets

Operations teams that keep the same data in several shared spreadsheets.

  • Recommendedour rating
  • 3,337views on n8n
Open on n8n.io ↗

Paste it straight onto an n8n canvas with Ctrl+V or Cmd+V.

sync-data-between-multiple-google-spreadsheets.json

Loading the file...

What it does

This n8n workflow runs every two minutes and reads data from one Google Spreadsheet, columns A to G in the example. It writes the same rows, unchanged, into two other spreadsheets that use the same sheet name and columns. Expressions can be added to the nodes if the copied data needs changes.

Use cases

  1. 01Keep a master sheet copied to other files
  2. 02Share one data source with a second team's file
  3. 03Mirror a tracking sheet into a backup spreadsheet

Connects

Google Sheets

Questions about
Sync data between several Google Spreadsheets.

What is Sync data between several Google Spreadsheets used for?

Operations teams that keep the same data in several shared spreadsheets. This n8n workflow runs every two minutes and reads data from one Google Spreadsheet, columns A to G in the example. It writes the same rows, unchanged, into two other spreadsheets that use the same sheet name and columns. Expressions can be added to the nodes if the copied data needs changes.

How do I import Sync data between several Google Spreadsheets into n8n?

Copy the workflow JSON from this page and paste it onto the n8n canvas with Ctrl+V or Cmd+V. Then connect your credentials in each node.

Is Sync data between several Google Spreadsheets safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.