From Google Sheet to Whatsapp ( No add ons. Completely free)

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")