Run a daily MySQL query to obtain the number and total of sales made during the previous day and send them to a Telegram chat
Get your daily sales summary sent directly to your fingertips with zero hassle.
Manually checking your sales database every morning, running a MySQL query, compiling yesterday’s sales numbers, and sending that report to your team on Telegram is tedious—and prone to delays. Missing a day means you lose timely insight, slow reaction to sales ups and downs, and let small issues snowball into bigger problems. The lack of daily visibility can cost you money, decision-making power, and credibility, not to mention all the wasted time copying, formatting, and sending data by hand.
Botize solves this with a simple, powerful formula: every day, it automatically queries your MySQL database for the previous day’s sales figures—total transactions and revenue—then instantly sends a clear, formatted summary straight to your chosen Telegram chat. You wake up to real numbers, in real time, right where your team already collaborates. The process is completely customizable: set the frequency, pick which chat to send to, and adjust filters or even the SQL query to match your needs. The automation runs perfectly on schedule, giving you back your mornings and putting up-to-date data at everyone’s fingertips.
Ready to banish manual sales reporting for good? Follow the step-by-step below to automate your sales reporting with Botize and get that daily Telegram update started—or jump straight in with this formula ready to use and tweak for your workflow. Let’s make sales visibility automatic!
Start using this automation
It's ready to go. Choose how to set it up in your account.
Open it in the Botize editor
Load it into your account and customize it in the visual panel, with everything in view.
Open it in Claude or ChatGPT
Copy this and paste it into ChatGPT or Claude (with the free Botize connector): it'll load the automation, tailor it with you and save it to your account.
Not connected yet? Claude guide · ChatGPT guide
Stay on Top of Your Sales Game, Effortlessly!
Every day, our system fetches the previous day's sales data from your MySQL database and delivers it straight to your chosen Telegram chat. It's like having your own personal sales assistant.
| Manual | Botize | |
|---|---|---|
| Log into MySQL | 5 minutes | 0 Minutes |
| Run the sales query | 5 minutes | 0 Minutes |
| Format the data | 10 minutes | 0 Minutes |
| Send the report | 5 minutes | 0 Minutes |
| Total | 25 minutes | 0 Minutes |
Yep, you've found the solution to your daily sales tracking!
Daily Sales Summary
Receive yesterday’s sales summary every morning, enabling informed decisions.
Effortless Updates
Receive daily sales stats without lifting a finger.
Stay Informed
Know exactly how your business is doing each day.
Save Time
No more manual data gathering or report writing.
Team Update
Automatically send sales updates to your sales team via Telegram.
⌾︎ You're a busy entrepreneur needing quick access to sales data.
⌾︎ You love automation and dislike repetitive tasks.
✕ You don't use MySQL for storing your sales data.
✕ You prefer doing all data tracking manually.
✓ Change the frequency of the report delivery.
✓ Select different Telegram chat recipients.
✓ Customize the report's data points and presentation style.
Performs a daily MySQL query to obtain the date, the number, and the total sales of the previous day. Then, it sends this data to a specific Telegram chat, providing a report that includes the date, the number of sales made, and the total sales.
Related automations
Other ready-to-use automations you may find useful.
Apps in this automation
These are the apps this automation connects. Open any of them to discover everything you can automate with it.
Actions used
These are the exact steps this automation runs. Each action can be reused in other automations.