Twilio + MySQL Integrations

How to connect Twilio + MySQL

Zapier lets you send info between Twilio and MySQL automatically—no code required. With 5,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

Connect Apps

Connect My Apps

Free forever for core features
14 day trial for premium features & apps

Top companies trust Zapier to automate work and free up time

Connect your apps and automate workflows

Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.

By signing up, you agree to Zapier's terms of service and privacy policy.

Supported triggers and actions

What does this mean?

New Phone Number
Triggered when you add a new phone number.
Trigger
Scheduled
Try It
New Recording
Triggered when a new recording is available on your account.
Trigger
Scheduled
Try It
New Transcription
Triggered when a new transcription is available on your account.
Trigger
Scheduled
Try It
- From NumberRequired
- Alphanumeric Sender ID
  Enter up to 11 characters using A-Z, a-z, 0-9 and spaces. You must enable with Twilio first and can only send to supported countries.
- To NumberRequired
  Include country code. Everything but numbers will be removed and leading + wil be added. Separate multiple numbers with commas. Example: 15554443333,44111222333.
- MessageRequired
- Media Url
  Must be a URL that Twilio can download (so private URLs or files may not work!)
- Send Large Messages?
  If yes, we'll send a message up to 1600 characters in length. This is priced as multiple messages, and you can read more about it here. If no, we'll only send a single message, truncated at 160 characters
Action
Write
- Table/ViewRequired
  We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.
- Order By
  Highly recommended! Usually you want the results to be most recent first so we can skim off only new results, so choose something like date_created or your autoincrement id. Column names that contain a space must be enclosed within brackets [ ].
- Dedupe Key
  We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.
Trigger
Scheduled
Try It

New Table
Triggered when you add a new table.
Trigger
Scheduled
Try It
- TableRequired
Action
Write

- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

New Call
Triggered when a call is finished on your Twilio number.
Trigger
Instant
Try It
- To NumberRequired
  Choose the phone number in your Twilio account you want to watch for new SMS.
- Apply US Prefix
  Automatically add 1 to 10 digits US based numbers.
Trigger
Scheduled
Try It
- From NumberRequired
- To NumberRequired
  Include country code. Everything but numbers will be removed and leading + wil be added. Separate multiple numbers with commas. Example: 15554443333,44111222333.
- MessageRequired
- Voice
- Language
- Send Digits
  A string of keys to dial after connecting to the number. Can be 0-9, #, *, or w (to wait 1/2 sec). Does not dial a new number for forwarding - for responding to a phone menu.
Action
Write
- Table/ViewRequired
Trigger
Scheduled
Try It
- QueryRequired
  Query results must have a unique id field so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.
  Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows
Trigger
Scheduled
Try It
- Table/ViewRequired
- Primary KeyRequired
  Usually something auto-incremented like id. Must be unique. Column names that contain a space must be enclosed within brackets [ ].
- Order ByRequired
  Usually something like date_updated or last_modified. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.
- Trigger Column
  Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.
Trigger
Scheduled
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
  You should include desired ordering and limiting (usually to 1 record) in the query.
  This query must run in less than ~30 seconds.
Action
Search

How Twilio + MySQL Integrations Work

Step 1: Authenticate Twilio and MySQL.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.