n8n Workflow: Push JSON to Google Sheets or CSV

Push JSON API Data into Google Sheets or Download as CSV—Fast

This n8n workflow template fetches JSON from a generic API request and then pushes the results into Google Sheets or converts the same data into a .CSV file—so you can turn API responses into usable spreadsheets without manual work.

What this workflow does

• Loads/organizes JSON data into the workflow so it can be processed consistently.
• Performs a generic HTTP Request to retrieve JSON from an API endpoint.
• Pushes the JSON into Google Sheets to store and update spreadsheet data.
• Converts the JSON into a .CSV file when you need a downloadable spreadsheet format.
• Uses a flexible pattern that can be adapted to load data into other apps or export to other spreadsheet formats (for example, .xlsx), not just Sheets or CSV.

Use cases

• API-to-spreadsheet updates: automatically pull JSON from an endpoint and keep a Google Sheet current.
• Reporting & exports: generate a CSV snapshot from JSON for downstream analysis, sharing, or import into other tools.
• SaaS operations support: collect data from custom APIs and route it into spreadsheet formats your team already uses.
• Automation engineering templates: provide a reusable “JSON → spreadsheet” workflow pattern for new integrations.

Technical details

• Manual Trigger to run the workflow on demand.
• HTTP Request node to make a generic API call that returns JSON.
• Set node(s) and a Sticky Note for workflow setup and clarity.
• Google Sheets node to write JSON data into a spreadsheet.
• Spreadsheet File node to export data as a .CSV file.