Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

How do I send information from a Google Sheet and schedule it to trigger a Twilio flow?

  • May 29, 2022
  • 1 reply
  • 230 views
K

Hi all,

I am trying to automate (once a day) the running of a Twilio flow. The main thing I need Schedule to do is trigger a Twilio flow, sending information from a Google Sheet (Phone Number to send text to, text message text). The way it currently works is:

  1. In Google Sheets I have Sheet1 which includes the columns: “Phone Number” and “Text Message Text”.
  2. In Google Sheets, I also have an AppsScript that (when I click manually) will send the data to trigger a Twilio flow that sends a text to each “Phone Number” in the column their custom “Text Message Text”.
  3. When the user respond to the text, I have custom code triggered in the Twilio flow that stores the output text in the same google sheet in the “Sheet2”

I can’t figure out how to make the scheduling part work in Zapier. I see how to connect Google Sheets + Twilio, and Schedule + Twilio, but I can’t figure out how to use Schedule to trigger sending info from a Google Sheet and kickstarting a Twilio flow. Any thoughts on how I could approach this? Or if there is a different set of tools I should think about using?

 

Thank you!

Kimberly

Best answer by robschmidt

Hi @KimberlyMcM 

This is how the zap will look like: 

  1. Trigger: You can schedule it once every day
  2. Action: Find the spreadsheet row that should be used to send SMS
  3. Action: You cant directly start a flow but can send an SMS or make a call. In order to start a flow, instead of twilio app you need to use webhook by zapier and make custom API call
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

robschmidt
Forum|alt.badge.img+9
  • robschmidtZapier Solution Partner
  • Zapier Solution Partner
  • Answer
  • May 30, 2022

Hi @KimberlyMcM 

This is how the zap will look like: 

  1. Trigger: You can schedule it once every day
  2. Action: Find the spreadsheet row that should be used to send SMS
  3. Action: You cant directly start a flow but can send an SMS or make a call. In order to start a flow, instead of twilio app you need to use webhook by zapier and make custom API call
Outliant.com | Zapier Expert
    Terms & ConditionsAccessibility statement