About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

  • Home
  • Get Help
  • How Do I
  • How do I automate SMS alerts for contract key dates from Airtable or Google Sheets?
Question

How do I automate SMS alerts for contract key dates from Airtable or Google Sheets?

  • 11 September 2023
  • 1 reply
  • 8 views
C

Hi everyone!

 

I’m a lawyer - and I would really like to automate zaps / SMSs -for key events in contracts. 

 

i.e SMS when the contract starts. SMS 30 days before the end of the contract etc. 

 

Does anyone have any suggestions / tips on how I can do this?

 

Ideally I would have an Airtable with the “key dates” - and an SMS send specific to each date. 

 

However - the only path I can see at the moment is putting an event for each trigger in a google calendar - and sending the same “zap” per event. 

 

Ideally I would like it to be bespoke (i.e. “contract starts tomorrow”) - and picked-up from an Airtable/ google sheet. 

 

Does anyone have any ideas for a novice like me?

 

Thanks a lot!

 

Christian 

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

Troy Tessalone
Userlevel 7
Badge +14

Hi @ChristianAyerst 

Good question.

Yes, you can use Airtable.

Airtable has Views, which are segments of data. (e.g. sort, filter, group, etc.)

Airtable Views can be used to trigger Zaps.

Airtable has Automations.

Airtable has a native integration with Twilio that can be used in Airtable Automations.

Twilio requires registering a phone number to be used for SMS.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions