AcademyWorkflowsData and reporting

Load Data into a Spreadsheet or Database

Operations and data teams who need to write workflow results into a table or database.

  • Recommendedour rating
  • 3,615views on n8n
Open on n8n.io ↗

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

load-data-into-spreadsheet-or-database.json

Loading the file...

What it does

A generic n8n workflow that shows how to write data from a workflow into a spreadsheet, a CSV file or a relational database. Each item needs a key for every column, so a Set or Function node reshapes the data first. The template also explains how nested arrays can be split into separate items before they are appended or inserted.

Use cases

  1. 01Append form responses to a Google Sheet
  2. 02Insert records into a MySQL table
  3. 03Export a list of items to a CSV file

Questions about
Load Data into a Spreadsheet or Database.

What is Load Data into a Spreadsheet or Database used for?

Operations and data teams who need to write workflow results into a table or database. A generic n8n workflow that shows how to write data from a workflow into a spreadsheet, a CSV file or a relational database. Each item needs a key for every column, so a Set or Function node reshapes the data first. The template also explains how nested arrays can be split into separate items before they are appended or inserted.

How do I import Load Data into a Spreadsheet or Database 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 Load Data into a Spreadsheet or Database 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.