Manual CSV to MySQL Importer
detail.loadingPreview
Import data from a CSV file into a MySQL database manually.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This template allows you to manually trigger a workflow that reads data from a specified CSV file, converts it into a spreadsheet format, and then inserts it into a MySQL database table.
Key Features
- Manual trigger for controlled execution.
- Reads data from a local CSV file.
- Converts CSV data for database insertion.
- Inserts data into a specified MySQL table.
- Includes basic error handling.
How To Use
- Save the workflow JSON to your n8n instance.
- Update the
filePathparameter in the 'Read From File' node to point to your CSV file. - Ensure your MySQL database is configured and a valid credential is set up in n8n.
- Update the
tableandcolumnsparameters in the 'Insert into MySQL' node to match your database table and column names. - Click the 'Execute' button on the 'On clicking 'execute'' node to run the workflow.
Apps Used
Workflow JSON
{
"id": "5387e411-25f5-4078-a6d3-a6f85fcce2af",
"name": "Manual CSV to MySQL Importer",
"nodes": 0,
"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: 5387e411-25f5...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
CSV to MySQL Data Ingestion
Reads a CSV file and inserts its data into a MySQL database.
Package Cleanup and Telegram Notifications
Cleans up old 'TRANSPORTE-RECEBIDO' package data from the database and sends Telegram notifications.
Store CocktailDB API Data
Stores data fetched from the CocktailDB API into a JSON file.
Dynamically Create Tables in Airtable for Webflow Form Submissions
Automatically create an Airtable table for each new Webflow form submission.
Customer Review Management Tool
A tool to insert, search, and recommend customer reviews.
Get Company Branding Data and Store in Airtable
Fetches company branding assets and information and stores them in an Airtable base.