Templates / Import a JSON file from Gmail into a spreadsheet

Import a JSON file from Gmail into a spreadsheet

Needs changes

by Lorena ✓ · 1,671 views · created 2022-06-30 · Document Extraction

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

What this workflow does

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

How it runs

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

  1. Gmail: get many
  2. move binary data (Convert to/from binary data): uses Convert to/from binary data
  3. write spreadsheet file (Spreadsheet File): reads or writes a spreadsheet file (legacy node)

Services it uses

Gmail

Before you upgrade to n8n 3.0

1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:

  • Convert to/from binary data in move binary data : replace with Convert to File or Extract from File.
  • Also check Spreadsheet File: Convert to File / Extract from File.
Removed in 3.0Replace with
Convert to/from binary data
move binary data
Convert to File or Extract from File

Nodes used (3)

From the author

This workflow imports a JSON file from an email attachment and saves the content into a spreadsheet.

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.