Extract messages from a chat between two dates and save any URLs found to Google Sheets
Forget endless scrolling. Instantly collect all the important links from any Telegram chat, channel, or group and save them into Google Sheets. Yes, even from way back in time.
Searching for URLs in past Telegram chats is a tedious, time-draining process. Manually sifting through hundreds (or thousands) of messages to extract relevant links costs you hours of productivity or leads to missed information entirely. Without automation, you risk losing valuable resources, oversight on link sharing, and endanger project timelines—whether it’s tracking shared articles, documenting research, or collecting marketing assets.
Botize’s formula solves this by scanning any selected Telegram chat, channel, or group within the date range you set—even reaching years back—and automatically extracting every URL it finds. These links are instantly organized into a Google Sheet, eliminating manual copy-paste or skipped entries. The transform is dramatic: what once took hours of error-prone work (or never happened) is now fast, reliable, and fully automated on your schedule (down to every two minutes), putting all the data you need at your fingertips.
See how easy it is to set up and tailor this automation for your use—choose your chats, define your dates, set the scan frequency, and add additional filters if needed. Follow the step-by-step guide with Botize or jump directly to the ready-made formula to put your Telegram links on autopilot today!
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
Start by setting up the automation to run at regular intervals so it checks for new messages frequently.
Copy and paste this prompt into the AI editing tool.
Schedule the automation to run every 2 minutes so it can check for and process new Telegram messages. ⤵
Click the 'Apply this task' button to confirm.
-
4
Now, fetch the next message from a specific Telegram chat, channel, or group that was sent within a given date range.
Copy and paste this prompt into the AI editing tool.
Retrieve the next new message from the selected Telegram chat between two specific dates. ⤵
Click the 'Apply this task' button to confirm.
-
5
From the Telegram message you just retrieved, find and extract any web links or URLs mentioned in the message.
Copy and paste this prompt into the AI editing tool.
Scan the message content and pull out any URLs or web links it contains. ⤵
Click the 'Apply this task' button to confirm.
-
6
Finally, whenever there are URLs found, add them as a new row at the end of a Google Sheets document for easy tracking.
Copy and paste this prompt into the AI editing tool.
If there were any URLs detected in the message, add them as a new row in your Google Sheet. ⤵
Click the 'Apply this task' button to confirm.
-
7
Your automation is ready to use. Click the 'Save changes' button.
Save changes
Magically Grab Every URL From Your Telegram Chats (In Seconds)
No more searching for hours or copying links one by one. Just pick a chat and a date range, and this automation swoops in, grabs every single link, and neatly puts them into your Google Sheet. Old chats? No problem. It uses your Telegram account (not just a bot) so you can dive as deep as you need. Think of it as your personal, never-forget-any-link assistant.
| Manual | Botize | |
|---|---|---|
| Scroll back through months of chat history | 90 | 0 Minutes |
| Find and copy every shared URL by hand | 60 | 0 Minutes |
| Paste and format links into a spreadsheet | 45 | 0 Minutes |
| Total | 195 | 0 Minutes |
If you’re tired of losing URLs in your Telegram chats or wish you could quickly find that must-read article someone shared last month—relax. You just found your solution (and you’ll wish you had this sooner).
Curate a Resource Library
A community manager wants all the top tools, articles, and references shared in a huge Telegram group over the past year — instantly creates an organized list for the whole team.
Time Saver
Find and collect every important link in seconds—not hours.
No Lost Gems
Every shared resource is safe, searchable, and organized.
Zero Hassle
It’s easy, automatic, and requires zero coding or setup stress.
Catch Up on Research
A student joins a Telegram study group late in the semester and wants to quickly gather every must-read paper and resource link posted since January — done in minutes.
⌾︎ You need to gather resources, references, or research from old Telegram groups.
⌾︎ Your team shares lots of links but nobody can ever find them when needed.
âś• You never share or need to access links in Telegram.
âś• You want to process other data types (like images or documents) only.
✓ Set any date range you want — from a single day to a whole decade.
âś“ Choose specific chats, groups, or channels (no admin rights needed if you're a member).
âś“ Decide which Google Sheet (and column) gets your freshly harvested links.
This automation scans messages from a Telegram chat, channel, or group within a specified date range, extracts any URLs found, and saves them to a Google Sheets document. To access older messages and posts from any Telegram chat, the automation uses your personal Telegram account, since bots cannot access historical messages or chats where they are not administrators.
