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!
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
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.
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.