WhatsApp has a little-known option that allows you to create and send personalized WhatsApp messages that can be used to send to multiple recipients in batches or as bulk mailings for WhatsApp marketing. This function of sending chats is also very useful to be able to send WhatsApp messages to anyone even if you do not have it in your agenda (even to yourself). In a simple way and without resorting to unofficial WhatsApp applications or services, you can send whatsApps to many recipients with a personalised text or facilitate them to send them to us.
Google sheet message Whatsapp
Send WhatsApp with Google Sheet
In this article I explain how to do it step by step and include an explanation and Google Sheet template.
One of the most desired functions of WhatsApp is to be able to automate as much as possible the sending of messages (WhatsApp marketing) with personalized texts (name, surname, subject, etc.) especially in companies. There are third-party tools, but they are not official and they are a violation of WhatsApp rules, so they can lead to a suspension of the WhatsApp account in that phone number, with all that it entails.
It is also highly desirable that anyone, especially considering professional fields, can start a WhatsApp chat without adding your number to the agenda.
In this way, later when he checks his contacts and if he no longer wants to maintain contact with you, he will not block you, as in many cases it is done, without foundation.
If many people block you on WhatsApp, in the end it is very possible that your WhatsApp account will be suspended.
The solution to these two cases is to use the “click to chat WhatsApp” function, which allows you to start a conversation without having the number in the agenda even with an initial message.
If you know a person’s mobile number, you can create a custom link to send them an automated message.
Clicking on the custom WhatsApp link will open the conversation. This works whether you do it from your mobile phone (with the WhatsApp app installed) or from WhatsApp web or even with the WhatsApp program available for Windows 10 and macOS.
How to create a WhatsApp link to start a conversation on WhatsApp or send a personalized message?
If you include that link on your website or blog, visitors can send you messages in a very simple way.
The contact list opens so you can choose who you want to send that WhatsApp message to.
How to send personalized mass messages from Excel via WhatsApp
To send a WhatsApp message to each recipient using personalized Excel (for example, “Good morning, Benito. I hope you have been happy with your purchase”) (which is the most convenient way to generate the web addresses with the desired parameters) there is no rather than using the function explained in the previous point.
In this way, and without the need to resort to unofficial third-party tools other than WhatsApp (with the consequent risk of account suspension), “mass” shipments can be made, in which the texts and recipients are generated to measure and are customized and you just have to click the button “send” in each one.