Automated User Data Collection and Storage in Google Sheets

This n8n workflow automates the process of fetching random user data from an API, extracting specific information, and storing it in a Google Sheet. The workflow starts with an HTTP request to the Random User API, which retrieves randomized user details. The ‘Set’ node then extracts the user’s first and last name, along with their country, from the JSON response. These details are appended to a Google Sheet for record-keeping or further analysis. Additionally, a CSV file is generated from the data, providing a downloadable or shareable format for offline use or data export. Notes are added throughout the workflow for clarity, making it easy to understand the data flow. This process is useful for generating sample user data for testing, populating demo databases, or automating volunteer or participant data collection for research projects.