Extracts every minute the next message between two specific dates from a third-party Telegram chat, group, or channel and saves it to a Google Sheets spreadsheet
Automatically fetch and neatly save any Telegram chat, group, or channel conversation to Google Sheets—no code, no headaches, just calm, organized records.
Manually combing through countless Telegram messages between two specific dates is both tedious and error-prone, especially when you need to keep accurate, organized records for reports, audits, or team analysis. Trying to do this by hand—copying message details, timestamps, and user info into spreadsheets—wastes hours and risks missing key details, undermining transparency and business intelligence. If you don’t automate, you’re losing valuable time, hurting your team’s productivity, and risking gaps in crucial data.
This Botize formula completely relieves the burden by automatically extracting every new message from any Telegram chat, group, or channel—precisely between the start/end dates you choose—and logging all the relevant details straight into your chosen Google Sheets spreadsheet every single minute. You get granular control: pick which chat to track, set your exact time window, customize which message fields or media files to store, and even filter or adjust the data organization. As a result, records stay perfectly up to date with zero manual input, so you stay on top of every conversation and never miss a critical message or attachment—even in high-traffic channels.
Ready to modernize your record-keeping? Just follow the quick steps in Botize or use this formula as your fast track to instant automation—customize as needed and watch the insights flow into your spreadsheet effortlessly. Start now and reclaim your time for the work that matters most!
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
Never Miss a Telegram Message—Ever Again
Connect your Telegram chat, pick your date range, and link your Google account—done. This automation grabs every single message, one by one, every minute, and saves the whole conversation to your Google Sheets, ready for you to analyze, share, or keep as evidence. Forget about endless scrolling, screenshots, or copy-pasting. Your messages, always in order, always accessible.
| Manual | Botize | |
|---|---|---|
| Manually searching for each message between dates | 90 minutes | 0 Minutes |
| Copying and pasting texts into a spreadsheet | 75 minutes | 0 Minutes |
| Sorting conversations by user and date | 60 minutes | 0 Minutes |
| Uploading and linking media files | 30 minutes | 0 Minutes |
| Total | 255 minutes+ (for each chat!) | 0 Minutes |
Exactly what you wanted: if you need to extract and archive Telegram messages between specific dates, you’ve landed in the right place. No confusion. No guesswork.
Legal Documentation
A lawyer needs to archive group chat messages as evidence in a case—every detail secured, no risk of losing data or evidence.
Stress-free Backups
Keep every message safe and organized without lifting a finger.
Zero Manual Work
Stop wasting hours on copy-paste—let us do the grunt work for you!
Crystal Clear Records
Instantly access and search all conversations, neatly stored and ready for action.
Project Collaboration
A project manager monitors a large team group, saving all key chat discussions in Sheets so decisions and feedback are never lost (or forgotten).
⌾︎ You need to document every chat for compliance, project tracking, or peace of mind.
⌾︎ You want to easily search, analyze, or share conversations from Telegram channels or groups.
✕ You only use Telegram once in a blue moon and never need chat records.
✕ Your group is private and you’re not allowed to use bots or automations.
✓ Pick exactly which chat, group, or channel you want to monitor—no limitations.
✓ Choose any date range you need; grab messages from yesterday, last month, or a year ago.
✓ Customize the Google Sheets layout: keep essential details (like sender, message, media links) and skip what you don’t need.
This task goes through each message in a third-party Telegram chat, group, or channel between two specific dates, extracts them one by one, and saves them to a Google Sheets spreadsheet, allowing you to keep an organized record of the conversation. To use this task, you must specify the Telegram chat, group, or channel you want to monitor, the start and end dates, and connect your Google account so the automation can write the data to the selected spreadsheet. You can customize the sheet to store information such as the message text, date, sender, or other available data.
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.