cherry-studio

To automate the process of generating monthly sales reports, we can create a workflow in Cherry Studio that includes the following steps:

1. **Data Collection**: The AI agent will connect to the sales database and extract the relevant data for the month. It will use the following SQL query:
   ```sql
   SELECT * FROM sales WHERE month = '2023-10';
   ```

2. **Data Processing**: The coding agent will process the data to calculate total sales, average sales per day, and top-selling products. It will use Python scripts to perform these calculations.
   ```python
   import pandas as pd
   df = pd.read_sql_query(query, connection)
   total_sales = df['amount'].sum()
   avg_sales_per_day = total_sales / 30
   top_selling_products = df.groupby('product').sum().sort_values('amount', ascending=False).head(5)
   ```

3. **Report Generation**: The AI agent will generate a comprehensive sales report in PDF format using the processed data. It will use a report generation tool like JasperReports to create the report.

4. **Email Notification**: The workflow will automatically send the generated report to the sales manager via email using an email integration tool like SendGrid.

The workflow will be scheduled to run on the first day of every month to ensure timely report generation and distribution.