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