Discussions

I have 52 clients to send sms to every week. I have DialPad Pro. How can I use google app script to detect the name in column A of the google sheet and their corresponding phone number in column B to automate a text messages (that includes their name)? I have tried many times and I keep getting errors.