Actions to Dynamic Destinations for Twilio SMS


(Ben Silverstein) #1

Hi there. I’m not sure if I’m describing this properly, but I’d like to use Looker and Twilio to batch send several SMSes. Basically, I’d like to grab any new invoices generated in the last X period of time, extract the phone numbers from their invoice header data, and send each row to the field’s phone number. The problem is, it seems you can only specify a single phone number. Is there a way around this?

(Izzy) #2

I don’t think there’s a way around this within the native Looker actions. It sounds like you might want to explore sending the data to a webhook (using Looker) that will run a script that does this (strip out the phone numbers and send the appropriate rows to the appropriate #'s)— You could even use Zapier which seems to have a Twilio integration built in.

If someone’s managed to do this, either using a webhook or with the built-in action, would love to hear how!