Workflow: automate with n8n workflow for Manual Readbinaryfile Create Triggered
Integrations: manualTrigger, mySql, readBinaryFile, spreadsheetFile

{"meta": {"instanceId": "dfdeafd1c3ed2ee08eeab8c2fa0c3f522066931ed8138ccd35dc20a1e69decd3"}, "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": {"id": "46", "name": "MySQL n8n articles"}}, "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}]]}}}