AcademyWorkflowsData and reporting

Transform data in Google Sheets

Operations and finance teams that keep working data in Google Sheets and want some updates done automatically.

  • Recommendedour rating
  • 4,172views on n8n
Open on n8n.io ↗

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

transform-data-in-google-sheets.json

Loading the file...

What it does

An n8n workflow that works with a Google Sheets spreadsheet. It appends a new row, finds every row that contains a given value, updates matching rows by a key column and reads the data back. The example changes a value for all the rows of one city.

Use cases

  1. 01Append records sent by an external form
  2. 02Find all rows that match a value
  3. 03Update matching rows by an ID column

Connects

Google Sheets

Questions about
Transform data in Google Sheets.

What is Transform data in Google Sheets used for?

Operations and finance teams that keep working data in Google Sheets and want some updates done automatically. An n8n workflow that works with a Google Sheets spreadsheet. It appends a new row, finds every row that contains a given value, updates matching rows by a key column and reads the data back. The example changes a value for all the rows of one city.

How do I import Transform data in Google Sheets 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 Transform data in Google Sheets 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.