WhatsApp Automated Messaging Script Development

I'm in need of a script that can send automated messages on Whatsapp. The script should be able to pull the contacts and names from a Google Sheet that I already have set up.

The script's primary function will be to send a message (which will include the recipient's name) to their respective phone number on Whatsapp. I don't need to worry about replies, just the initial message being sent to each of these contacts.