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.

  • Instantly when the trigger is activated
  • Instantly when receiving a text message (telegrambot → webhook)
  • Add a new row at the end of a sheet (gspreadsheet → add_row_to_end)

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!

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

Related automations

Other ready-to-use automations you may find useful.