Extract every message from a third-party Telegram chat between two specific dates, classify it with ChatGPT, and save the result in Google Sheets
Every message. The right category. Magically in your spreadsheet—no manual copy, no missing a thing.
Manually gathering and classifying messages from a Telegram chat between specific dates is a grueling task—especially when these chats are packed with hundreds or even thousands of messages. Not only do you waste countless hours sifting through data and copying messages one by one, but you also risk misclassifying important information or missing insights altogether. Without a streamlined process, you lose valuable time and visibility, and business decisions based on incomplete data could cost you money and reputation.
This Botize formula transforms the entire process by automatically extracting every message from any specified Telegram chat, group, or channel between your chosen dates. Each message is instantly analyzed and classified by ChatGPT according to the categories you define—such as order requests, information requests, complaints, or other—before being neatly logged in Google Sheets alongside the classification and original text. You stay in control: select your dates, tailor the classification prompt, choose your spreadsheet, and set the frequency of checks (as often as every minute), meaning you get organized, actionable data with zero manual work.
Ready to turn endless copy-paste and uncertain manual sorting into a repeatable, professional workflow? Follow the step-by-step guide to set it up in Botize, or use this formula right away for instant results. Save time, reduce errors, and unlock deeper insights with the power of automation at your fingertips!
Automate this task with 4 simple prompts
Copy and paste the following prompts into Botize's AI task editor
-
1
Access the Botize automated task editor.
-
2
Select the AI editing tool.
-
3
Let's start by making sure the automation runs regularly to check for new messages.
Copy and paste this prompt into the AI editing tool.
Set up a trigger so that this automation runs automatically every minute. ⤵
Click the 'Apply this task' button to confirm.
-
4
Next, we need to collect messages from a specific Telegram chat within a chosen time frame.
Copy and paste this prompt into the AI editing tool.
Add a step to pull all new messages from a selected Telegram chat, group, or channel, but only include messages sent between two specific dates. ⤵
Click the 'Apply this task' button to confirm.
-
5
Now, let's classify each message to understand what type it is.
Copy and paste this prompt into the AI editing tool.
For each message extracted, send its text to ChatGPT with the instruction: 'Classify the following message into one of these categories: 1) Order request 2) Information request 3) Complaint or problem 4) Other. Return only the category name.' ⤵
Click the 'Apply this task' button to confirm.
-
6
Finally, let's save both the message and its classification in a Google Sheet so the results are easy to review.
Copy and paste this prompt into the AI editing tool.
Add a step to insert a new row into a chosen Google Sheet, including the chat ID, message ID, message text, and the category assigned by ChatGPT. ⤵
Click the 'Apply this task' button to confirm.
-
7
Your automation is ready to use. Click the 'Save changes' button.
Save changes
Turn Telegram Chat Chaos into Crystal-Clear Insights (Automatically)
Plug in your Telegram chat, pick your dates, tell ChatGPT how to classify, and—boom—your messages auto-flow into Google Sheets, already tagged and ready to use. From dozens to thousands of messages, what was once a draining routine now happens in the background while you enjoy your coffee.
| Manual | Botize | |
|---|---|---|
| Manually finding messages in Telegram by date | 45 | 0 Minutes |
| Reading and assigning a category to each message | 60 | 0 Minutes |
| Typing into Google Sheets | 30 | 0 Minutes |
| Total | 135 | 0 Minutes |
Tired of scrolling through endless Telegram chats, copying, pasting, and sorting everything by hand? You just found the smarter way. This is what you’ve been searching for.
Customer Support Channel Deep-Dive
Anna manages a busy support channel. Instead of spending hours each week logging complaints vs. questions, she lets this automation classify them—and instantly spots trends.
Instant Clarity
All your messages perfectly sorted, in seconds, without second-guessing.
No Manual Labor
Stop wasting time copying, pasting, and organizing by hand.
Fully Customizable
Decide exactly how you want your messages classified—no boring templates.
Order Requests at a Glance
Marcus runs group buys in a Telegram group. Every order request is now flagged and dropped into his Google Sheet automatically. No more missed sales, forgotten requests, or late nights sorting messages.
⌾︎ You manage Telegram channels, groups, or support chats and want to tame the flood of messages.
⌾︎ You hate spending hours classifying and logging chat info for analysis, sales, or decision-making.
✕ You never use Telegram or just send two messages a month.
✕ You love sorting endless chat logs by hand (hey, we won’t judge… much).
✓ Choose any chat, channel, or group you have access to.
✓ Completely define your own classification categories and ChatGPT prompt—get creative or keep it simple.
✓ Select any Google Sheet and organize columns as you wish—fully flexible output.
This automation extracts all messages from a third-party Telegram chat, group, or channel between two specific dates. Each message is sent to ChatGPT for classification, and the result is then saved in Google Sheets together with the original message. You only need to select the Telegram chat, define the start and end dates, customize the classification prompt, and choose the Google Sheet where the results will be stored.
