■Overview
This is a flow for registering customer information in Shopify when a row is added in Google Sheets.
■Recommended for
1. Those who use Google Sheets for business
・Office workers who perform tasks on shared sheets
・Team leaders managing data edited in real-time by multiple people
2. Those who conduct business using Shopify
・Retailers operating online shops
・Members of the department managing customer information
■Benefits of using this template
Google Sheets is a tool suitable for information sharing because the added content is immediately reflected.
However, manually entering this information into Shopify can cause delays in information sharing.
This flow is effective for those who want to share information smoothly.
By registering customer information in Shopify based on the information added to Google Sheets, you can eliminate manual work and maintain information accuracy.
■Notes
・Please integrate both Google Sheets and Shopify with Yoom.
・Shopify is an app available only with 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 two-week free trial. During the free trial, you can use apps that are subject to restrictions.


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