Broadcast with customer's name from an Excel file

You can broadcast with the information you already have in an excel file format

Using WhatsApp API, you will be able to broadcast mass messages to the client's WhatsApp number.

While broadcasting via WhatsApp may seem convenient, it's crucial to stick to to best practices. Your WhatsApp API number remains at risk of being blocked if clients report or block your broadcasts. Avoid spamming clients, refrain from sending inappropriate content, and always provide an option for clients to unsubscribe from your broadcast stream.

1. Preparation

To do a proper broadcast, please ensure that your WhatsApp number is working properly on Botcake. If you do not see your number appear here, please click the "Add new page" button and connect it.

Next, prepare an excel file with 2 colums: Phone number and Full name. In this exel file, the first column must always be the client's phone number with the country code.

Finally, head to WhatsApp Manager to create a template with 1 variable to automatically fill the name. If you do not know how to create a template, please click here for the full guide.

Please double check the template's content, and save it before moving to Botcake.

2. Broadcast away!

To create a broadcast campaign, choose “Broadcasts” on the toolbar → “+ New message”

On the “New messages”, delete the default content and choose “Templates”.

Choose the approved template that you prepared from the list. Then, fill the column name in the corresponding parameters (variables). Please remember to copy the EXACT column name, and keep it between two braces {{ }}

Sending templates means opening a new 24h conversation, you’ll be charged once the templates sent successfully, and the fee depends on the type of your template. More pricing details here.

After the setting is complete, it should look like this. Please check the template's content carefully, then click “Settings” or “Next step”

On the Broadcast setting tab, choose the third option and upload the excel file you prepared. Please double check the file to make sure the phone numbers include the country code, and the information you want to broadcast are correct.

The “Number of customers” and “Maximum frequency of sending” sections you can use the default settings.

Finally, choose “Send now” to send mass messages to your customers.

The template will be sent directly to the recipients in the excel file.

Congratulation! You have just completed a broadcast campaign on Botcake!