Email by Zapier + Shopify + SQL Server Integrations

How to connect Email by Zapier + Shopify + SQL Server

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

Choose a Trigger

Start here arrow pointing down

Choose an Action

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Do even more with Email by Zapier + Shopify + SQL Server

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 Email by Zapier, Shopify, and SQL Server. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

What does this mean?

- Email AddressRequired
Trigger
Instant
Try It
- Free Test Limitation
- ToRequired
- SubjectRequired
- Body (HTML or Plain)Required
- Attachment
- From Name
- Reply To
- Cc
- Bcc
- Force Linebreaks?
- Enable read receipts?
Action
Write
- BlogRequired
- Blog Entry Status
Trigger
Scheduled
Try It
Customer Account Enabled
Triggers when a customer account is enabled.
Trigger
Instant
Try It
- Abandoned Cart Age (Hours)Required
Trigger
Scheduled
Try It

New Draft Order
Triggers when a new draft order is created
Trigger
Instant
Try It
New Order
Triggers when an order is created (with line item support).
Trigger
Instant
Try It

New Product
Triggers when a product is created.
Trigger
Instant
Try It
New Tag Added to Customer
Triggers when a new tag is added to a customer.
Trigger
Scheduled
Try It
- Inventory Item
Trigger
Instant
Try It
Updated Product
Triggers when a Product is updated, ordered or when a variant is added, removed, or updated.
Trigger
Instant
Try It
- CustomerRequired
- TagsRequired
- Overwrite existing tags?
Action
Write
- NameRequired
- External Id
- A note about the company
- Company Contact
- Contact Email
- Contact First Name
- Contact Last Name
- Contact Phone
- Contact Title
- Contact Locale
- Location
- Billing same as shipping address?
- Company Shipping Address
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address Country Code
- Shipping First Name
- Shipping Last Name
- Shipping Address Phone
- Shipping Address Recipient
- Shipping Address Zip
- Shipping Address Zone Code
- Location External ID
- Location Locale
- Location Name
- Location Note
- Location Phone
- Tax Registration Id
Action
Write
- First Name
- Last Name
- Email AddressRequired
- Customer Phone
- Company Name
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Address Phone
- Tags
- Note
- Accepts Marketing
- Tax Exempt
- Tax Exemptions
- Send E-Mail Invite
Action
Write
- Order IDRequired
- Fulfillment Order IDRequired
- Notify Customer
- Address Line 1
- Address Line 2
- City
- Country Code
- Province Code
- Zip Code
- Tracking Company
- Tracking Number
- Tracking URL
Action
Write
- Email
- Product
- Product Variant
- SKU
- Product Quantity
- Product Title
- Product Price
- Weight in Grams
- Price
- Rate
- Title
- Note
- Discount - Type
- Discount - Amount
- Discount - Code
- Additional Details
- Tags
- Buyer Accepts Marketing?
- Shipping Address Instructions
- Shipping Address - First name
- Shipping Address - Last name
- Shipping Address - Company
- Shipping Address - Phone
- Shipping Address - Address
- Shipping Address - Address con't
- Shipping Address - City
- Shipping Address - Country
- Shipping Address - Country Code
- Shipping Address - State/Province/Region
- Shipping Address - State/Province/Region Code
- Shipping Address - Postal/Zip code
- Billing Address Instructions
- Billing Address - First name
- Billing Address - Last name
- Billing Address - Company
- Billing Address - Phone
- Billing Address - Address
- Billing Address - Address con't
- Billing Address - City
- Billing Address - Country
- Billing Address - Country Code
- Billing Address - State/Province/Region
- Billing Address - State/Province/Region Code
- Billing Address - Postal/Zip code
- Send Receipt
- Send Fulfillment Receipt
- Location
- Inventory Behaviour
- Financial Status
- Fulfillment Status
- Code
- Title
- Price
- Discounted Price
- Source
Action
Write
- Product IDRequired
- Channel IDRequired
- Publish Date
Action
Write
- OrderRequired
- Amount
- Currency
- Type
- Parent Transaction
- Warning
- Gateway
Action
Write
- Order IDRequired
- Email
- Notes
- Phone
- Buyer Accepts Marketing?
- Remove Customer from Order?
- Tags
- Additional Details
- Shipping Address - Line 1
- Shipping Address - Line 2
- Shipping Address - City
- Shipping Address - Company
- Shipping Address - Country
- Shipping Address - First Name
- Shipping Address - Last Name
- Shipping Address - Latitude
- Shipping Address - Longitude
- Shipping Address - Name
- Shipping Address - Phone
- Shipping Address - Province
- Shipping Address - Province Code
- Shipping Address - ZIP
Action
Write
- Product IDRequired
- Title
- Product Type
- Vendor
- Product Status
- Product Description
- Tags
- Category
- Collections to Join
- Collections to Leave
- Handle
- Redirect Handle?
- Alt Text
- Media Content Type
- Original Source
Action
Write
- Name
- Email
Action
Search
- Order IDRequired
Action
Search
- Order IdRequired
Action
Search
- Product TitlesRequired
Action
Search
- Product Variant TitlesRequired
Action
Search
- ProductRequired
- Product Variant TitleRequired
- Exact MatchRequired
Action
Search
- Product TitleRequired
- Product TypeRequired
- VendorRequired
- Product Description
- Tags
- Published At
- Price
- Inventory Policy
- Image URL
- More Image URLs
- SKU
- Is Published?
- Publish to Point of Sale
Action
Search or write
- Table/ViewRequired
Trigger
Scheduled
Try It
- QueryRequired
Trigger
Scheduled
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
Trigger
Scheduled
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
Action
Search

- Setup Directions
Trigger
Instant
Try It
New Blog
Triggers when a new blog is added to your Shopify store.
Trigger
Scheduled
Try It
New Customer
Triggers when a new customer is added to your Shopify account.
Trigger
Scheduled
Try It
- Risk Level
Trigger
Scheduled
Try It
New Cancelled Order
Triggers whenever an order is cancelled (with line item support).
Trigger
Instant
Try It
New Fulfilled Order
Triggers when an order is fulfilled (with line item support).
Trigger
Instant
Try It
New Paid Order
Triggers when an order is paid (with line item support).
Trigger
Instant
Try It
New Refund
Triggers when a refund or partial refund occurs.
Trigger
Instant
Try It
Updated Customer
Triggers when a customer's information is updated.
Trigger
Instant
Try It
Updated Order
Triggers when an order is updated (with line item support).
Trigger
Instant
Try It
- Order IDRequired
- Type of Line Item to AddRequired
- Reason for Edit
- Notify the Customer?
Action
Write
- BlogRequired
- TitleRequired
- Author NameRequired
- ContentRequired
- Featured Image URL
- Excerpt/Summary
- Tags
- Is Published?
Action
Write
- Product IDRequired
- Add New Image - File
- Add New Image - Alt Text
- Choose Existing Image
- Price
- Compare-at Price
- Charge Tax On This Variant?
- Cost Per Item
- SKU (Stock Keeping Unit)
- Barcode (ISBN, UPC, GTIN, etc.)
- Track Quantity?
- Continue Selling When Out of Stock?
- This Is a Physical Product
- Weight
- Weight Unit
- Country/Region of Origin
- Harmonized System (HS) code
- Position
- Requires Components
- Tax Code
Action
Write
- Email
- Product
- Product Variant
- Product Quantity
- Product Title
- Product Price
- Weight in Grams
- Note
- Discount - Type
- Discount - Amount
- Discount - Code
- Additional Details
- Tags
- Shipping Address Instructions
- Shipping Address - First name
- Shipping Address - Last name
- Shipping Address - Company
- Shipping Address - Phone
- Shipping Address - Address
- Shipping Address - Address con't
- Shipping Address - City
- Shipping Address - Country
- Shipping Address - State/Province/Region
- Shipping Address - Postal/Zip code
- Billing Address Instructions
- Billing Address - First name
- Billing Address - Last name
- Billing Address - Company
- Billing Address - Phone
- Billing Address - Address
- Billing Address - Address con't
- Billing Address - City
- Billing Address - Country
- Billing Address - State/Province/Region
- Billing Address - Postal/Zip code
Action
Write
- Adjust or Set quantity?Required
- The name of quantities to be changedRequired
- The reason for the quantity changesRequired
- LocationRequired
- Product
- Product VariantRequired
- Quantity to Set or Adjust
Action
Write
- TitleRequired
- Product Type
- Vendor
- Product Status
- Product Description
- Tags
- Collection ID
- Handle
- Note
- First Product Option
- Values for First Product Option
- Second Product Option
- Values for Second Product Option
- Third Product Option
- Values for Third Product Option
- Category
- Alt Text
- Media Content Type
- Original Source
Action
Write
- CustomerRequired
- TagsRequired
Action
Write
- CustomerRequired
- First Name
- Last Name
- Email Address
- Company Name
- Default Address
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Tags
- Phone Number
- Note
- Tax Exempt
- Tax Exemptions
- Accepts Marketing
Action
Write
- ProductRequired
- Product VariantRequired
- Title
- Price
- Compare at Price
- SKU
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Query - Name
- Query - Confirmation Number
- Query - Email
- Query - Customer ID
- Query - Location ID
- Query - SKU
- Query - Order ID
- Sort Key
- Reverse?
- Raw Query
Action
Search
- Owner ResourceRequired
- Owner IdRequired
Action
Search
- IdsRequired
Action
Search
- Product TitleRequired
Action
Search
- Product Variant SKURequired
Action
Search
- Name
- Email AddressRequired
- First Name
- Last Name
- Customer Phone
- Company Name
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Address Phone
- Tags
- Note
- Accepts Marketing
- Tax Exempt
- Tax Exemptions
- Send E-Mail Invite
Action
Search or write
- ProductRequired
- TitleRequired
- Exact MatchRequired
- Price
- Compare at Price
- SKU
- Inventory Policy
Action
Search or write
- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Scheduled
Try It
New Table
Triggers when you add a new table.
Trigger
Scheduled
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- QueryRequired
Action
Search

Top companies trust Zapier to automate work and free up time

Join millions worldwide who automate their work using Zapier

How Email by Zapier + Shopify + SQL Server Integrations Work

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

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!

Learn more Help

Related categories

About Shopify

Shopify is a simple way to create an online store to list products, collect credit card payments, and ship your goods.

Learn more Help

Related categories

eCommerce

About SQL Server

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

Learn more Help

Related categories

Databases

Email by Zapier + Shopify + SQL Server Integrations

How to connect Email by Zapier + Shopify + SQL Server

Do even more with Email by Zapier + Shopify + SQL Server

New Inbound Email

Send Outbound Email

New Blog Entry

Customer Account Enabled

New Abandoned Cart

New Draft Order

New Order

New Product

New Tag Added to Customer

Updated Inventory

Updated Product

Add Tag to Customer

Create Company

Create Customer

Create Fulfillment

Create Order

Publish Product

Create Transaction

Update Order

Update Product

Find Customer

Get Order by ID

Find Order Transactions

Find Products by Title (With Line Item Support)

Find Product Variants by Title (With Line Item Support)

Find Product Variant by Title

Find or Create Product

New Column

New Row (Custom Query)

New or Updated Row

Update Row

Find Multiple Rows via Custom Query

New Read Receipt

New Blog

New Customer

New Fraudulent Order

New Cancelled Order

New Fulfilled Order

New Paid Order

New Refund

Updated Customer

Updated Order

Add Line Item to Order

Create Blog Entry

Create Product Variant

Create Draft Order

Update Inventory Quantity (with line item support).

Create Product

Remove Tag from Customer

Update Customer

Update Product Variant

API Request (Beta)

Find Order

Find Metafields

Find Products by ID (With Line Item Support)

Find Product by Title

Find Product Variant by SKU

Find or Create Customer

Find or Create Product Variant

New Row

New Table

New Row

Find Row

Find Row via Custom Query

Join millions worldwide who automate their work using Zapier

About Email by Zapier

Related categories

About Shopify

Related categories

About SQL Server

Related categories

Similar apps

MySQL

PostgreSQL

Firebase / Firestore

Other Email by Zapier + Shopify Integrations

Other Email by Zapier + SQL Server Integrations