CSV to MySQL Data Ingestion
detail.loadingPreview
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.csvfile is accessible at/home/node/.n8n/concerts-2023.csvon the n8n instance. - The
Convert To Spreadsheetnode will process the CSV data. - The
Insert into MySQLnode will then insert the processed data into theconcerts_2023_csvtable, mapping the columns as specified.
Apps Used
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.
Get This Workflow
ID: f5da23ef-e8f4...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
FileMaker Data Entry and Update
Workflow to create a record in FileMaker, then edit it with additional data.
Dynamically Create Airtable Tables for Webflow Form Submissions
Automatically create dedicated Airtable tables for each Webflow form and log submissions.
Two-Way Sync Pipedrive and MySQL Contacts
Synchronizes contact data between Pipedrive and a MySQL database to ensure data consistency.