Import JSON API Data to Google Sheets & CSV | n8n

Import JSON API Data into Google Sheets (and Download as CSV) with n8n

This n8n workflow fetches data from a JSON API and exports the results into Google Sheets—while also generating a CSV file you can use anywhere.

What this workflow does

• Calls an external JSON API to retrieve the data you need.
• Processes and structures the API response so it can be written cleanly to a spreadsheet.
• Exports the data to Google Sheets for ongoing visibility and easy collaboration.
• Writes the same dataset to a CSV file for portability, backups, or downstream imports.

Use cases

• SaaS operations: Pull report data from a JSON API and keep a Google Sheets dashboard updated.
• Data coordination: Export CSV files for sharing with teams that don’t use Google Sheets directly.
• Automation engineers: Use as a reliable template for API-to-sheet ingestion pipelines.
• Recurring sync: Automate periodic API pulls to maintain an audit-friendly history in Google Sheets and CSV.

Technical details

• HTTP Request: Retrieves JSON data from your API endpoint.
• Set (and supporting nodes/fields): Prepares values for export.
• Google Sheets: Writes the formatted output into a Google Sheet.
• Spreadsheet File: Produces a CSV export alongside the Google Sheets update.
• Sticky Note: Used for workflow documentation and readability.

Ideal for n8n users, automation engineers, and SaaS operators who want a straightforward JSON API → Google Sheets + CSV integration without building the ingestion flow from scratch.