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("api.whatsapp.c..." & ENCODEURL(91&F2:F) & "&text="& encodeurl(E3:E),"SEND")
15 окт 2024