AcademyWorkflowsData and reporting

Move data between JSON and spreadsheets

Operations and data teams that exchange structured data between apps and spreadsheets.

  • Recommendedour rating
  • 2,946views on n8n
Open on n8n.io ↗

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

move-data-between-json-and-spreadsheets.json

Loading the file...

What it does

An n8n workflow template that shows how to convert JSON data into a binary file. It then imports the JSON or the converted file into Google Sheets or a local spreadsheet, so structured data can move between these formats.

Use cases

  1. 01Import API results into a Google Sheet
  2. 02Convert JSON records into a spreadsheet file
  3. 03Reuse the conversion steps in another workflow

Connects

Google Sheets · HTTP Request · Gmail

Questions about
Move data between JSON and spreadsheets.

What is Move data between JSON and spreadsheets used for?

Operations and data teams that exchange structured data between apps and spreadsheets. An n8n workflow template that shows how to convert JSON data into a binary file. It then imports the JSON or the converted file into Google Sheets or a local spreadsheet, so structured data can move between these formats.

How do I import Move data between JSON and 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 Move data between JSON and 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.