Send WhatsApp Message from Google Sheets | With the Free Google Sheet Template

Опубликовано: 07 Ноябрь 2022
на канале: Technologiate

94,547

1.1k

You can send WhatsApp messages directly from Google Sheets.

How it works:
1. Use Google Sheets to format the message using the data from the different columns.
2. Create a link that can be clicked to send the WhatsApp message using WhatsApp web or WhatsApp desktop.
WhatsApp provides a link where you can put the phone number and the message text to send it using one click.

This is very useful when you want to send a WhatsApp message to customers (or a lot of people), but you want the name or some other data to be dynamic for all the customers.

This is the free bulk WhatsApp message-sending method with these quick tips.

Don't forget to like and subscribe 🙂

Here is the Google sheet template: https://docs.google.com/spreadsheets/...

Write Excel Formula using AI bot:    • Automate Writing Excel Formula | Exce...

Formulas:
Create a new line in Google Sheets cells: char(10)
Create the send link: =hyperlink("https://api.whatsapp.com/send/?phone="&B2&"&text="&E2,"Send") (change the columns accordingly)

Link for WhatsApp web: https://web.whatsapp.com/
Download WhatsApp desktop: https://www.whatsapp.com/download

Subscribe to the channel:
   / @technologiate

Follow and engage on social media:
Facebook:   / technologiate
Instagram:   / technologiate
Twitter:   / technolo_giate

#whatsapp #googlesheets #message