Import JSON data into Google Sheets and CSV file
Ready for 3.0Ready 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 4 nodes and runs from “HTTP Request” (no trigger node, so run it manually or call it from another workflow). Along the way it connects Google Sheets. It also calls randomuser.me over HTTP.
How it runs
Trigger: From “HTTP Request” (no trigger node, so run it manually or call it from another workflow).
- HTTP Request: calls randomuser.me
- Set (Edit Fields (Set)): sets or maps fields
- Google Sheets: append
- Spreadsheet File: reads or writes a spreadsheet file (legacy node)
Services it uses
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 (4)
- HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Spreadsheet File
n8n-nodes-base.spreadsheetFile
From the author
This workflow gets data from an API and exports it into Google Sheets and a CSV file.