Connect Microsoft Office 365 and Shopify to unlock the power of automation

No credit card required
Free forever for core features
14-day trial for premium features and apps

Choose a Trigger

Choose an Action

Start with Google for free

Top companies trust Zapier to automate work that solves their unique business problems—no coding required.

Set up your first integration

Quickly connect Microsoft Office 365 to Shopify with a Zapier template.

Our most popular template

Update contacts in Microsoft Office 365 when customers are updated in Shopify
Premium
Details
Try it
Shopify + Microsoft Office 365

Update contacts in Microsoft Office 365 when customers are updated in Shopify

Details

Try it

Shopify + Microsoft Office 365

How Zapier works

Zapier makes it easy to integrate Microsoft Office 365 with Shopify - no code necessary. See how you can get setup in minutes.

100%

Help

1. Choose trigger event

2. Choose action

1. Select the event

Setup

Test

App

Trigger event

Choose a trigger event

Choose a trigger

A trigger is the event that starts your Zap—like a "Calendar Event Start" from Microsoft Office 365.

Add your action

An action happens after the trigger—such as "Add Line Item to Order" in Shopify.

You’re connected!

Zapier seamlessly connects Microsoft Office 365 and Shopify, automating your workflow.

Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023

G2 Badge - Most Implementable - Winter 2024

G2 Badge - Leader Mid-Market - Winter 2024

93%

Customers who say using Zapier has made them better at their job

25m

Customers have created over 25 million Zaps on the platform

6 mins

The average user takes less than 6 minutes to set up a Zap

Make work flow with AI

Level up your Microsoft Office 365 to Shopify integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.

Learn about AI automation

Illustration of AI enhancing Zapier workflows with automation and app integrations.

Frequently Asked Questions about Microsoft Office 365 + Shopify integrations

New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Microsoft Office 365 and Shopify

How do I set up the integration between Microsoft Office 365 and Shopify?

To set up the integration, you need to use our platform to create a zap that connects Microsoft Office 365 and Shopify. Start by choosing a trigger event in Shopify, for example, a new order being placed. Then select the action you want Office 365 to perform in response, such as sending an email notification via Outlook.

Can I automatically update inventory in Shopify when a change is made in Office 365?

Yes, it is possible to automate inventory updates by setting up triggers and actions. For instance, when a specific Excel worksheet in your Office 365 updates with new stock levels, you can trigger an update to your product inventory in Shopify using our zap configuration.

Is it possible to synchronize customer information from Shopify to Microsoft Outlook contacts?

Absolutely! You can synchronize customer data by configuring a zap where any new customer added on Shopify automatically creates or updates contact information in Microsoft Outlook. This helps maintain up-to-date records without manual data entry.

What Microsoft Office 365 actions can be triggered from Shopify events?

You can trigger several actions within Microsoft Office 365 from Shopify events. Common actions include sending an email through Outlook when a new transaction occurs, creating a calendar event for marketing follow-ups when high-value orders come through, or adding rows to Excel sheets every time a sale is finalized.

How do I ensure data security while integrating Microsoft Office 365 with Shopify?

We prioritize data security by utilizing encrypted connections for data transfers between platforms. It’s also crucial for users to set appropriate permissions within both their Microsoft and Shopify accounts to limit exposure of sensitive information.

Can emails be sent via Outlook for every abandoned cart in Shopify?

Yes, by setting an abandoned cart on Shopify as the trigger event, you can configure Outlook within Microsoft Office 365 as the action application to send targeted reminder emails automatically without manual intervention.

Are there pre-made templates available for common integrations between these two platforms?

Yes, we offer pre-built templates that facilitate quick setup of common zaps such as syncing contacts or automated order management tasks. Users can customize these templates further based on specific business needs.

Practical ways you can use Microsoft Office 365 and Shopify

Revenue forecasting automation

Set up an automated workflow to analyze historical data, consider current trends, and generate real-time revenue forecasts for strategic planning.

Business Owner

Try it

System performance monitoring

An automation workflow that regularly checks system performance metrics and sends alerts when thresholds are breached, ensuring network and system stability.

Try it

Social media scheduling

Create an automation workflow to schedule and post social media content across platforms and track engagement metrics automatically.

Marketing & Marketing Ops

Try it

Supported triggers and actions

Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.

triggers, actions, or triggers and actions

- Calendar
- Time Before
  Required
- Time Before (Unit)
  Required
Trigger
Polling
Try It
- Calendar
Trigger
Polling
Try It
- Shared Inbox
Trigger
Polling
Try It
New Flagged Email
Triggers when a new email is flagged.
Trigger
Polling
Try It
- Calendar
Trigger
Polling
Try It
- Contact Folder
- First Name
  Required
- Last Name
- EmailAddresses
- BusinessPhones
- HomePhones
- MobilePhone
- JobTitle
- CompanyName
- Department
- Business Website URL
- FileAs
- PersonalNotes
- Street
- City
- State
- Postal Code
- Country or Region
- Street
- City
- State
- Postal Code
- Country or Region
- Street
- City
- State
- Postal Code
- Country or Region
Action
Write
- Event
  Required
Action
Write
- Contact Folder
- Contact
  Required
- First Name
  Required
- Last Name
- EmailAddresses
- BusinessPhones
- HomePhones
- MobilePhone
- JobTitle
- CompanyName
- Department
- Business Website URL
- PersonalNotes
- Street
- City
- State
- Postal Code
- Country or Region
- Street
- City
- State
- Postal Code
- Country or Region
- Street
- City
- State
- Postal Code
- Country or Region
Action
Write
- Contact Folder
- First Name
  Required
- Last Name
- EmailAddresses
Action
Search
New Blog
Triggers when a new blog is added to your Shopify store.
Trigger
Polling
Try It
New Customer
Triggers when a new customer is added to your Shopify account.
Trigger
Polling
Try It
- Risk Level
Trigger
Polling
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 Product
Triggers when a product is created.
Trigger
Instant
Try It
Updated Customer
Triggers when a customer's information is updated.
Trigger
Instant
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
- Order ID
  Required
- Type of Line Item to Add
  Required
- Reason for Edit
- Notify the Customer?
Action
Write
- Blog
  Required
- Title
  Required
- Author Name
  Required
- Content
  Required
- Featured Image URL
- Excerpt/Summary
- Tags
  Required
- Is Published?
Action
Write
- Product ID
  Required
- 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
- Contact Email
- Product
  Required
- Product Variant
- Product Quantity
- Title
  Required
- Price
- Weight in Grams
- A note about the company
- Discount - Type
- Discount - Amount
- Discount - Code
- Additional Details
- Tags
  Required
- 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
- Initial Value
  Required
- Code
- Customer ID
- Expiry Date
- A note about the company
- Template Suffix
Action
Write
- Contact Email
- Product
  Required
- Product Variant
- SKU (Stock Keeping Unit)
- Product Quantity
- Title
  Required
- Price
- Weight in Grams
- Price
- Rate
- Title
- A note about the company
- Discount - Type
- Discount - Amount
- Discount - Code
- Additional Details
- Tags
  Required
- 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
  Required
- Inventory_behaviour
- Financial_status
- Fulfillment Status
- Code
- Title
- Price
- Discounted Price
- Source
Action
Write
- Product
  Required
- Channel ID
  Required
- Publish Date
Action
Write
- Order ID
  Required
- Amount
- Currency
- Type
- Parent Transaction
- Warning
- Gateway
Action
Write
- Product Variant
  Required
- Unit Cost
- Track Inventory
- SKU (Stock Keeping Unit)
- Requires Shipping
- Country of Origin
- Province/State of Origin
Action
Write
- Product
  Required
- Product Variant
- Price
- Compare at Price
- SKU (Stock Keeping Unit)
- Barcode (ISBN, UPC, GTIN, etc.)
- Tax Code
- Charge Tax On This Variant?
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Description
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
- Order ID
  Required
Action
Search
- Order ID
  Required
Action
Search
- Product Titles
  Required
Action
Search
- Product Titles
  Required
Action
Search
- Product ID
  Required
- Title
  Required
Action
Search
- Copy
- Title
  Required
- Product_type
  Required
- Vendor
  Required
- Payment Status
- Product Description
- Tags
  Required
- Collection ID
- Handle
- A note about the company
- 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
Search or write

- Parent Folder
  Required
- Child Folder
Trigger
Polling
Try It
- Contact Folder
Trigger
Polling
Try It
- Parent Folder
  Required
- Child Folder
- Search terms
  Required
- Note
Trigger
Polling
Try It
- Parent Folder
  Required
- Child Folder
Trigger
Polling
Try It
- Calendar
- Subject
  Required
- Start Date & Time
  Required
- End Date & Time
  Required
- All Day Event?
- Description
- Show me as Free or Busy
- Attendees
- Categories
- Location
Action
Write
- To Email(s)
  Required
- CC Email(s)
- BCC Email(s)
- Subject
  Required
- Body Format
  Required
- Description
- Attachment
- Action for Files Larger Than 150MB
Action
Write
- From Email
- To Email(s)
  Required
- CC Email(s)
- BCC Email(s)
- Subject
  Required
- Body Format
  Required
- Description
- Attachment
- Action for Files Larger Than 150MB
Action
Write
- Calendar
- Search Term
  Required
- Start Date & Time
  Required
- End Date & Time
  Required
Action
Search
- Contact Folder
- First Name
  Required
- Last Name
- EmailAddresses
- BusinessPhones
- HomePhones
- MobilePhone
- JobTitle
- CompanyName
- Department
- Business Website URL
- FileAs
- PersonalNotes
- Street
- City
- State
- Postal Code
- Country or Region
- Street
- City
- State
- Postal Code
- Country or Region
- Street
- City
- State
- Postal Code
- Country or Region
Action
Search or write
- Blog
  Required
- Blog Entry Status
Trigger
Polling
Try It
Customer Account Enabled
Triggers when a customer account is enabled.
Trigger
Instant
Try It
- Abandoned Cart Age (Hours)
  Required
Trigger
Polling
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 Refund
Triggers when a refund or partial refund occurs.
Trigger
Instant
Try It
New Tag Added to Customer
Triggers when a new tag is added to a customer.
Trigger
Polling
Try It
Updated Draft Order
Triggers when a draft order is updated.
Trigger
Instant
Try It
Updated Order
Triggers when an order is updated (with line item support).
Trigger
Instant
Try It
Updated Tag in Order
Triggers when a tag has either been added or removed from an order.
Trigger
Instant
Try It
- Customer
  Required
- Tags
  Required
- Overwrite existing tags?
Action
Write
- Name
  Required
- ExternalId
- A note about the company
- Company_contact
- Contact Email
- Contact First Name
- Contact Last Name
- Contact Phone
- Title
  Required
- Contact_locale
- Location
- Billing same as shipping address?
- Company_shippingAddress
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address Country Code
- Shipping_firstName
- Shipping_lastName
- Shipping Address Phone
- Shipping Address Recipient
- Shipping Address Zip
- Shipping Address Zone Code
- Location External ID
- Location_locale
- Location_name
- Location_note
- Location_phone
- TaxRegistrationId
Action
Write
- First Name
- Last Name
- Contact Email
- Customer Phone
- Company Name
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Contact Phone
- Tags
  Required
- A note about the company
- Accepts Marketing
- Tax Exempt
- Tax Exemptions
- Send E-Mail Invite
Action
Write
- Order ID
  Required
- Fulfillment Order ID
  Required
- Notify Customer
- Address Line 1
- Street Address Line 2
- City
- Country Code
- State/Province Code
- Zip Code
- Tracking Company
- Tracking Number
- Tracking URL
Action
Write
- Adjust or Set quantity?
  Required
- Name
  Required
- The reason for the quantity changes
  Required
- Location
  Required
- Product
  Required
- Product Variant
  Required
- Product Quantity
Action
Write
- Title
  Required
- Product_type
  Required
- Vendor
  Required
- Payment Status
- Product Description
- Tags
  Required
- Collection ID
- Handle
- A note about the company
- 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
- Customer
  Required
- Tags
  Required
Action
Write
- Customer ID
- First Name
- Last Name
- Contact Email
- Company Name
- Default Address
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Tags
  Required
- Contact Phone
- A note about the company
- Tax Exempt
- Tax Exemptions
- Accepts Marketing
- Send Account Invite Email
Action
Write
- Order ID
  Required
- Contact Email
- A note about the company
- Contact Phone
- Buyer Accepts Marketing?
- Remove Customer from Order?
- Tags
  Required
- Additional Details
- Shipping Address - Address
- Shipping Address - Address con't
- 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 - State/Province/Region
- Shipping Address - State/Province/Region Code
- Shipping Address - Postal/Zip code
Action
Write
- Product
  Required
- Title
  Required
- Product_type
  Required
- Vendor
  Required
- Payment Status
- Product Description
- Tags
  Required
- Category
- Collections to Join
- Collections to Leave
- Handle
- Redirect Handle?
- Alt Text
- Media Content Type
- Original Source
Action
Write
- Name
  Required
- Contact Email
Action
Search
- Order ID
  Required
- Include Closed Fulfillment Orders
Action
Search
- Owner_resource
  Required
- Owner_id
  Required
Action
Search
- Ids
  Required
Action
Search
- Copy
- Title
  Required
Action
Search
- SKU (Stock Keeping Unit)
Action
Search
- Name
  Required
- Contact Email
- First Name
- Last Name
- Customer Phone
- Company Name
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Contact Phone
- Tags
  Required
- A note about the company
- Accepts Marketing
- Tax Exempt
- Tax Exemptions
- Send E-Mail Invite
Action
Search or write
- Product ID
  Required
- Title
  Required
- 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
Search or write

Learn how to automate Microsoft Office 365 on the Zapier blog

Learn how to automate Shopify on the Zapier blog

About Microsoft Office 365

Microsoft Office 365 Business is a complete office suite in the cloud. It provides all the standard office products like Excel, Outlook, Word, SharePoint and more, but available from any internet enabled computer! Zapier does not currently support Outlook.com addresses or Home 365 accounts, only business or Enterprise.

Learn moreLearn moreHelpHelp

Related categories

Email Microsoft

Similar apps

Email by Zapier

Email, Zapier

Google Docs

Documents, Google

Gmail

Email, Google

About Shopify

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

Learn moreLearn moreHelpHelp

Related categories

eCommerce

Connect Microsoft Office 365 to Shopify on the world's largest no-code automation platform

Explore Microsoft Office 365 + Shopify Integrations

excel

Explore Microsoft Office 365 + Shopify Integrations

excel

Connect Microsoft Office 365 and Shopify to unlock the power of automation

Top companies trust Zapier to automate work that solves their unique business problems—no coding required.

Set up your first integration

Update contacts in Microsoft Office 365 when customers are updated in Shopify

Update contacts in Microsoft Office 365 when customers are updated in Shopify

How Zapier works

Choose a trigger

Add your action

You’re connected!

Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023

Make work flow with AI

Frequently Asked Questions about Microsoft Office 365 + Shopify integrations

Practical ways you can use Microsoft Office 365 and Shopify

Revenue forecasting automation

System performance monitoring

Social media scheduling

Supported triggers and actions

Learn how to automate Microsoft Office 365 on the Zapier blog

6 ways to automate Microsoft Office 365

Learn how to automate Shopify on the Zapier blog

Automatically post new Shopify store items to Pinterest

How to automatically add Shopify customers to Salesforce

How to automatically save Shopify orders to a Google Sheet

Connect Microsoft Office 365 to Shopify on the world's largest no-code automation platform

Explore Microsoft Office 365 + Shopify Integrations

Explore Microsoft Office 365 + Shopify Integrations