AcademyWorkflowsData and reporting

Import JSON data into Google Sheets and CSV

Data and operations teams that need API results in a spreadsheet for reports.

  • Recommendedour rating
  • 7,298views on n8n
Open on n8n.io ↗

Paste it straight onto an n8n canvas with Ctrl+V or Cmd+V.

import-json-data-into-google-sheets-and-csv-file.json

Loading the file...

What it does

Gets data from an API with an HTTP Request node and writes it to a Google Sheet and to a CSV file. It keeps a copy of external data in a spreadsheet that the team can open, filter and share. Once the API address and the target sheet are set, the flow runs the same steps each time.

Use cases

  1. 01Export a list from an internal API to a sheet
  2. 02Keep a CSV copy of API data for a report
  3. 03Share API results with colleagues who do not code

Connects

Google Sheets · HTTP Request

Questions about
Import JSON data into Google Sheets and CSV.

What is Import JSON data into Google Sheets and CSV used for?

Data and operations teams that need API results in a spreadsheet for reports. Gets data from an API with an HTTP Request node and writes it to a Google Sheet and to a CSV file. It keeps a copy of external data in a spreadsheet that the team can open, filter and share. Once the API address and the target sheet are set, the flow runs the same steps each time.

How do I import Import JSON data into Google Sheets and CSV into n8n?

Copy the workflow JSON from this page and paste it onto the n8n canvas with Ctrl+V or Cmd+V. Then connect your credentials in each node.

Is Import JSON data into Google Sheets and CSV safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.