column A will have the first and last name
column B will have a phone number
column C will have a drop down of which message to choose to send to the phone number
I’d like zapier to somehow ingest this file, then send the message from column C to the phone number in column B and prefix the message with their name from column A
Hi
Welcome to the Community.
Zapier can automate sending text messages to numbers listed in Google Sheets. Set Google Sheets as the trigger for new or updated rows, then use an SMS service like Twilio. Map the phone numbers from the sheet to Twilio's "To" field, write your message, and test the Zap. Be aware of potential costs and ensure compliance with regulations before sending messages.
Let us know if you need further assistance.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.