■Overview
This is a flow to register customer information in Shopify when a row is updated in Google Sheets.
■Recommended for
1. Those who utilize Google Sheets for business
・Project teams that accumulate information in shared sheets
・Team leaders who want to edit sheets simultaneously and always share the latest information
2. Those who conduct business using Shopify
・Retailers operating shops on Shopify
・Managers in charge of overseeing inventory levels and other details
■Benefits of using this template
Google Sheets is a tool suitable for sharing information within a team because edits are immediately reflected.
However, manually reflecting those edits in Shopify can hinder business efficiency.
This flow is suitable for those who want to promote business efficiency within their team.
By updating Shopify's customer information using the data edited in Google Sheets, it eliminates manual work and enhances efficiency.
■Notes
・Please integrate both Google Sheets and Shopify with Yoom.
・Shopify is an app available only on the Team Plan and Success Plan. For Free Plan and Mini Plan users, the operations and data connections set in the flow bot will result in errors, so please be cautious.
・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 usually restricted.


When a row is added
When a row is updated
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)
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get sheet names
Apply a formula to a range
Write values to a range
Insert image into a cell
Sort by a specific column
Hide a sheet
Add a note to the specified cells
When a row is added
When a row is updated
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get sheet names
Apply a formula to a range
Write values to a range
Insert image into a cell
Sort by a specific column
Hide a sheet
Add a note to the specified cells
Insert columns
Delete columns
Write values to multiple columns
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 Quantity
Get Inventory Locations
Update Inventory Quantity
Add product
Search Orders
Get Order Details
Get Product Variant
Get Customer
Create Customer
Update Customer
Delete Customer
Add Custom Collection
Add/Update Metafield Value
Update Product
Update Order
Search Customers
Create Order
Download product image
Get product
Get orders (date range)
Add product variant
Get fulfillment orders
Create fulfillment
Update Fulfillment
Create Order (specify line items as a list)
Update Product Tags
List Customer Metafields
Create Fulfillment (products)
Create blog article
Update blog article
Get articles for the specified blog
Search articles
List blogs