Data & Databases
Extract and organize data from MySQL database
4 nodes
136
65
Automatic trigger
Workflow Description
An automation that retrieves records from your MySQL database and processes them automatically when triggered manually. Perfect for routine data reviews, report generation, and keeping your database records organized without manual intervention.
How it works
- 1.Trigger the workflow manually using the dedicated button
- 2.Connect to your MySQL database and retrieve the required records
- 3.Process and map the data to defined variables
- 4.Complete the operation and log the results
Use cases
- Generate daily or weekly data reports from database tables
- Update and maintain recurring records in your system
- Extract and process new orders or entries automatically
Requirements
- Valid MySQL connection credentials (host, username, password)
- Read permissions on the target database tables
- Network access from n8n servers to your MySQL instance
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
MySQL
Details
Trigger
Automatic trigger
Nodes
4
Apps
1
Views
136
Downloads
65
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (4)
On clicking 'execute'
Manual Trigger
MySQL
My Sql
MySQL1
My Sql
Set
Set