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.
Related Health & Fitness workflows
- Nutrition Tracker & Meal Logger with Telegram, Gemini AI, and Google Sheets$24.99
- Automated Telegram Command Filtering and Workflow Management$15.04
- Automate Food Calorie Tracking via Telegram with GPT-4 Vision and Google Sheets$4.99
- Automate Personalized Diet Plan Creation from Health Reports via Email$4.99
- Reinforced Learning Chatbot for Enhanced User Support$24.99
- AI-Powered Triathlon Coaching with Strava Data Analysis$9.99
More from Maxim Luong
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.