Data & Databases
Extract MySQL data and save to spreadsheet
5 nodes
111
78
Automatic trigger
Workflow Description
Automation that retrieves data from your MySQL database on manual trigger, maps the required fields, and automatically writes the records into a spreadsheet file for analysis and sharing with your team.
How it works
- 1.Trigger automation manually when you need to export data
- 2.Connect to MySQL database and fetch records based on your query
- 3.Map database fields to spreadsheet columns
- 4.Write processed data directly to spreadsheet file
Use cases
- Export monthly reports from your production database to shareable spreadsheets
- Create backups of critical customer or transaction data in organized format
- Monitor sales metrics or operational data by syncing database records to tracked spreadsheets
Requirements
- Valid MySQL database credentials and connection details
- Write access to spreadsheet file application
- Knowledge of relevant table and column names in your database
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
MySQL
Spreadsheet File
Details
Trigger
Automatic trigger
Nodes
5
Apps
2
Views
111
Downloads
78
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 (5)
When clicking "Execute Workflow"
Manual Trigger
TableName
Set
LoadMySQLData
My Sql
SaveSpreadsheet
Spreadsheet File
Sticky Note
Sticky Note