Loading

Email by Zapier + MySQL Integrations

How to connect Email by Zapier + MySQL

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

Choose a Trigger
Start herearrow pointing down
Start herearrow pointing down
Choose an Action
Connect Apps
  • Free forever for core features
  • 14 day trial for premium features & apps

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.


OR

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


OR

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

Supported triggers and actions

What does this mean?
    • 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
    • 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
  • MySQL triggers, actions, and search

    New Table

    Triggered when you add a new table.

    Trigger
    Scheduled
    Try It
    • 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
    • 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

How Email by Zapier + MySQL Integrations Work

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

Email by Zapier Tutorials

email logo
email logo

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

  • Email
  • Zapier
mysql logo
mysql logo

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

Similar apps

SQL Server integrationsSQL Server integrations

SQL Server

Databases
Quick Base integrationsQuick Base integrations

Quick Base

Databases
Firebase / Firestore integrationsFirebase / Firestore integrations

Firebase / Firestore

Databases

Get started for free

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


OR

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