Push JSON data into an app or to spreadsheet file
Ready for 3.0What 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”.
- HTTP Request: calls randomuser.me
- Google Sheets: append
- Set (Edit Fields (Set)): sets or maps fields
- 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 (5)
- HTTP Request
n8n-nodes-base.httpRequest - Spreadsheet File
n8n-nodes-base.spreadsheetFile - Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set
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…