Every day, it extracts from Google Sheets the people whose birthday is today and congratulates them with a Telegram message
Your Google Sheets remembers birthdays. Your Telegram bot does the celebrating. You just enjoy the smiles.
Remembering every contact’s birthday is a struggle—sorting through spreadsheets, checking dates, and manually sending celebratory messages often falls through the cracks. Not only is this tedious and time-consuming, but missing a birthday can come across as impersonal or even neglectful, damaging relationships with clients, colleagues, or friends. If you keep doing it manually, you risk losing valuable connections, reducing team morale, and even compromising your reputation—plus, it’s simply a waste of your precious hours.
This Botize formula takes all the hassle off your plate by combing your Google Sheets every single day, finding the contacts who have a birthday, and sending them a personalized Telegram message—you simply adjust the message content as you see fit. Imagine: no more missed birthdays, forgotten contacts, or frantic last-minute messages. Instantly, you become the thoughtful connector who never forgets, all while letting an automation do the heavy lifting, saving you hours and ensuring everyone feels remembered. It’s professional, reliable, and easy to customize to your needs, whether you want to fine-tune how often it runs or tailor the messaging.
Ready to never forget another birthday and to make every contact feel special, effortlessly? Check out how to implement this formula with Botize in a few guided steps—everything’s ready for you to personalize and activate. Get started now and let your relationships (and your reputation) flourish.
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 automatically once every day
Copy and paste this prompt into the AI editing tool.
Create a trigger that runs this automation daily, so it checks for birthdays every morning. ⤵
Click the 'Apply this task' button to confirm.
-
4
Add a step to fetch today’s birthdays from the Google Sheets
Copy and paste this prompt into the AI editing tool.
Pull data from the Google Sheets file. Find all rows where the date of birth matches today’s date, and get each person’s name and Telegram ID. ⤵
Click the 'Apply this task' button to confirm.
-
5
Add a step to go through each birthday person identified in the previous step
Copy and paste this prompt into the AI editing tool.
For each person found whose birthday is today, repeat the next actions. ⤵
Click the 'Apply this task' button to confirm.
-
6
Add a final step to send a birthday message on Telegram to each person
Copy and paste this prompt into the AI editing tool.
Send a customized Telegram message to each birthday person’s Telegram ID to wish them a happy birthday. ⤵
Click the 'Apply this task' button to confirm.
-
7
Your automation is ready to use. Click the 'Save changes' button.
Save changes
Never Forget Another Birthday — Ever Again.
Here's the magic: You keep your contacts and their birthdays in a Google Sheet. Every day, this automation checks whose big day it is and sends them a warm, personal message via Telegram — all by itself. No more calendar checks, no more forgetting, just heartfelt wishes delivered right on time.
| Manual | Botize | |
|---|---|---|
| Open Google Sheets and filter for today’s birthdays | 4 | 0 Minutes |
| Copy Telegram IDs for each person | 3 | 0 Minutes |
| Type and send each individual message | 7 | 0 Minutes |
| Total | 14 | 0 Minutes |
If you were searching for a smarter way to send real birthday wishes — automatically, personally, and at the perfect moment — you just found it. Stop stressing and start impressing!
Team Culture, Supercharged
You’re a team leader with a remote crew. You track everyone’s birthdays in Sheets. Every morning, your teammates get a customized Telegram greeting — now you look like the most thoughtful boss ever (and you barely lifted a finger).
Never Miss Out
Make every contact feel valued, year after year.
Zero Hassle
Set it up once and let the automation handle the rest — even when you’re asleep.
Real Connection
Send messages that feel personal, not robotic or mass-produced.
Community Love, Effortless
You run an online community with over 200 members. Remembering every birthday is impossible — unless your Telegram bot handles it! Each member gets a timely birthday congratulations, making your group feel way more special.
⌾︎ You love celebrating people but hate the admin side of remembering dates.
⌾︎ You manage a community, a club, or a customer list and want to add a personal touch.
✕ You never use Google Sheets or Telegram.
✕ You’re looking for complex CRM integrations or marketing campaigns (this is about simple, human moments).
✓ Edit your birthday message for humor, warmth, or inside jokes — it’s your voice, not a robot’s.
✓ Add a photo or GIF to your Telegram greeting for extra flair.
✓ Choose your own Google Sheet and have as many contacts as you want — no technical setup needed.
This automation runs daily and checks a Google Sheets file where column A contains contact names, column B their birth date (formatted as a date field), and column C their Telegram ID. Each day, it extracts the contacts whose birthday is that day and sends them a Telegram message, which you can customize in the task setup.
