Data collection and storage from Random User Generator to Google Sheets and Email

• Automate user data collection from online sources
• Store random user information in Google Sheets for easy access
• Send user data via email for reporting or sharing purposes
• Generate CSV files for offline data management

Fetch random user data using an HTTP request Extract relevant user information with a Set node Append user data to Google Sheets for organization Generate a CSV file from the user data Save user data as a JSON file locally Send the JSON file via email as an attachment

1. 1
   Import the workflow template into n8n
2. 2
   Configure the Google Sheets credentials for OAuth2 authentication
3. 3
   Set the desired Google Sheets document ID and range
4. 4
   Adjust the email settings with Gmail credentials
5. 5
   Run the workflow to start collecting and sending user data