Templates / Push JSON data into an app or to spreadsheet file

Push JSON data into an app or to spreadsheet file

Ready for 3.0

by n8n Team ✓ · 10,058 views · created 2023-07-03 · File Management

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 5 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls randomuser.me over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow”.

  1. HTTP Request: calls randomuser.me
  2. Google Sheets: append
  3. Set (Edit Fields (Set)): sets or maps fields
  4. Spreadsheet File: reads or writes a spreadsheet file (legacy node)

Services it uses

Google Sheets

HTTP calls to: randomuser.me

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

  • Still check Spreadsheet File (Spreadsheet File): Convert to File / Extract from File.

Nodes used (5)

From the author

This workflow template shows how to load JSON data into a workflow and push that data into an App or convert it into a Spreadsheet file. Specifically, this workflow shows how to make a generic API request that returns JSON. It then shows how to load that into…

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