Automate User Data Sync and Distribution
detail.loadingPreview
This workflow automates the fetching of random user data, its processing into structured formats, and its distribution via Google Sheets and email. It ensures your data management and communication processes are streamlined.
About This Workflow
This n8n workflow is designed to automate the process of acquiring, structuring, and distributing user data. It begins by fetching random user profiles from an external API. This raw data is then transformed into a more usable format, extracting key information like full names and countries. The processed data is subsequently synchronized with a Google Sheet for structured storage and analysis. Furthermore, the workflow converts the data into both CSV and JSON formats, creating downloadable files. Finally, these generated files are attached to an email, providing a comprehensive distribution mechanism. This automation significantly reduces manual effort in data handling and communication.
Key Features
- Automated Data Fetching: Seamlessly pulls data from external APIs.
- Data Transformation: Processes raw data into structured fields (name, country).
- Multi-Format Output: Generates data in CSV and JSON formats.
- Cloud Integration: Syncs data directly to Google Sheets.
- Automated Distribution: Sends data files via email.
How To Use
- Configure HTTP Request: Set the API endpoint URL to fetch user data (e.g.,
https://randomuser.me/api/). - Map Data with Set Node: Define the output fields (e.g.,
name,country) and map them to the corresponding data points from the HTTP Request node using JSONPath expressions. - Sync to Google Sheets: Connect your Google Sheets account, specify the
sheetIdandrange(e.g., 'A:C'), and choose the 'append' operation to add new data. - Convert to CSV: Use the 'Spreadsheet File' node to convert the data into a CSV format, specifying a
fileName. - Convert to JSON: Utilize a 'Spreadsheet File' node (set to JSON output) followed by 'Move Binary Data' (with
jsonToBinarymode) to prepare the data as a JSON file. - Write JSON File: Use the 'Write Binary File' node to save the generated JSON file locally.
- Send Email with Attachment: Configure the 'Gmail' node to send an email, subject, and message. Attach the generated JSON file by referencing the output from the 'Write Binary File' node.
- Append to Google Sheets (Again): Use a second 'Google Sheets' node to append the processed data to your sheet, ensuring data consistency across different outputs.
Apps Used
Workflow JSON
{
"id": "d9ba2b73-da0a-4f8b-a847-917ce2e3d2e4",
"name": "Automate User Data Sync and Distribution",
"nodes": 17,
"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: d9ba2b73-da0a...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade 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.