Send a message to each Telegram user ID specified in Google Sheets

Automate your Telegram messaging directly from a Google spreadsheet. Yes, it's that easy!

  • Execute the task periodically
  • Extract the next new row (gspreadsheet → read_row)
  • Send a message (telegrambot → send_message_photo)

Manually messaging each Telegram user, group, or channel from a growing list in Google Sheets is a repetitive headache—every time your list updates, you have to copy IDs, craft individual messages, and risk countless copying errors or missed contacts. This manual grind isn't just an energy vampire; it eats up your valuable time and makes it easy to overlook opportunities for engagement, timely notifications, or campaign coordination. Without automation, you’re stuck with sluggish communication, inconsistent delivery, and the very real risk of lost visibility or dissatisfied teammates, clients, or audience members.

Botize’s automation transforms your Google Sheets list into a powerful, hands-off Telegram broadcast tool. Every hour—or as often as you wish—the formula scans your sheet for new IDs, then sends a specific message directly to each contact or group, ensuring your communication stays swift, seamless, and error-free. The process halts when it reaches the last row and patiently waits for you to add more IDs, resuming with a simple restart click. You keep full control: adjust the frequency, edit messages, and organize your contacts any way you like—all through a reliable and customizable workflow trusted by professionals who need their message delivered efficiently and consistently.

Ready to streamline your Telegram outreach and reclaim your time? Follow the step-by-step guide to set up this formula in minutes, or use the ready-made Botize automation to hit the ground running. Whether you want to tweak the schedule, tailor your messages, or simply automate the routine, everything you need is within reach—just start now and see a world of difference!

Automate this task with 3 simple prompts

Copy and paste the following prompts into Botize's AI task editor

  1. 2

    Select the AI editing tool.

    AI Prompt Tool
  2. 3

    Let's begin by setting up a trigger that runs this task on a regular schedule.

    Copy and paste this prompt into the AI editing tool.

    Create a step that makes the automation start automatically every hour. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  3. 4

    Now, we need to retrieve the next row with a Telegram user ID from our Google Sheet.

    Copy and paste this prompt into the AI editing tool.

    Add a step to extract the next new row from column A in a specific Google Sheets document, so we can get the Telegram user ID or chat for sending messages. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  4. 5

    Finally, for each Telegram user ID or chat we got from Google Sheets, let's send them the message.

    Copy and paste this prompt into the AI editing tool.

    Add a step to send a specific message—like 'This is a test message'—to the Telegram user or chat ID retrieved from the Google Sheet in the previous step. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  5. 6

    Your automation is ready to use. Click the 'Save changes' button.

    Save changes

Effortlessly Message Telegram Users via Google Sheets

With just a list of Telegram IDs in Google Sheets, our automation handles the rest, sending your message to each user seamlessly. Add more IDs anytime and hit restart to continue.

Manual Botize
Find usernames 15 0 Minutes
Compose individual messages 25 0 Minutes
Send messages manually 30 0 Minutes
Track sent messages 20 0 Minutes
Total 90 0 Minutes

You've found the solution to your Telegram messaging woes.


Event Notifications

Notify participants about upcoming events by sending reminders directly to their Telegram.

Save Time

Reduce your manual efforts in sending messages one by one.

Stay Organized

Manage all messaging tasks from one single spreadsheet.

Boost Efficiency

Send messages consistently without missing a beat.


Emergency Alerts

Quickly distribute important alerts to community groups using Telegram IDs collected in sheets.

đź“§

⌾︎ You're handling large volumes of Telegram communications regularly.

⌾︎ You prefer having a centralized system for your messaging needs.

🛑

âś• You send only occasional personal messages on Telegram.

âś• You don't use Google Sheets for tracking or managing data.


âś“ Modify message content to match your tone.

âś“ Schedule messages for specific times.

âś“ Easily add or remove Telegram IDs.




This task assumes that you have a Google Sheets document where you have listed, in column A, a series of Telegram user IDs, groups, or channels. The automation goes through each row and sends a specific message to the corresponding user or chat. Once the task reaches the last row, it stops and waits for you to add more IDs, and it will only restart when you manually press the "Restart" button on the automated task.

Related automations