■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)
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Information
Get Sheet Names
Repeat Formula
Input Values into Range
Embed Image in Cell
Sort by Specific Column
Hide Sheet
Add Note to Specified Cell
When a row is added
When a row is updated
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Information
Get Sheet Names
Repeat Formula
Input Values into Range
Embed Image in Cell
Sort by Specific Column
Hide Sheet
Add Note to Specified Cell
Add Column
Delete 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 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