Google Sheet + Form Script to Send Whatsapp Msg through API -- 2

Job ID: 33705758

Budget: $30 – $250 USD

Hello
Looking for someone who can write google Sheets code to send automated Whatsapp Msg using API.
Template + Phone number pickup etc is required.

Please understand this flow


Once new row is Added
Script should Pick the phone number
Option to Add country code as many leads don't come with country code

User should have option to create template
Variables are required in Template

Like Dear <Name> etc

Template Can be in the following form
1. Normal Text with Variables
2. Normal Text with CTA Buttons
3. Normal Text with 3 Button API

Any one will work at one time.
Related categories: Google Sheets Google Apps Scripts