Use Cases
- Exporting database records for reporting purposes
- Generating data backups in spreadsheet format
- Sharing database information with team members or stakeholders
How It Works
Manually trigger the workflow to start the process Set the name of the MySQL table to be exported Execute a SQL query to retrieve all data from the specified table Save the retrieved data into an XLSX spreadsheet file
Setup Steps
- 1Import the workflow template into your n8n instance
- 2Click 'Execute Workflow' to start the process
- 3Ensure the MySQL credentials are correctly configured
- 4Verify the table name is set correctly in the workflow
- 5Download the generated XLSX file after execution
Apps Used
MySQL
Spreadsheet Software
Categories
Target Roles
Industries
Tags
#document automation
#file organization
#process automation