Collect API User Data and Store in Google Sheets with CSV Backup

🧠 Overview

This workflow automatically fetches user data from an API, formats it, and stores it in Google Sheets and CSV files.

💡 Use Cases

Collect user records for analytics or reporting Maintain centralized spreadsheets for marketing or CRM Export CSV backups for offline analysis or integrations

📘 Good to Know

Uses the BASEURL environment variable for the API endpoint Google Sheets integration requires OAuth2 credentials CSV export saves a local copy for backup or external use Optional error handler ensures the workflow stops safely if any step fails

⚙️ How It Works

Manual Trigger – Start the workflow manually or via schedule HTTP Request – Fetch data from the API endpoint Set Node – Extract and format fields like name (first + last) and country Google Sheets – Append processed data to a Google Sheet