Convert API JSON Data to Google Sheets and CSV Files - n8n Workflow | Neura Market
Convert API JSON Data to Google Sheets and CSV Files
This workflow retrieves JSON data from an API and seamlessly integrates it into Google Sheets or converts it into a CSV file, providing flexibility in data management.
This workflow is designed to automate the process of fetching JSON data from an API and then processing it for storage in different formats. Initially, an HTTP Request node fetches data from the Random User API. The data can then be directly appended to a Google Sheets document or transformed into a CSV file using the Spreadsheet File node. The workflow demonstrates the use of n8n's Set node to format data before conversion, ensuring compatibility with various spreadsheet formats.
Platform
n8n
Category
Data & Analytics
Price
Free
Creator
Freya Hansen
set
stickyNote
httpRequest
googleSheets
manualTrigger
spreadsheetFile
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.