MySQL + Airtable + Email by Zapier Integrations

Zapier lets you send info between MySQL and Airtable and Email by Zapier automatically—no code required. With 5,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

Get Started for Free

Free forever for core features
14 day trial for premium features & apps

Do even more with MySQL + Airtable + Email by Zapier

With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with MySQL, Airtable, and Email by Zapier. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

What does this mean?

- Table/ViewRequired
Trigger
Scheduled
Try It
- QueryRequired
  Query results must have a unique id field so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.
  Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows
Trigger
Scheduled
Try It
- Table/ViewRequired
- Primary KeyRequired
  Usually something auto-incremented like id. Must be unique. Column names that contain a space must be enclosed within brackets [ ].
- Order ByRequired
  Usually something like date_updated or last_modified. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.
- Trigger Column
  Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.
Trigger
Scheduled
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
  You should include desired ordering and limiting (usually to 1 record) in the query.
  This query must run in less than ~30 seconds.
Action
Search

- BaseRequired
- TableRequired
- Help Text
  You must have at least one "Last Modified Time" type column in your Table in order to use this Trigger. Learn more about those here.
- Which timestamp field should this Zap use to check for updates?Required
  When this column changes to a new timestamp, your Zap will trigger on the corresponding record. Note: Must be a Last Modified Time column type.
- Limit to View
  Filter on updates to a specific View in your Table.
- Include file contents?
  Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Trigger
Scheduled
Try It
- BaseRequired
  Base in which to create the record.
- TableRequired
Action
Write

- Api Docs Info
  API docs for Airtable are located here https://airtable.com/api
- HTTP MethodRequired
- URLRequired
  Requests can only be made to domains associated by this application.
- Query String Parameters
  These params will be URL-encoded and appended to the URL when making the request.
- Headers
  Authentication headers are included automatically
- Additional Request Headers
  Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
- Body
  Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.
Action
Write
- BaseRequired
  Base to search for a record.
- TableRequired
  Pick an Airtable table that you want to search.
- Search by Field
  Pick a field from the base to match against the search value.
- Search Value
  The value of unique identifier for the record.
- Search Formula
  (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
- Limit to View
  You can optionally limit the search to a specific view id.
Action
Search
- BaseRequired
  Base in which to create the record.
- TableRequired
  Pick an Airtable table that you want to search.
- Search by Field
  Pick a field from the base to match against the search value.
- Search Value
  The value of unique identifier for the record.
- Search Formula
  (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
- Limit to View
  You can optionally limit the search to a specific view id.
Action
Search or write
- Setup Directions
  In order to trigger when emails are opened, this must be paired with a separate Zap using the Send Outbound Email action, with the Enable Read Receipts? field set to True.
  To test with a live email, send an email to yourself using your Send Outbound Email action (with read receipts enabled) and open it, then test this trigger immediately for samples. If you don't need to test with live data, click Skip Test to use static test data.
Trigger
Instant
Try It

- Table/ViewRequired
  We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.
- Order By
  Highly recommended! Usually you want the results to be most recent first so we can skim off only new results, so choose something like date_created or your autoincrement id. Column names that contain a space must be enclosed within brackets [ ].
- Dedupe Key
  We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.
Trigger
Scheduled
Try It
New Table
Triggered when you add a new table.
Trigger
Scheduled
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- BaseRequired
- TableRequired
- Limit to View
  (Optional) Limit to records added to a specific View, and return records in the View order.
- Include file contents?
  Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Trigger
Scheduled
Try It
- BaseRequired
  Base in which to create the record.
- TableRequired
Action
Write
- BaseRequired
  Pick the Airtable base containing the records you wish to update.
- TableRequired
  Pick the Airtable table containing the records you wish to update.
- RecordRequired
  Pick the Airtable record that you wish to update.
Action
Write
- BaseRequired
  Base to search for a record.
- TableRequired
  Pick an Airtable table that you want to search.
- Search by Field
  Pick a field from the base to match against the search value.
- Search Value
  The value of unique identifier for the record.
- Search Formula
  (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
- Limit to View
  Limit the search to a specific view. Useful for sorting results.
- Include file contents?
  Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Action
Search
- BaseRequired
  Base in which to create the record.
- TableRequired
  Pick an Airtable table that you want to search.
- Search by Field
  Pick a field from the base to match against the search value.
- Search Value
  The value of unique identifier for the record.
- Search Formula
  (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
- Limit to View
  Limit the search to a specific view. Useful for sorting results.
- Include file contents?
  Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Action
Search or write
- Email AddressRequired
  Customize the private email address associated with your mailbox. Be sure to use lowercase and numbers only. Just forward emails to this address to trigger this Zap. Want to receive to your own email address? Try Mailgun, IMAP, Mandrill, or Gmail instead.
Trigger
Instant
Try It
- ToRequired
  Can be a comma separated list of emails. Limited to 5.
- SubjectRequired
- Body (HTML or Plain)Required
  You can place HTML in here and we will send it as is. If this is plain text, we will try to convert it to some very basic HTML for greater client compatibility.
- Attachment
  A file object to be attached to the email. Plain text content will converted into a txt file and attached. Please note, if the file is over ~10mb or so, you should explore using other email sending techniques (like Gmail or SMTP).
- From Name
  This will be your "display name" when sending. Want to send from your own email address? Try Mailgun, IMAP, Mandrill or Gmail apps instead.
- Reply To
  Specify a reply address other than your own.
- Cc
  Can be a comma separated list of emails. Limited to 5.
- Bcc
  Can be a comma separated list of emails. Limited to 5.
- Force Linebreaks?
  Set this to "yes" if your emails are received without line breaks or spacing.
- Enable read receipts?
  Want to be notified when this email is opened? Set this to to True and set up a Zap using the New Read Receipt trigger.
Action
Write

Top companies trust Zapier to automate work and free up time

Connect your apps and automate workflows

Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.

By signing up, you agree to Zapier's terms of service and privacy policy.

How to connect MySQL + Airtable + Email by Zapier

Step 1: Authenticate MySQL, Airtable, and Email by Zapier.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.

Connect apps

Connect MySQL + Airtable + Email by Zapier

About MySQL

MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.

Learn more

Related categories

Databases

Similar apps

SQL Server

Databases

Quick Base

Databases

Firebase / Firestore

Databases

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Learn more

Related categories

Databases

Similar apps

Quick Base

Databases

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

About Email by Zapier

Send and receive email via a custom Zapier email address at "zapiermail.com". This is great for triggering off of emails and sending custom emails. (Max of 10 email sends per hour.) Have direct access to your own email servers? Check out our IMAP and SMTP services!

Related categories

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

MySQL + Airtable + Email by Zapier Integrations

MySQL + Airtable + Email by Zapier Integrations

Do even more with MySQL + Airtable + Email by Zapier

New Column

New Row (Custom Query)

QueryRequired

New or Updated Row

Table/ViewRequired

Primary KeyRequired

Order ByRequired

Trigger Column

Update Row

TableRequired

ID ColumnRequired

Find Row via Custom Query

QueryRequired

New or Updated Record

BaseRequired

TableRequired

Help Text

Which timestamp field should this Zap use to check for updates?Required

Limit to View

Include file contents?

Create Records (With Line Item Support)

BaseRequired

TableRequired

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find Record

BaseRequired

TableRequired

Search by Field

Search Value

Search Formula

Limit to View

Find or Create Record

BaseRequired

TableRequired

Search by Field

Search Value

Search Formula

Limit to View

New Read Receipt

Setup Directions

New Row

Table/ViewRequired

Order By

Dedupe Key

New Table

New Row

TableRequired

Find Row

TableRequired

Lookup ColumnRequired

Lookup ValueRequired

New Record

BaseRequired

TableRequired

Limit to View

Include file contents?

Create Record

BaseRequired

TableRequired

Update Record

BaseRequired

TableRequired

RecordRequired

Find Many Records (With Line Item Support)

BaseRequired

TableRequired

Search by Field

Search Value

Search Formula

Limit to View