■Overview
This is a flow that adds a record to Microsoft Excel when an order is placed on Shopify.
■Recommended for
1. Shopify Store Owners
・Those who want to manage and analyze Shopify order information in Excel
・Those who want to eliminate manual order information entry and improve operational efficiency
・Those who conduct sales analysis and customer management in Microsoft Excel and want to integrate Shopify order information
2. E-commerce Site Managers
・Those who want to automatically import Shopify order information into Excel for custom analysis and report creation
・Those who want to incorporate Shopify order information into workflows built in Microsoft Excel for seamless business integration
・Those who want to automatically import Shopify order information even in Excel environments where integration with other systems is difficult
■Benefits of Using This Template
・Centralizing product information in Shopify makes it easier to manage inventory and understand sales status.
・Automatically adding order information generated in Shopify to Excel reduces manual entry errors and time loss.
■Notes
・Please integrate both Shopify and Microsoft Excel with Yoom.
・Shopify is an app available only on the Team Plan and Success Plan. If you are on the Free Plan or Mini Plan, the operations and data connections set in the flow bot will result in errors, so please be careful.
・Paid plans such as the Team Plan and Success Plan offer a 2-week free trial. During the free trial, you can use apps that are subject to restrictions.
・Microsoft365 (formerly Office365) has a Home Plan and a General Business Plan (Microsoft365 Business), and if you are not subscribed to the General Business Plan, authentication may fail.


When an order is created
When order information is updated (Webhook)
When an order is shipped (Webhook)
When an order is paid (Webhook)
When an order is deleted (Webhook)
When Product Information is Created (Webhook)
When Product Information is Updated (Webhook)
When Product Information is Deleted (Webhook)
When Order Information is Created (Webhook)
When Customer Information is Created (Webhook)
When Customer Information is Updated (Webhook)
When Inventory Item Information is Created (Webhook)
When Inventory Item Information is Updated (Webhook)
When Inventory Level is Updated (Webhook)
When Product Information is Created/Updated (Webhook)
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add Sheet
Change Sheet Name
Retrieve Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Get Item ID
Delete Sheet
Sort a specified range in ascending or descending order
Unprotect Worksheet
Get Drive Item ID from Sharing URL
Create Excel Session
Search products
Get inventory quantities
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add Sheet
Change Sheet Name
Retrieve Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Get Item ID
Delete Sheet
Sort a specified range in ascending or descending order
Unprotect Worksheet
Get Drive Item ID from Sharing URL
Create Excel Session
When an order is created
When order information is updated (Webhook)
When an order is shipped (Webhook)
When an order is paid (Webhook)
When an order is deleted (Webhook)
When Product Information is Created (Webhook)
When Product Information is Updated (Webhook)
When Product Information is Deleted (Webhook)
When Order Information is Created (Webhook)
When Customer Information is Created (Webhook)
When Customer Information is Updated (Webhook)
When Inventory Item Information is Created (Webhook)
When Inventory Item Information is Updated (Webhook)
When Inventory Level is Updated (Webhook)
When Product Information is Created/Updated (Webhook)
Search products
Get inventory quantities
Get inventory locations
Update inventory quantity
Add product
Search Orders
Get Order
Get Product Variant
Get Customer
Create Customer
Update Customer
Delete Customer
Create Custom Collection
Create or Update Metafield Value
Update Product
Update order information
Search customers
Create order
Download product image
Get product
List orders (date range)
Add product variant
Get fulfillment orders
Create fulfillment
Update fulfillment
Create order (specify line items as a list)
Update product tags
Get customer metafields
Create fulfillment (product)
Create blog article
Update blog article