Send customized emails via Gmail [Business Gmail Accounts Only] and get alerts in Slack for new Airtable records

First, we need to connect Airtable, Gmail and Slack to Zapier.

• 

  Create Zapier account.

  Create Zapier account if you don't have one.

• 

  Connect Airtable to Zapier.

  Give Zapier access to your Airtable account, using Airtable credentials.

• 

  Connect Gmail to Zapier.

  Give Zapier access to your Gmail account, using Gmail credentials.

• 

  Connect Slack to Zapier.

  Give Zapier access to your Slack account, using Slack credentials.

Next, we need to create a workflow automation scenario using graphical no-code web interface of Zapier.

• 

  Set up a Trigger action for Airtable

  Choose the following trigger: New Record In View (Triggers when a new new record is created in a specifc view.).

• 

  Then set up an Action for Gmail

  Choose this action: Send Email (Create and send a new email message.).

• 

  Then set up another Action for Slack

  Choose this action: Send Channel Message (Post a new message to a specific #channel you choose. Can also schedule a message for later.).

• 

  Then set up another Action for Airtable

  Choose this action: New Record (Triggers when a new record is created. Optionally: triggers when any record (new or existing) is first added to a selected view.).

Finally, we need to test this automation and publish it.

• 

  Customize data flow

  Configure the data that is exchanged between Airtable, Gmail and Slack.

• 

  Test the workflow and turn it on for production use

  Test your scenario and publish to production. Now you have an automatic workflow, that will Send customized emails via Gmail [Business Gmail Accounts Only] and get alerts in Slack for new Airtable records!