Push JSON Data to Google Sheets or CSV File

This workflow demonstrates a versatile method to load JSON data from an API into n8n and export it to popular formats like Google Sheets or CSV files. It starts with a manual trigger, fetches sample JSON data from a random user API, and then branches into two paths: one directly mapping data to Google Sheets without additional transformation, and another using a Set node to flatten and trim data before converting it to a CSV spreadsheet file via the Spreadsheet File node.

Key benefits include simplicity in handling JSON exports, no need for complex data prep in the Sheets path, and easy customization for other apps or formats like XLSX. It's ideal for automating data ingestion from APIs into productivity tools, saving hours of manual copying or scripting.

Use cases span reporting, data migration, and integrations: pull customer data into Sheets for analysis, export API results to CSV for sharing, or adapt for CRMs, databases, or e-commerce APIs. Despite a Travel category tag, it's broadly applicable to any JSON-to-spreadsheet automation in productivity workflows.