Use Cases
- Analyze customer order trends across different years
- Identify changes in customer purchasing behavior
- Evaluate sales performance over multiple time periods
- Support data-driven decision-making in business strategies
How It Works
Trigger the workflow manually to start the process Execute SQL queries to retrieve order data from the MySQL database for specified years Compare the datasets based on customer numbers and order counts Update order counts as necessary for further analysis
Setup Steps
- 1Import the workflow template into n8n
- 2Connect to your MySQL database with the appropriate credentials
- 3Customize SQL queries if needed to fit your dataset
- 4Manually trigger the workflow to execute the comparison
Apps Used
MySQL
Categories
Target Roles
Industries
Tags
#workflow management
#process automation
#data extraction