Use Cases
- Export sales data from a SQL database for reporting purposes.
- Automate the backup of SQL table data in CSV format.
- Facilitate data sharing by exporting SQL data to a common file format.
How It Works
Manually trigger the workflow to start the process. Set the desired SQL table name for data extraction. Execute a SQL query to retrieve data from the specified table. Save the retrieved data as a CSV file for easy access and sharing.
Setup Steps
- 1Import the workflow template into n8n.
- 2Click on 'Execute Workflow' to initiate the process.
- 3Modify the 'TableName' node to specify the desired SQL table.
- 4Run the workflow to export the data as a CSV file.
Apps Used
Microsoft SQL
Spreadsheet File
Categories
Target Roles
Tags
#process automation
#workflow management
#file organization