Automated Airtable sales notifications in Zapier

Become a Pro member to access all content

240+ instructional videos led by professionals
Weekly expert workshops and replays
1-1 consultation with the Makerpad team
Over $50k in discounts for tools
Private peer community
Profile for tracking progress and sharing your work
Yearly pricing
$249/year
Start your 7 day free trial*
Get PRO Yearly
Lifetime pricing
$600billed once
Start your 7 day free trial*
Get PRO Lifetime

In this tutorial we'll show you how to use Zapier and Twilio to send automated notifications when a deal reaches a certain stage of your sales pipeline. All without code.

Step 1

First, open up your Airtable sales pipeline. Create a new view by selecting the arrow in the top left hand corner and Add a Grid View. Filter where the Sales Stage is Closed-Won. You will now see any sales that have the Closed-Won status applied. Name your new Grid View - Deals Won.

Step 2

Open Zapier and create a new Zap. Name it first so you don't lose it. Choose Airtable as the trigger, select 'New Record in View'. Find your Base and your Sales Deals table. In the View field select Deals Won. Press Continue then Test and Continue. Check that the Zap is getting data from Airtable.

Next, add an Action. Find and select Gmail and create an email adding in data from the previous Airtable step to showcase the new Deal that has been done. Subject - New Deal Done: <Client Name> as an example. Test and continue.

Finally add another action. Find and select Twilio.

Step 3

Select Send SMS in Twilio. Sign in and connect your Twilio account by adding your SID and Auth token from you Twilio account page.

Choose your Twilio number from the From field. Add a number of the person you want the SMS going to and customise the Message to contain the deal details from our Airtable Trigger step. Client name and Deal Value are two good ones to include.

Test and continue and check if the SMS comes through to your phone!

You're done. Turn on your Zap and each time a new deal gets the status of Closed-Won it will trigger an Email and SMS.

I hope you enjoyed this tutorial, if you have any questions please reach out on Twitter @tomosman or @makerpad.

Join today for free and access 200+ tutorials

Join Makerpad today and you'll get access to hundreds of tutorials and educational content to help you create projects, automate workflows, and build software, without writing code.

Learn alongside 4 thousand professionals, no coding required.

Get Started Free

In this tutorial we'll show you how to use Zapier and Twilio to send automated notifications when a deal reaches a certain stage of your sales pipeline. All without code.

Step 1

First, open up your Airtable sales pipeline. Create a new view by selecting the arrow in the top left hand corner and Add a Grid View. Filter where the Sales Stage is Closed-Won. You will now see any sales that have the Closed-Won status applied. Name your new Grid View - Deals Won.

Step 2

Open Zapier and create a new Zap. Name it first so you don't lose it. Choose Airtable as the trigger, select 'New Record in View'. Find your Base and your Sales Deals table. In the View field select Deals Won. Press Continue then Test and Continue. Check that the Zap is getting data from Airtable.

Next, add an Action. Find and select Gmail and create an email adding in data from the previous Airtable step to showcase the new Deal that has been done. Subject - New Deal Done: <Client Name> as an example. Test and continue.

Finally add another action. Find and select Twilio.

Step 3

Select Send SMS in Twilio. Sign in and connect your Twilio account by adding your SID and Auth token from you Twilio account page.

Choose your Twilio number from the From field. Add a number of the person you want the SMS going to and customise the Message to contain the deal details from our Airtable Trigger step. Client name and Deal Value are two good ones to include.

Test and continue and check if the SMS comes through to your phone!

You're done. Turn on your Zap and each time a new deal gets the status of Closed-Won it will trigger an Email and SMS.

I hope you enjoyed this tutorial, if you have any questions please reach out on Twitter @tomosman or @makerpad.

Become a Pro member to access all content

240+ instructional videos led by professionals
Weekly expert workshops and replays
1-1 consultation with the Makerpad team
Over $50k in discounts for tools
Private peer community
Profile for tracking progress and sharing your work
Yearly pricing
$249/year
Start your 7 day free trial*
Get PRO Yearly
Lifetime pricing
$600billed once
Start your 7 day free trial*
Get PRO Lifetime

In this tutorial we'll show you how to use Zapier and Twilio to send automated notifications when a deal reaches a certain stage of your sales pipeline. All without code.

Step 1

First, open up your Airtable sales pipeline. Create a new view by selecting the arrow in the top left hand corner and Add a Grid View. Filter where the Sales Stage is Closed-Won. You will now see any sales that have the Closed-Won status applied. Name your new Grid View - Deals Won.

Step 2

Open Zapier and create a new Zap. Name it first so you don't lose it. Choose Airtable as the trigger, select 'New Record in View'. Find your Base and your Sales Deals table. In the View field select Deals Won. Press Continue then Test and Continue. Check that the Zap is getting data from Airtable.

Next, add an Action. Find and select Gmail and create an email adding in data from the previous Airtable step to showcase the new Deal that has been done. Subject - New Deal Done: <Client Name> as an example. Test and continue.

Finally add another action. Find and select Twilio.

Step 3

Select Send SMS in Twilio. Sign in and connect your Twilio account by adding your SID and Auth token from you Twilio account page.

Choose your Twilio number from the From field. Add a number of the person you want the SMS going to and customise the Message to contain the deal details from our Airtable Trigger step. Client name and Deal Value are two good ones to include.

Test and continue and check if the SMS comes through to your phone!

You're done. Turn on your Zap and each time a new deal gets the status of Closed-Won it will trigger an Email and SMS.

I hope you enjoyed this tutorial, if you have any questions please reach out on Twitter @tomosman or @makerpad.

In this tutorial we'll show you how to use Zapier and Twilio to send automated notifications when a deal reaches a certain stage of your sales pipeline. All without code.

Step 1

First, open up your Airtable sales pipeline. Create a new view by selecting the arrow in the top left hand corner and Add a Grid View. Filter where the Sales Stage is Closed-Won. You will now see any sales that have the Closed-Won status applied. Name your new Grid View - Deals Won.

Step 2

Open Zapier and create a new Zap. Name it first so you don't lose it. Choose Airtable as the trigger, select 'New Record in View'. Find your Base and your Sales Deals table. In the View field select Deals Won. Press Continue then Test and Continue. Check that the Zap is getting data from Airtable.

Next, add an Action. Find and select Gmail and create an email adding in data from the previous Airtable step to showcase the new Deal that has been done. Subject - New Deal Done: <Client Name> as an example. Test and continue.

Finally add another action. Find and select Twilio.

Step 3

Select Send SMS in Twilio. Sign in and connect your Twilio account by adding your SID and Auth token from you Twilio account page.

Choose your Twilio number from the From field. Add a number of the person you want the SMS going to and customise the Message to contain the deal details from our Airtable Trigger step. Client name and Deal Value are two good ones to include.

Test and continue and check if the SMS comes through to your phone!

You're done. Turn on your Zap and each time a new deal gets the status of Closed-Won it will trigger an Email and SMS.

I hope you enjoyed this tutorial, if you have any questions please reach out on Twitter @tomosman or @makerpad.

Join today for free and access 200+ tutorials

Join Makerpad today and you'll get access to hundreds of tutorials and educational content to help you create projects, automate workflows, and build software, without writing code.

Learn alongside 4 thousand professionals, no coding required.

Get Started Free

In this tutorial we'll show you how to use Zapier and Twilio to send automated notifications when a deal reaches a certain stage of your sales pipeline. All without code.

Step 1

First, open up your Airtable sales pipeline. Create a new view by selecting the arrow in the top left hand corner and Add a Grid View. Filter where the Sales Stage is Closed-Won. You will now see any sales that have the Closed-Won status applied. Name your new Grid View - Deals Won.

Step 2

Open Zapier and create a new Zap. Name it first so you don't lose it. Choose Airtable as the trigger, select 'New Record in View'. Find your Base and your Sales Deals table. In the View field select Deals Won. Press Continue then Test and Continue. Check that the Zap is getting data from Airtable.

Next, add an Action. Find and select Gmail and create an email adding in data from the previous Airtable step to showcase the new Deal that has been done. Subject - New Deal Done: <Client Name> as an example. Test and continue.

Finally add another action. Find and select Twilio.

Step 3

Select Send SMS in Twilio. Sign in and connect your Twilio account by adding your SID and Auth token from you Twilio account page.

Choose your Twilio number from the From field. Add a number of the person you want the SMS going to and customise the Message to contain the deal details from our Airtable Trigger step. Client name and Deal Value are two good ones to include.

Test and continue and check if the SMS comes through to your phone!

You're done. Turn on your Zap and each time a new deal gets the status of Closed-Won it will trigger an Email and SMS.

I hope you enjoyed this tutorial, if you have any questions please reach out on Twitter @tomosman or @makerpad.

In this tutorial we'll show you how to use Zapier and Twilio to send automated notifications when a deal reaches a certain stage of your sales pipeline. All without code.

Step 1

First, open up your Airtable sales pipeline. Create a new view by selecting the arrow in the top left hand corner and Add a Grid View. Filter where the Sales Stage is Closed-Won. You will now see any sales that have the Closed-Won status applied. Name your new Grid View - Deals Won.

Step 2

Open Zapier and create a new Zap. Name it first so you don't lose it. Choose Airtable as the trigger, select 'New Record in View'. Find your Base and your Sales Deals table. In the View field select Deals Won. Press Continue then Test and Continue. Check that the Zap is getting data from Airtable.

Next, add an Action. Find and select Gmail and create an email adding in data from the previous Airtable step to showcase the new Deal that has been done. Subject - New Deal Done: <Client Name> as an example. Test and continue.

Finally add another action. Find and select Twilio.

Step 3

Select Send SMS in Twilio. Sign in and connect your Twilio account by adding your SID and Auth token from you Twilio account page.

Choose your Twilio number from the From field. Add a number of the person you want the SMS going to and customise the Message to contain the deal details from our Airtable Trigger step. Client name and Deal Value are two good ones to include.

Test and continue and check if the SMS comes through to your phone!

You're done. Turn on your Zap and each time a new deal gets the status of Closed-Won it will trigger an Email and SMS.

I hope you enjoyed this tutorial, if you have any questions please reach out on Twitter @tomosman or @makerpad.

Get help and discuss

Open community forum

More lessons

How to Build a Functional & Responsive Pricing Page like Notion's in Webflow
How to Build a No-code Pricing Page like Dropbox in Webflow
How to Build a Functional & Responsive Pricing Page
Develop a custom CRM using Retool and 8base
Generate a task list for projects in Airtable
Generate pre-filled contracts in Hubspot using PandaDoc
Sync files across Airtable, Hubspot, and Google Drive
Pre-Fill Airtable forms and link forms to existing records
Automate recurring interactions in your deal & project cycle
Connect Hubspot Deals to Airtable
Automate scheduling meetings, calendar invites, and CRM admin work
Sales automation workflow using Typeform / Airtable / Callingly
Capture email metadata and save as an image with Zapier
Find & save competitor info and emails with Hunter
Email outreach & sequencing with Reply.io & Gmail
Source Leads from a Spreadsheet with Dashdash
Send a personalized download link with YAMM
Create a targeted sales list in dashdash
Auto-accept LinkedIn invites
Automate + qualify your lead generation with Standard Library
Generate and send contracts automatically with PandaDoc
Create a sales pipeline in Airtable
Automated sales reporting for Shopify with Integromat
Pull LinkedIn Company info & create a new record in Webflow
Build a Mail Merge with Airtable, Gmail, and Standard Library.
Build a Slack / Airtable / Stripe CRM
Update salesforce opportunities with computed data
Automatically get data from Mailchimp to your CRM
Sales CRM - build a sales pipeline
Fundraising CRM - Startups seeking to raise funding
👨‍👩‍👧‍👦Personal CRM - keep track of people in your life
Segmenting prospects for sales funnels
Browse all →

If you'd like this template, message @bentossell on Slack with your email for the account to send this template.