Hey everyone! I’m trying to find a way to automatically send text messages to a list of phone numbers that I have stored in a Google Sheets document. I want to be able to use either my personal phone number or maybe a Google Voice number for sending these messages.
Has anyone used a service or application that can do this kind of bulk texting from spreadsheet data? It would be even better if the tool could also handle incoming text replies automatically.
Thanks for any suggestions you might have!
I built something like this for my small business using Google Apps Script right in Google Sheets. Just write a script that reads your spreadsheet and sends SMS through Twilio’s API - no need for Zapier. Takes about an hour if you know basic coding, and it’s free except for SMS costs. One heads up though - if you’re sending marketing messages, make sure people actually opted in. Bulk SMS can get you banned by carriers if recipients report it as spam. Works great for personal use or confirmed opt-ins.
i’ve been using zapier with google sheets and twilio, pretty seamless. you can set it up to send messages automatically, plus manage replies too. took me a bit to figure it out, but super handy once it’s running!
TextMagic’s been solid for me when I need something quick without coding. It connects straight to Google Sheets and you can customize messages using merge fields from your columns. Pricing’s fair for smaller volumes, and their support actually gets back to you when stuff breaks. Pro tip I learned the hard way - always test with a small batch first. Once you hit send on a big campaign, there’s no stopping it. Also check if your carrier allows bulk messaging from personal numbers. Some will flag your account if they detect automated sending patterns.
This topic was automatically closed 4 days after the last reply. New replies are no longer allowed.