Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Files & Cloud Storage

Files & Cloud Storage

Convert JSON Data to CSV Files Using Google Sheets on Manual Run

Manually triggered workflow that trims JSON output with a Set node, flattens it, and converts it to a CSV spreadsheet file, which can be changed to other formats such as XLS.

Import it free Sign in to open it

What it does

### JSON to .CSV We use the Set node to trim down the data that we convert to CSV file format (and flatten it from it's previous object-like data structure). Change settings in Spreadsheet File node to convert to .xls etc.

The steps

  1. HTTP Request
  2. Spreadsheet File
  3. When clicking "Execute Workflow"
  4. Google Sheets
  5. Set

Similar automations

Files & Cloud StorageConvert Parquet, Avro, ORC and Feather Files to JSON14 stepsFiles & Cloud StorageConvert Parquet, Avro, ORC and Feather Files to JSON3 stepsFinance, Invoices & AccountingConvert Venmo CSV Statements to QuickBooks Import Files7 stepsFiles & Cloud StorageConvert a CSV from a URL to Excel4 steps