The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"id": "aecce7a8-24f6-48c0-a7f0-f48a421d1d8c",
"name": "On clicking 'execute'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
540,
400
],
"parameters": {},
"typeVersion": 1
},
{
"id": "66822f20-83a9-4272-920c-5d8c9140f912",
"name": "Read From File",
"type": "n8n-nodes-base.readBinaryFile",
"position": [
740,
400
],
"parameters": {
"filePath": "/home/node/.n8n/concerts-2023.csv"
},
"typeVersion": 1
},
{
"id": "9b469774-7c1d-41a3-9bfe-18fc3527f96e",
"name": "Convert To Spreadsheet",
"type": "n8n-nodes-base.spreadsheetFile",
"position": [
940,
400
],
"parameters": {
"options": {
"rawData": true,
"readAsString": true
}
},
"typeVersion": 1
},
{
"id": "a10bd105-16f7-47c8-b5a0-a5a10e51ae10",
"name": "Insert into MySQL",
"type": "n8n-nodes-base.mySql",
"position": [
1140,
400
],
"parameters": {
"table": {
"__rl": true,
"mode": "name",
"value": "concerts_2023_csv"
},
"columns": "Date, Band, ConcertName, Country, City, Location, LocationAddress",
"options": {}
},
"credentials": {
"mySql": {
"name": "<your credential>"
}
},
"typeVersion": 1
}
],
"connections": {
"Read From File": {
"main": [
[
{
"node": "Convert To Spreadsheet",
"type": "main",
"index": 0
}
]
]
},
"On clicking 'execute'": {
"main": [
[
{
"node": "Read From File",
"type": "main",
"index": 0
}
]
]
},
"Convert To Spreadsheet": {
"main": [
[
{
"node": "Insert into MySQL",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
mySql
About this workflow
Import Csv Into Mysql. Uses manualTrigger, readBinaryFile, spreadsheetFile, mySql. Event-driven trigger; 4 nodes.
Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →