■Overview
This is a flow to register customers on the board when a row is added to a Google Spreadsheet.
■Recommended for
1. Those who manage customers using Google Spreadsheets
・Sales department personnel who input customer information
・Those who want to streamline by integrating Google Spreadsheets with the board
2. Those who use the board for administrative tasks
・Those responsible for daily customer registration on the board
・Those who want to streamline the process of customer registration on the board
■Benefits of using this template
Google Spreadsheets are suitable tools for information management.
However, manually registering customer information added to Google Spreadsheets on the board is time-consuming and labor-intensive.
This template allows automatic addition to the board when customer information is added to Google Spreadsheets.
This enables speedy management of customer information on the board, improving work speed and efficiency.
Additionally, even if different tools are used across departments, it facilitates smooth information sharing, allowing for seamless workflow progression.
■Notes
・Please integrate both Google Spreadsheets and the board with Yoom.
・Refer here for the method to integrate with the board's My Apps.
・Triggers can be set to activate at intervals of 5, 10, 15, 30, or 60 minutes.
・Please note that the shortest activation interval varies depending on the plan.


When a customer is created or updated
When a new project is created
When a project is created or updated
When a project is created or updated (including lost)
When a row is added
When a row is updated
Register Customer
Get Customer
Get Customer List (Search by Tag)
Register Project (Lump-Sum Billing)
Create Project (Recurring billing)
Get Project List
Get Project Details
[Deprecated] Update Project Status
Get Billing List
Change Billing Status
Update Invoice
Get Invoice ID for a Specific Project
Get Invoice
Update Projects (Batch Invoicing)
Update Project (Recurring billing)
Delete Project
Change Order Status
Lock Project
When a customer is created or updated
When a new project is created
When a project is created or updated
When a project is created or updated (including lost)
Register Customer
Get Customer
Get Customer List (Search by Tag)
Register Project (Lump-Sum Billing)
Create Project (Recurring billing)
Get Project List
Get Project Details
[Deprecated] Update Project Status
Get Billing List
Change Billing Status
Update Invoice
Get Invoice ID for a Specific Project
Get Invoice
Update Projects (Batch Invoicing)
Update Project (Recurring billing)
Delete Project
Change Order Status
Lock Project
Register Vendor
Retrieve Quotation
Update Quotation
Update Invoice (specify line items as comma-separated)
Update Quotation (specify line items as comma-separated)
Retrieve Delivery Note
Update Delivery Note
Update Delivery Note (specify line items as comma-separated)
Get Invoice List (by Order Status)
Create Purchase Order (One-time Payment)
Create Purchase Order (Recurring Payments)
Create Purchase Order (Installments)
Update Customer
Get Quotation ID for a Specific Project
Get Purchase Orders
Get Suppliers
Get Vendor
Delete Vendor
Update Vendor
Update Acceptance
Update Purchase Order
Retrieve Customer Branches
Retrieve Customer Branch
Create Project (Split billing)
Update Project (Split Billing)
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