Published On Premiered Jul 20, 2021
You can send whatsapp message ( Static or dynamic) directly from google sheet without any ons.
Here are the formulas:
For Message
=IF(ISBLANK(B2),"","Respected Parent, Your child "&A2&" was absent on "&C2&" in *"&D2&"*")
For link to send Message
=HYPERLINK("https://api.whatsapp.com/send?phone=" & ENCODEURL(91&F2:F) & "&text="& encodeurl(E3:E),"SEND")
show more