CSV to MySQL Data Ingestion

Name: CSV to MySQL Data Ingestion
Rating: 5 (5 reviews)
Author: Free N8N

Intermediate

21 nodes connected

detail.loadingPreview

Free N8N Temples

243 views

45 downloads

Data Managementautomationcsvdatabaseimportingestionmysql

Reads a CSV file and inserts its data into a MySQL database.

About This Workflow

This workflow automates the process of ingesting data from a CSV file into a MySQL database. It starts with a manual trigger, reads the specified CSV file, converts it into a structured format, and then inserts the data into a predefined MySQL table.

Key Features

Manual execution trigger.
Reads binary CSV files.
Converts raw CSV data into a structured format suitable for database insertion.
Inserts data into a specified MySQL table with defined columns.

How To Use

Click the 'On clicking 'execute'' node to manually start the workflow.
Ensure the concerts-2023.csv file is accessible at /home/node/.n8n/concerts-2023.csv on the n8n instance.
The Convert To Spreadsheet node will process the CSV data.
The Insert into MySQL node will then insert the processed data into the concerts_2023_csv table, mapping the columns as specified.

Apps Used

automation

csv

database

import

ingestion

mysql

Workflow JSON

{
  "id": "f5da23ef-e8f4-4cf2-8832-0d3230799359",
  "name": "CSV to MySQL Data Ingestion",
  "nodes": 21,
  "category": "Data Management",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.