Fetch Random User Data and Export to Spreadsheet/CSV

Name: Fetch Random User Data and Export to Spreadsheet/CSV
Rating: 5 (5 reviews)
Author: Free N8N

Intermediate

14 nodes connected

detail.loadingPreview

Free N8N Temples

238 views

20 downloads

Data Managementapicsvdata processingexportgoogle sheetsrandom user

Fetches random user data from an API and exports it to Google Sheets and a CSV file.

About This Workflow

This workflow demonstrates how to retrieve random user data using the randomuser.me API. The fetched data is then processed and can be exported in two ways: directly to a Google Sheet or formatted and saved as a CSV file. It also includes helpful notes for understanding and customizing the workflow.

Key Features

Fetches data from a public API (randomuser.me).
Integrates with Google Sheets to append data.
Converts and exports data to a CSV file.
Provides visual guides through Sticky Notes.
Uses a manual trigger for execution.

How To Use

Prerequisites: Ensure you have a Google Sheets account and have authorized n8n to access it.
Trigger: The workflow is initiated by clicking the "Execute Workflow" button.
Data Fetching: The HTTP Request node fetches random user data from https://randomuser.me/api/.
Google Sheets Export:
- The output from the HTTP Request node is directly fed into the Google Sheets node.
- The Google Sheets node is configured to append data to a specified Google Sheet.
- You need to have a Google Sheets credential set up and the documentId and sheetName correctly configured.
CSV Export:
- The Set node processes and formats the fetched data, selecting specific fields like 'Full Name', 'Country', and 'email'.
- The processed data is then passed to the Spreadsheet File node, which converts it into a CSV file named 'users_spreadsheet'.
Customization:
- To use a different API, modify the URL in the HTTP Request node.
- To change the data exported to CSV, adjust the values in the Set node.
- To modify the Google Sheets export, update the columns and sheetName/documentId in the Google Sheets node.
- Replace the manualTrigger with a scheduleTrigger for automated execution.

Apps Used

api

csv

data processing

export

google sheets

random user

Workflow JSON

{
  "id": "6e6cee9a-f969-46cb-b389-8933f7602dc9",
  "name": "Fetch Random User Data and Export to Spreadsheet/CSV",
  "nodes": 14,
  "category": "Data Management",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.