• Home

  • Automation with Zapier

  • Zapier tutorials

Zapier tutorials

3 min read

How to send emails for new Airtable records

By Daniel Kenitz · November 27, 2023
A hero image of the Airtable app logo connected to the Gmail app logo on a light blue background.

Airtable is a great resource for teams big and small, from tracking individual to-dos to creating large enterprise databases. Every time a new record shows up in an Airtable, it can be an important event. Someone on your team may need to read about a project update. A salesperson may need to follow up on a new lead. Or a manager may need to review changes to an upcoming campaign. 

That's where Zapier can help. With a Zap—Zapier's automated workflows—you can automatically send an email for new records added to your Airtable base. Create effortless, real-time communication to update everyone who needs to be in the know—without any extra effort. Here's how.

New to Zapier? It's workflow automation software that lets you focus on what matters. Combine user interfaces, data tables, and logic with thousands of apps to build and automate anything you can imagine. Sign up for free.

Before you begin

You can set up this workflow in a couple of different ways. If you want to receive an email for any record that comes into your Airtable table, you don't need to do any additional setup before you start building your Zap.

But if you only want to receive emails for some records, you'll need to create a view in Airtable that only includes those records. 

In Airtable, go to the Views sidebar, and scroll down to the Create... section. Choose the type of view you'd like to create, then click Create new view. We'll go with a grid view, in our example.

Adding a new view in Airtable from the Create... menu.

By default, your new view will contain all the records in your table. Use filters to limit the view so it only includes the type of records you'd want to trigger an email in your Zap.

An orange box highlights the Filter menu in an Airtable Table.

Make sure you have at least one record in your view before you set up your Zap.

Send emails in Gmail from Airtable records

Zapier lets you create automated workflows called Zaps, which send your information from one app to another. You can create your own Zap from scratch without any coding knowledge, but we also offer quick templates to get you started. 

If you'd like to start with a template, click the Use this Zap button below, and you'll be taken to the Zapier editor. You'll need to create a Zapier account if you don't already have one. Then, follow the directions below to set up your Zap.

Send Gmail messages for new Airtable records in views

Send Gmail messages for new Airtable records in views
  • Airtable logo
  • Gmail logo
Airtable + Gmail

Set up your Airtable trigger

Let's start with the trigger, which is the event that starts your Zap. If you're using the Zap template, this will be selected for you. If not, search for and select Airtable for your trigger app and New Record for your trigger event. Then click Continue

A trigger step in the Zap editor with Airtable selected for the trigger app and New Record selected for the trigger event.

Connect your Airtable account, if you haven't already, then click Continue.

Next, select the Airtable base you'd like to use in your Zap in the Base field.

New Leads has been selected in the Base field in an Airtable trigger step in the Zap editor.

Next, select the specific table that includes the records you want to receive emails for.

If you want to receive emails for all records in this table, you're done setting up your trigger and can click Continue.

But if you want to only trigger this Zap for a specific view, like we covered above, you'll need to select the view you set up earlier in the Limit to View field. 

Grid View 2 has been selected in the Limit to View field in an Airtable trigger step in the Zap editor.

Once that's selected, click Continue.

Now it's time to test your trigger step. Click Test and Zapier will show you three recent records in your Airtable account. Click the record you'd like to use to set up the rest of your Zap, then click Continue with selected record.

A set of Airtable test records in the Zap editor.

If everything looks right, it's time to move on to your action step.

Set up your Gmail action

Now it's time to set up your action, which is the event your Zap will perform once it's triggered. Search for and select Gmail for your action app and Send email as your action event, then click Continue. If you're using the Zap template, this will already be selected for you.

An action step in the Zap editor with Gmail selected for the action app and Send Email selected for the trigger event.

Connect your Gmail account to Zapier, just as you did with Airtable, then click Continue

Now it's time to customize your action step. Add who you want to send the email to, who it's from (which will be the Gmail address associated with the account you connected to Zapier), and add any CCs or BCCs you'd like.

Gmail fields in an action step in the Zap editor.

Fill in the Subject and Body fields. You can add data from your previous Airtable step by clicking in the field and selecting it from the Insert Data dropdown. 

The subject and body fields in a Gmail action step in the Zap editor.

Once you're finished customizing your action step, click Continue.

Next, click Test step to test your Zap. Once the test runs, an email will be sent to the email address you specified in your action step. Double check the email to make sure it looks right. Here's what ours looked like:

An email in Gmail following up with a lead.

If everything looks right, you're now ready to use your Zap. Now every time a new record is sent to your Airtable view, Gmail will automatically send an email with the details you specified.

Send Gmail messages for new Airtable records in views

Send Gmail messages for new Airtable records in views
  • Airtable logo
  • Gmail logo
Airtable + Gmail

Related reading:

  • What is Airtable?

  • Popular ways to automate Airtable

  • How to automate Gmail

  • How to connect Airtable to webhooks

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags
mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'