How to Send SMS from Airtable in 1 Minute

December 06, 2021
Written by
Reviewed by
Paul Kamp
Twilion

header blog

Airtable is an awesome spreadsheet-and-database-like tool with lots of flexible features helpful to builders. Airtable Apps let you extend the functionality of your bases: you can use apps to bring new information into Airtable, visualize and summarize your records in colorful ways, and even directly integrate your Airtable bases with your favorite apps.  In this post, you’ll learn to send an SMS in one minute from Airtable using the Send SMS Airtable App.

Prerequisites

Setup your Airtable

Copy this ready-made Airtable base here and in the Friends tab, add a record or two (representing people you want to send messages to) containing three fields:

  1. Name (field type Single line text)
  2. Phone Number (field type Phone number)
  3. Relation (field type Single line text)

For the purposes of this post, I added two records for my mom ("Birth Giver") and my brother ("Wombmate”.) You could add a lot more records (Airtable Pro lets you add up to 50,000) so this could make sending bulk SMS very easy!

airtablebase.png

 

With your Airtable base setup, let's now send a text message from it.

Send an SMS from Airtable in One Minute

Now in the top right corner, click on Apps, followed by + Add an app.

add an app

In the search bar, search "send" and select Send SMS.

send sms app

Select a dashboard to add the app into.

dashboard
 

Click Add app followed by Get started and then paste in your Twilio Account SID, Auth Token, and a Twilio phone number from your Twilio Console.

directions: sign up for twilio, add credentials

The next page should include the source base that you had open (in our case, titled Friends), our phone number field, and the view. Add your message to be sent, and click the blue Preview button at the bottom to see how the messages would look!

If you like how the Preview looks, click the blue Send button at the bottom and tada! Text messages have been sent by Airtable.

sms sent

Conclusion

Yes, you really can send text messages that quickly with no-code using Twilio and Airtable! You could also send out customized bulk messages and updates as long as you have people's phone numbers added to Airtable. As an alternative to sending a SMS from Airtable, see our tutorial on sending SMS from Google Sheets. Let me know online what you're building with Airtable and Twilio, and stay tuned for more Airtable content on the Twilio blog like this tutorial on building a survey app with Python or how to use Airtable as a database for your Twilio app