This n8n workflow automates the process of fetching random user data, storing it in Google Sheets, converting data to CSV, exporting JSON files, and sending email attachments. It streamlines data collection and reporting tasks, making it ideal for onboarding processes, testing environments, or user information management.
The workflow starts by making an HTTP request to ‘https://randomuser.me/api/’ to fetch random user data. The ‘Set’ node extracts relevant details such as the user’s first and last names and country, organizing the data for future use. This data is then appended to a specified Google Sheet, ensuring real-time updates.
Next, the workflow converts the user data into a CSV file using the ‘spreadsheetFile’ node, which saves the data as ‘users_spreadsheet.csv’. Simultaneously, it prepares a JSON version of the user data, saved as ‘randomusers.json’ using ‘writeBinaryFile’ after converting JSON to binary format with ‘moveBinaryData’.
An email is then composed and sent via Gmail, with the JSON file attached, providing easy sharing of user data. Following that, the JSON data is appended to another Google Sheet, completing the data cycle.
This workflow is practical for automating regular user data collection, generating downloadable reports, or sharing data summaries via email. It saves time, reduces manual effort, and improves data handling consistency.
Reviews
There are no reviews yet.