Copy each new message received in a Telegram chat to a new row in Google Sheets, only if it is sent by one of the specified Telegram users
Automatically record only the messages you care about from specific Telegram users directly into Google Sheets. Keep your info tidy, relevant, and always at your fingertips—zero copy-paste, zero noise.
If you manage active Telegram channels, constantly monitoring incoming messages and manually copying key content from specified users to Google Sheets can eat up hours each week. Missing important updates because they get buried in chat noise is not just frustrating—it could cost you crucial insights, reduce team coordination, and force you to spend extra on manual admin or data sifting. Without automation, accuracy suffers, and real-time information is lost in the chaos, making daily operations slower and decision-making less precise.
This Botize formula steps in to instantly capture every new message posted in your selected Telegram chat by specific users you define, transferring both content and sender information into a structured Google Sheets file. All it takes is entering the user IDs you want tracked: after that, every qualifying message triggers a new row, complete with timestamp and message text. Instead of scrambling to copy, paste, and sort messages, you get an always-updated, clean record—saving hours, boosting transparency, and letting you filter or sort data immediately. You keep full control, with flexible options to tune user filters, sheet destinations, and activate the workflow as frequently as you need.
Ready to stop the repetitive manual work and never miss another vital message? Follow our simple step-by-step guide below to set up the Botize formula, or use the ready-made automation link for an instant start. Make your Telegram data flow directly to Google Sheets and reclaim your time!
Automate this task with 3 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
Create a trigger that starts the automation when a new event happens, such as receiving a new message.
Copy and paste this prompt into the AI editing tool.
Set up the automation to trigger instantly whenever a new message is received. ⤵
Click the 'Apply this task' button to confirm.
-
4
Capture all new text messages received in any public Telegram channel, including information about the sender and the message.
Copy and paste this prompt into the AI editing tool.
Add a step to listen for any new text message in any public Telegram channel and collect details like the sender's ID, name, username, the content of the message, and other related information. ⤵
Click the 'Apply this task' button to confirm.
-
5
Add a step that checks if the sender of the message is one of the specified Telegram users, and if so, saves the message to a new row in Google Sheets.
Copy and paste this prompt into the AI editing tool.
Only if the sender's Telegram user ID matches one from a specified list, add a new row to a Google Sheet with columns for the sender's name, the message text, the image URL if available, and the date and time. ⤵
Click the 'Apply this task' button to confirm.
-
6
Your automation is ready to use. Click the 'Save changes' button.
Save changes
Turn Telegram Messages Into Smart Google Sheets (Only from Who Matters)
Here’s the magic: whenever a chosen user sends a message in your Telegram chat, this automation takes it and lands it safely into a Google Sheet, row by row. All the rest? Ignored. It’s like having a super-focused assistant who only listens to your VIPs and neatly keeps track for you. No more sifting through endless chat logs, no technical headaches. Just your important info, organized instantly.
| Manual | Botize | |
|---|---|---|
| Open Telegram, search for the right user's messages | 5 minutes per session | 0 Minutes |
| Copy message content manually | 2 minutes per message | 0 Minutes |
| Switch to Google Sheets, paste and format per row | 3 minutes per message | 0 Minutes |
| Total | If you handle 10 priority messages a day, this easily saves you 100+ minutes daily | 0 Minutes |
Looking for an effortless way to save those important Telegram messages—without drowning in chat clutter? You’re in the exact place you need to be.
Track Key Client Decisions
A project manager saves only messages from their client in a Telegram group—every commitment, approval, and idea is instantly logged for future reference.
No More Noise
Only save messages from people that actually matter to your workflow.
Instant Organization
Messages land in your sheet the moment they happen—no delays, no forgotten info.
Zero Manual Work
Stop copying, pasting, and sorting messages by hand—focus on what matters.
Monitor Team Leaders
A business owner keeps a tidy record of feedback or instructions given by their team leads, without having to scroll endless chat history.
⌾︎ You need to track or archive key updates, decisions or requests from your team, clients or collaborators on Telegram.
⌾︎ You want to analyze trends, keywords, or action points from specific people without clutter—think managers, customers, mentors.
✕ You want to store every single message from every user—this filter is for the VIPs only.
✕ Your Telegram chats don’t include the people whose input actually matters to your workflow.
✓ Choose exactly which Telegram users trigger new rows in your sheets by simply adding their user IDs.
✓ Decide which Telegram message details to capture—name, text, images, even reply threads—by mapping the info to your sheet structure.
✓ Use your own Google Sheet: select or create the perfect spreadsheet to receive and organize your automated info.
This task copies each new message received in a Telegram chat to a new row in Google Sheets, but only if the message is sent by one of the specified Telegram users. Within the task, you will need to provide the IDs of the users whose messages should be considered for copying into Google Sheets.
