■Overview
This is a flow to register customer information in ecforce when a row is added to a Google Spreadsheet.
■Recommended for
1. Those who use Google Spreadsheets for business
・Office workers who manage tasks using shared sheets
・Team leaders who want to edit the same sheet simultaneously
2. Those who manage using ecforce
・Personnel responsible for building and operating e-commerce sites
・Those in charge of managing and analyzing sales-related data
■Benefits of using this template
Google Spreadsheets are an effective tool for consolidating information within a team.
However, manually entering information added to Google Spreadsheets into ecforce can burden employees and potentially worsen their work-life balance.
This flow is suitable for those who want to minimize the hassle of manual entry.
By inputting information into ecforce based on the additions to Google Spreadsheets, you can reduce manual entry efforts and register accurate data.
■Notes
・Please integrate both Google Spreadsheets and ecforce with Yoom.
・ecforce 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 aware.
・Paid plans such as the Team Plan and Success Plan offer a 2-week free trial. During the free trial, you can use the apps that are subject to restrictions.


When an order is created
When a subscription order is created
When a product is created
When a customer is updated
When an order is confirmed
When an order is shipped
When an order is delivered
When an order is canceled
When a subscription order becomes active
When a subscription order is suspended
When a subscription order is canceled (terminated)
When the customer status changes to Member
When a row is added
When a row is updated
Ad Summary Search
Create Customer
Update Customer
Get Customer
Update Inventory
Search Inventory
Add Product to Subscription Order
Get Product Information
Update Order
Get Order Details
Search Order IDs (Filter by Order Date)
Get Subscription Order Details
Search Subscription Order IDs (Filter by Order Date)
Get Ad URL Details
Get Ad URL ID List by Ad URL Group ID
Search customers (Email address / Customer number)
Search products
Get payment methods
When an order is created
When a subscription order is created
When a product is created
When a customer is updated
When an order is confirmed
When an order is shipped
When an order is delivered
When an order is canceled
When a subscription order becomes active
When a subscription order is suspended
When a subscription order is canceled (terminated)
When the customer status changes to Member
Ad Summary Search
Create Customer
Update Customer
Get Customer
Update Inventory
Search Inventory
Add Product to Subscription Order
Get Product Information
Update Order
Get Order Details
Search Order IDs (Filter by Order Date)
Get Subscription Order Details
Search Subscription Order IDs (Filter by Order Date)
Get Ad URL Details
Get Ad URL ID List by Ad URL Group ID
Search customers (Email address / Customer number)
Search products
Get payment methods
Bulk update customers
Update set items for a subscription order
Update a recurring order item
Bulk add order items
Search labels
Bulk label operations
Search customers (by query)
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