Automate User Data Collection and Organization
detail.loadingPreview
Effortlessly collect random user data from an API and seamlessly organize it into Google Sheets or CSV files. This workflow automates the tedious task of data gathering, saving you time and ensuring data accuracy.
About This Workflow
This n8n workflow streamlines the process of acquiring and structuring user data. It begins by fetching random user information from the randomuser.me API. The retrieved data, specifically the user's full name and country, is then transformed and prepared using a Set node. Finally, this organized data can be directed to two powerful destinations: it can be appended directly to a Google Sheet for real-time collaboration and analysis, or it can be exported as a CSV file for broader compatibility and offline use. This automation is ideal for anyone needing to populate spreadsheets or datasets with external user information without manual intervention.
Key Features
- API Data Integration: Connects to external APIs like
randomuser.meto fetch live data. - Data Transformation: Selects and formats specific data points (name, country) for your needs.
- Google Sheets Integration: Appends data directly to your designated Google Sheet.
- CSV Export: Generates a downloadable CSV file of your collected data.
- Flexible Output: Choose to save data to either Google Sheets or a CSV file.
How To Use
- Configure HTTP Request: Set the
URLtohttps://randomuser.me/api/to fetch random user data. - Configure Set Node: In the
Valuessection, create two fields:name(using the expression={{$json["results"][0]["name"]["first"]}} {{$json["results"][0]["name"]["last"]}}) andcountry(using the expression={{$json["results"][0]["location"]["country"]}}) to extract and format the desired user information. - Configure Google Sheets Node (Optional): Select the
Google Sheetsnode. Authenticate with your Google account, specify yourSheet ID(e.g., 'qwertz'), and set theOperationtoappend. Ensure theRange(e.g., 'A:C') is correctly defined. - Configure Spreadsheet File Node (Optional): Select the
Spreadsheet Filenode. Set theOperationtotoFile, choosecsvas theFile Format, and define your desiredFile Name(e.g., 'users_spreadsheet'). - Connect Nodes: Draw connections from the
HTTP Requestnode to theSetnode, and from theSetnode to either theGoogle Sheetsnode or theSpreadsheet Filenode (or both, depending on your desired output).
Apps Used
Workflow JSON
{
"id": "a11e6279-5886-4403-b4e1-c01e3ff99952",
"name": "Automate User Data Collection and Organization",
"nodes": 20,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: a11e6279-5886...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.