Templates / Export JSON file to Google Sheets

Export JSON file to Google Sheets

Needs changes

by Lorena ✓ · 2,461 views · created 2022-06-30 · File Management

Needs changes. This template uses 2 thing(s) that n8n 3.0 removes: Read Binary File, Convert to/from binary data. 2 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 3 nodes and runs from “read json file” (no trigger node, so run it manually or call it from another workflow). Along the way it connects Google Sheets.

How it runs

Trigger: From “read json file” (no trigger node, so run it manually or call it from another workflow).

  1. read json file (Read Binary File): uses Read Binary File
  2. move binary data (Convert to/from binary data): uses Convert to/from binary data
  3. Google Sheets: append

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:

  • Read Binary File in read json file: replace with Read/Write Files from Disk.
  • Convert to/from binary data in move binary data 2: replace with Convert to File or Extract from File.
Removed in 3.0Replace with
Read Binary File
read json file
Read/Write Files from Disk
Convert to/from binary data
move binary data 2
Convert to File or Extract from File

Nodes used (3)

From the author

This workflow exports the contents of a JSON file to Google Sheets.

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