Import JSON API Data to Google Sheets & CSV - n8n Workflow | Neura Market
Import JSON API Data to Google Sheets & CSV
Fetches data from an API like randomuser.me, extracts key fields, and exports to Google Sheets and CSV file for easy storage and analysis.
This n8n workflow automates the process of importing JSON data from an external API into both Google Sheets and a CSV file. It starts with an HTTP Request node that pulls data from https://randomuser.me/api/, which generates random user information. A Set node then parses the JSON response to extract the user's full name and country, simplifying the data for output.
The workflow branches from the Set node: one path appends the parsed data to a specified Google Sheets range (A:C) using OAuth2 au
Platform
n8n
Category
Health & Fitness
Price
$9.99
Creator
Maxim Luong
json
api
google-sheets
csv
data-import
http-request
export
spreadsheet
automation
productivity
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.