Data extraction and storage from Random User to Google Sheets and CSV

• Automate user data collection from Random User generator
• Store user information in Google Sheets for easy access
• Generate CSV files for offline data storage
• Facilitate data analysis and reporting by organizing user data

Fetch random user data via HTTP request Extract and format user information using a Set node Append formatted data to Google Sheets Convert user data into a CSV file Send the CSV file via email as an attachment

1. 1
   Import the workflow template into your n8n instance
2. 2
   Configure Google Sheets authentication and specify the sheet ID
3. 3
   Set up Gmail authentication for sending emails
4. 4
   Adjust the HTTP request parameters if needed
5. 5
   Run the workflow to test data extraction and storage