SQL Server + SMTP by Zapier + Gmail Integrations

How to connect SQL Server + SMTP by Zapier + Gmail

Zapier lets you send info between SQL Server, SMTP by Zapier, and Gmail automatically—no code required.

When this happens...

automatically do this...

then do this!

Free 14-day trial

5,000+ supported apps

Do even more with SQL Server + SMTP by Zapier + Gmail

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 SQL Server, SMTP by Zapier, and Gmail. 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

- Label/Mailbox
- Search String
  This works the same as the search bar you see in Gmail. For example: from:amy OR from:david or subject:dinner label:my-family. Learn more.
Trigger
Scheduled
Try It
- Label/MailboxRequired
Trigger
Scheduled
Try It

- Search StringRequired
  By default this search will trigger on emails in all folders, including Sent emails, which most people don't want. To limit results, like to your inbox, include in:inbox.
  This works the same as the search bar you see in Gmail. For example: from:amy OR from:david or in:inbox subject:dinner label:my-family. Learn more.
Trigger
Scheduled
Try It
- Label/Mailbox
Trigger
Scheduled
Try It
- SubjectRequired
- To
  Who will this email be sent to? Multiple email addresses can be entered either individually, or as a comma separated list, eg. test@example.com,example@example.com.
- Cc
  Who should be cc'd on this email? Multiple email addresses can be entered either individually, or as a comma separated list, eg. test@example.com,example@example.com.
- Bcc
  Who should be bcc'd on this email? Multiple email addresses can be entered either individually, or as a comma separated list, eg. test@example.com,example@example.com.
- From
  Select an email address or alias from your Gmail Account. Defaults to the primary email address.
- From Name
  Customize the from name (but must be sent via the email address you connected).
- Body Type
- BodyRequired
- Signature
  Include a default signature with the email? Will be placed at end of the message after a line break and another "--" line. Note: Only signatures set as your Gmail account email/alias "Signature Defaults" > "For New Emails Use" are displayed.
- Label/Mailbox
- Attachments
  A file to be attached. Can be an actual file or a public URL which will be downloaded and attached.
Action
Write
- NameRequired
  Can have parents via a simple forward slash syntax: "Parent/Child"
Action
Write
- Message to Remove Label(s) FromRequired
- Label(s) to RemoveRequired
Action
Write
- Search StringRequired
  This works the same as the search bar you see in Gmail. For example: from:amy OR from:david< or subject:dinner label:my-family. Learn more. Note: Only one email will be returned by the search.
Action
Search

- 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
- From 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.
Action
Write
New Label
Triggers when you add a new label.
Trigger
Scheduled
Try It
- Label/Mailbox
  (Note: If no Label/Mailbox is selected, this Zap will trigger on all e-mails, including Drafts.)
Trigger
Scheduled
Try It
New Starred Email
Triggers when you receive a new email and star it within two days.
Trigger
Scheduled
Try It
- Label(s) to Add
- Message to be LabeledRequired
Action
Write
- Trigger Instructions
  Important
  If you are using a Gmail trigger for this Zap, we recommend only triggering off of "Inbox" messages to avoid Zap Loops.
  For the "New Email Matching Search" Gmail trigger, please add label:inbox to the end of your "Search String."
  For the "New Email", "New Labeled Email", and "New Thread" Gmail triggers, please select INBOX for the "Label/Mailbox" field.
- ThreadRequired
  If you're not using a Gmail trigger for this Zap, we recommend adding a Search step to find the thread you want.
- To
  Who will this email be sent to? Multiple email addresses can be entered either individually, or as a comma separated list, eg. test@example.com,example@example.com.
- Cc
  Who should be cc'd on this email? Multiple email addresses can be entered either individually, or as a comma separated list, eg. test@example.com,example@example.com.
- Bcc
  Who should be bcc'd on this email? Multiple email addresses can be entered either individually, or as a comma separated list, eg. test@example.com,example@example.com.
- From
  Select an email address or alias from your Gmail Account. Defaults to the primary email address.
- From Name
  Customize the from name (but must be sent via the email address you connected).
- Body Type
- BodyRequired
- Signature
  Include a default signature with the email? Will be placed at end of the message after a line break and another "--" line. Note: Only signatures set as your Gmail account email/alias "Signature Defaults" > "For New Emails Use" are displayed.
- Label/Mailbox
- Attachments
  A file to be attached. Can be an actual file or a public URL which will be downloaded and attached.
Action
Write
- To
  Who will this email be sent to? Multiple email addresses can be entered either individually, or as a comma separated list, eg. test@example.com,example@example.com.
- Cc
  Who should be cc'd on this email? Multiple email addresses can be entered either individually, or as a comma separated list, eg. test@example.com,example@example.com.
- Bcc
  Who should be bcc'd on this email? Multiple email addresses can be entered either individually, or as a comma separated list, eg. test@example.com,example@example.com.
- From
  Select an email address or alias from your Gmail Account. Defaults to the primary email address.
- From Name
- Reply To
  Specify a single reply address other than your own.
- SubjectRequired
- Body Type
  If using the HTML option, you must add any and all formatting (paragraphs, lists, etc) directly using HTML. Learn more.
- BodyRequired
- Signature
  Include a default signature with the email? Will be placed at end of the message after a line break and another "--" line. Note: Only signatures set as your Gmail account email/alias "Signature Defaults" > "For New Emails Use" are displayed.
- Label/Mailbox
- Attachments
  A file to be attached. Can be an actual file or a public URL which will be downloaded and attached.
Action
Write
- Trigger Instructions
  Important
  If you are using a Gmail trigger for this Zap, we recommend only triggering off of "Inbox" messages to avoid Zap Loops.
  For the "New Email Matching Search" Gmail trigger, please add label:inbox to the end of your "Search String."
  For the "New Email", "New Labeled Email", and "New Thread" Gmail triggers, please select INBOX for the "Label/Mailbox" field.
- ThreadRequired
  If you're not using a Gmail trigger for this Zap, we recommend adding a Search step to find the thread you want.
- To
  Who will this email be sent to? Multiple email addresses can be entered either individually, or as a comma separated list, eg. test@example.com,example@example.com.
- Cc
  Who should be cc'd on this email? Multiple email addresses can be entered either individually, or as a comma separated list, eg. test@example.com,example@example.com.
- Bcc
  Who should be bcc'd on this email? Multiple email addresses can be entered either individually, or as a comma separated list, eg. test@example.com,example@example.com.
- From
  Select an email address or alias from your Gmail Account. Defaults to the primary email address.
- From Name
- Reply To
  Specify a single reply address other than your own.
- Body Type
  If using the HTML option, you must add any and all formatting (paragraphs, lists, etc) directly using HTML. Learn more.
- BodyRequired
- Label/Mailbox
- Attachments
  A file to be attached. Can be an actual file or a public URL which will be downloaded and attached.
Action
Write
- Search StringRequired
  This works the same as the search bar you see in Gmail. For example: from:amy OR from:david< or subject:dinner label:my-family. Learn more. Note: Only one email will be returned by the search.
- To
  Who will this email be sent to? Multiple email addresses can be entered either individually, or as a comma separated list, eg. test@example.com,example@example.com.
- Cc
  Who should be cc'd on this email? Multiple email addresses can be entered either individually, or as a comma separated list, eg. test@example.com,example@example.com.
- Bcc
  Who should be bcc'd on this email? Multiple email addresses can be entered either individually, or as a comma separated list, eg. test@example.com,example@example.com.
- From
  Select an email address or alias from your Gmail Account. Defaults to the primary email address.
- From Name
- Reply To
  Specify a single reply address other than your own.
- SubjectRequired
- Body Type
  If using the HTML option, you must add any and all formatting (paragraphs, lists, etc) directly using HTML. Learn more.
- BodyRequired
- Signature
  Include a default signature with the email? Will be placed at end of the message after a line break and another "--" line. Note: Only signatures set as your Gmail account email/alias "Signature Defaults" > "For New Emails Use" are displayed.
- Label/Mailbox
- Attachments
  A file to be attached. Can be an actual file or a public URL which will be downloaded and attached.
Action
Search or 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 SQL Server + SMTP by Zapier + Gmail Integrations Work

Step 1: Authenticate SQL Server, SMTP by Zapier, and Gmail.
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 SQL Server + SMTP by Zapier + Gmail

About SQL Server

SQL server (or MS SQL) is a top of the line database geared for the cloud

Related categories

Databases

Similar apps

MySQL

Databases

PostgreSQL

Databases

Firebase / Firestore

Databases

About SMTP by Zapier

SMTP stands for Simple Mail Transfer Protocol, which is an Internet standard for email transmission available in Microsoft, Google and Yahoo! products among millions of mail servers worldwide. Check our IMAP service as well!

Related categories

About Gmail

One of the most popular email services, Gmail keeps track of all your emails with threaded conversations, tags, and Google-powered search to find any message you need.

Learn more

Related categories

Similar apps

IMAP by Zapier

Email, Zapier

SMTP by Zapier

Email, Zapier

Microsoft Office 365

Email, Microsoft

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.

SQL Server + SMTP by Zapier + Gmail Integrations

How to connect SQL Server + SMTP by Zapier + Gmail

Do even more with SQL Server + SMTP by Zapier + Gmail

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 Attachment

Label/Mailbox

Search String

New Labeled Email

Label/MailboxRequired

New Email Matching Search

Search StringRequired

New Thread

Label/Mailbox

Create Draft

SubjectRequired

To

Cc

Bcc

From

From Name

Body Type

BodyRequired

Signature

Label/Mailbox

Attachments

Create Label

NameRequired

Remove Label from Email

Message to Remove Label(s) FromRequired

Label(s) to RemoveRequired

Find Email

Search StringRequired

New Row

Table/ViewRequired

Order By

Dedupe Key

New Table

New Row

TableRequired

Find Row

TableRequired

Lookup ColumnRequired

Lookup ValueRequired

Send Email

From Name

From EmailRequired

Reply To

ToRequired

Cc

Bcc

SubjectRequired

BodyRequired

HTML Body

Attachment

New Label

New Email

Label/Mailbox

New Starred Email

Add Label to Email

Label(s) to Add

Message to be LabeledRequired

Create Draft Reply

Trigger Instructions

Important

ThreadRequired

To

Cc

Bcc