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.
- Free forever for core features
- 14 day trial for premium features & apps
Quickly automate Email by Zapier and MySQL workflows with Zapier's templates
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.
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.
Try ItToRequired
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 theNew Read Receipt
trigger.
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 autoincrementid
. 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.
Try ItNew Table
Triggered when you add a new table.
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.
Try ItTable/ViewRequired
Try ItQueryRequired
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
Try ItTable/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
orlast_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.
Try It
How Email by Zapier + MySQL Integrations Work
- Step 1: Authenticate Email by Zapier and MySQL.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.
Email by Zapier Tutorials
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.