Collect API user data and store in Google Sheets with CSV backup
n8n7 modulesv1.0Overview This n8n workflow automates the process of fetching user data from an API, verifying its validity, transforming the response, and then saving it to Google Sheets for team collaboration. Additionally, it generates a CSV backup file of the same data for offline access or external integrations. Perfect for developers, analysts, or teams who want an automated, no-code data ingestion and backup solution. --- ⚙️ Key Features 🔌 Fetches data from any REST API endpoint (e.g., RandomUser API) ✅
At a glance
Collect API user data and store in Google Sheets with CSV backup is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Slack, Google Sheets, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Slack, Google Sheets, Google Drive, Dropbox, Telegram
- Modules
- 7
- Price
- Free
- Version
- v1.0
About this workflow
Overview This n8n workflow automates the process of fetching user data from an API, verifying its validity, transforming the response, and then saving it to Google Sheets for team collaboration. Additionally, it generates a CSV backup file of the same data for offline access or external integrations. Perfect for developers, analysts, or teams who want an automated, no-code data ingestion and backup solution. --- ⚙️ Key Features 🔌 Fetches data from any REST API endpoint (e.g., RandomUser API) ✅ Validates successful API responses before processing 🧠 Transforms JSON response into simple key-value pairs (name and country) 📊 Appends data directly into Google Sheets 💾 Generates a downloadable CSV backup file 🧱 Modular design — easily customizable and extendable --- 🧱 Workflow Steps 1. Start Workflow Manually (Manual Trigger Node) The workflow starts manually by clicking Execute Workflow. You can later replace this with a Cron or Webhook trigger for automation. --- 2. Fetch User Data from API (HTTP Request Node) Makes an HTTP GET request to the configured API endpoint defined in the environment variable BASEURL. Example: This node fetches raw user data in JSON format. --- 3. Verify API Response Success (If Node) Checks if the API response returned an HTTP 200 status code. ✅ If status = 200 → Continue processing data ❌ If status ≠ 200 → Trigger Stop and Error node to halt execution This prevents saving invalid or failed responses. --- 4. Transform API Data to Name and Country (Function Node) Formats the raw JSON data to extract key details (name and country) from each user record. Input Example: Output Example: This step makes the data compatible with Google Sheets. --- 5. Append Data to Google Sheets (Google Sheets Node) Appends the formatted data to your specified Google Sheet. Environment Variables Required: GOOGLESHEETID → ID of your target Google Sheet Configuration: Range: A:B Columns: Name (A) and Country (B) Example Google Sheet: | Name | Country | | ---------- | ------------- | | John Doe | United States | | Jane Smith | Canada | --- 6. Create CSV Backup File (Spreadsheet File Node) Generates a .csv file named usersbackupexport.csv containing all saved user data. This file can be: Stored locally Sent via email Uploaded to cloud storage (e.g., Google Drive, Dropbox) Used for external analytics tools --- ⚠️ Error Handling If the API response is invalid (non-200), the Stop on API Failure node halts the workflow and logs the error: > ❌ API request failed — status code not 200. Workflow stopped. This ensures only valid data is stored. --- 🧰 Setup Instructions 1. Add Environment Variables: 2. Add Credentials: Google Sheets OAuth2 credentials API (if authentication is required) 3. Run Workflow: Start manually or configure a Cron node to run periodically 4. Check Output: Data appears in your Google Sheet CSV file is created in n8n’s file system --- 🧩 Customization Options | Goal | How to Modify | | ----------------------- | ----------------------------------------------------------------- | | Change API fields | Edit Transform API Data function to extract desired fields | | Add columns | Expand output object and update Google Sheets range (e.g., A:D) | | Automate execution | Replace manual trigger with a Cron or Webhook node | | Filter users | Add an If node after transformation to include/exclude data | | Send email notification | Add Gmail or SMTP node after CSV creation | --- 🧠 Example Use Case A recruiter fetches random candidate data daily from an HR API. Data (Name + Country) is saved to Google Sheets. A CSV backup is automatically generated for offline analysis. --- ✅ Benefits Hands-free automated data collection Centralized storage in Google Sheets for team access Built-in CSV export for reporting and backups Protects data integrity with API validation Fully customizable for any API format --- ✨ Tip: Add a Slack or Telegram node at the end to notify your team whenever new data is added successfully!
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Create BKP and FIK codes from new Google Sheets spreadsheet rows and send them to customers via Twilio
AI recruiter – analyze multiple CVs vs job description using OpenAI GPT
Real-time email RAG assistant with Gmail, OpenAI GPT, and PGVector
Auto-generate SEO blog posts with Perplexity, GPT, Leonardo & WordPress
Extract & transform HackerNews data to Google Docs using Gemini 2.0 flash
Complete business WhatsApp AI-powered RAG chatbot using OpenAI
🤖🧠 AI agent chatbot + LONG TERM memory + note storage + Telegram
AI-powered Upwork cover letter generator – Pinecone, Groq, Google Gemin, SerpAPI
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you