Sending Personalized Telegram Messages in Bulk

Q: We've sent small birthday gifts to some of our customers. I've created a table as shown below:

Now I need to send each customer a birthday greeting one-by-one via Telegram, including the tracking number for their gift. Is there a simple way to do this?

PS: The customers have already added our customer service Telegram bot to their contacts, and I have their ChatIDs.

A: Here's a simple and practical solution for you.

SQLTelebot (also known as Telebot) is a plugin for SQLMessenger. You can use this plugin to send personalized messages from your spreadsheet to each customer individually.
If your customer data is stored in a database, this plugin can also be configured to automatically send messages at a specific time, such as on the customer's birthday.

Step 1: Prepare the Message List File

• First, click here to download the Excel template and add your customer data to it.

• The "MessageText" column contains the message you want to send. You can use Excel formulas to automatically generate personalized messages by including fields such as "FirstName" and "TrackingNumber".

• The "MessageType" column should be set to "text" for text messages. If you want to send a birthday image along with the message, set "MessageType" to "photo" and enter the image file path in the "AttachFileName" column.

• The "BotID" column should contain your Telegram bot’s ID.

• The "SendToChatID" column should contain the customer’s ChatID.

Step 2: Install and Configure SQLTelebot

1. Install the SQLTelebot plugin in SQLMessenger.

1. Add your Telegram bot to SQLTelebot.

• Be sure to check the "Enable send messages via this bot" option.

• If you don’t need the bot to receive customer replies, you can leave the "Automatically fetch messages and save to local database" option unchecked.

Step 3: Create a Bulk Sending Job in SQLTelebot Manager

1. In SQLMessenger, open Telebot Manager and click the "Send Messages in Bulk" button to open the corresponding dialog.

1. In the "Send Telegram Messages in Bulk" dialog, click the "Send Messages in Bulk" button.

1. Select the Excel file you prepared in Step 1 and click OK.

SQLTelebot will import the messages into the system.

1. Review the message content. Once confirmed, click "OK, Start to Send the Messages" to begin sending.

The system will display the sending progress.

The content of the message received by the customer:

In addition to sending text and images, you can also use SQLTelebot to send PDF files, Excel spreadsheets, and other documents in bulk.

For more details about SQLTelebot, please visit https://www.sqlmessenger.com/manual/plugin-2-index.htm.