How to connect Schedule by Zapier + SMTP by Zapier + MySQL
Zapier lets you send info between Schedule by Zapier, SMTP by Zapier, and MySQL automatically—no code required.
Do even more with Schedule by Zapier + SMTP by Zapier + MySQL
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 Schedule by Zapier, SMTP by Zapier, and MySQL. And don’t forget that you can add more apps and actions to create complex workflows.
Trigger on weekends?
Should this Zap trigger on Saturday and Sunday?
Time of DayRequired
Triggers relative to your timezone settings and defaults to UTC (GMT+00:00) if no preference is set. Note: You can also specify a time with a Custom Value in the formats "hh:mm aa", "hh:mm", or "hhhh" (e.g. "2:30pm", "14:30", or "1430").
Try ItDay of the MonthRequired
Day of month this schedule should trigger on.
Time of DayRequired
Triggers relative to your timezone settings and defaults to UTC (GMT+00:00) if no preference is set. Note: You can also specify a time with a Custom Value in the formats "hh:mm aa", "hh:mm", or "hhhh" (e.g. "2:30pm", "14:30", or "1430").
Try ItFrom Name
This will be your "display name" when sending.
From EmailRequired
We will attempt to send from this email.
Reply To
Specify a reply address other than the from.
ToRequired
Can be a comma separated list of emails.
Cc
Can be a comma separated list of emails.
Bcc
Can be a comma separated list of emails.
SubjectRequired
BodyRequired
The email message in plain text
HTML Body
The email message formatted using HTML
Attachment
A file object to be attached to the email. Plain text content will converted into a txt file and attached.
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 It
Trigger on weekends?
Should this Zap trigger on Saturday and Sunday?
Try ItDay of the WeekRequired
Time of DayRequired
Triggers relative to your timezone settings and defaults to UTC (GMT+00:00) if no preference is set. Note: You can also specify a time with a Custom Value in the formats "hh:mm aa", "hh:mm", or "hhhh" (e.g. "2:30pm", "14:30", or "1430").
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 It
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.
How Schedule by Zapier + SMTP by Zapier + MySQL Integrations Work
- Step 1: Authenticate Schedule by Zapier, SMTP 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.
Related categories
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.