■Overview
This is a flow to register a client in Misoca when a row is added to a Google Spreadsheet.
■Recommended for
1. Those who use Google Spreadsheets for management tasks
・Sales teams utilizing Google Spreadsheets for client registration
・Team members using Google Spreadsheets for collaborative editing
2. Those responsible for billing tasks in Misoca
・Accountants manually registering clients
・Those who want to automate client registration in Misoca
■Benefits of using this template
If you manage clients with both Google Spreadsheets and Misoca, you might find manual registration tasks cumbersome.
Additionally, manual registration tasks can lead to human errors such as incorrect entries or omissions.
This template allows for automatic registration in Misoca when a client is registered in Google Spreadsheets.
Since client registration in Misoca is automated, manual tasks are reduced, enabling more efficient operations.
Even when dealing with many clients, maintaining data consistency between both tools allows for accurate task execution.
■Notes
・Please integrate both Google Spreadsheets and Misoca with Yoom.
・You can select the trigger interval from 5, 10, 15, 30, or 60 minutes.
・Please note that the shortest trigger interval varies depending on the plan.


When a row is added
When a row is updated
When an invoice is newly created
When a quotation is newly created
When a quotation is created or updated
When an invoice is created or updated
When an invoice is updated (trigger only if billed status)
When a new delivery note is created
When a delivery note is created or updated
When a delivery note is updated (triggered only if issued status)
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 invoice is newly created
When a quotation is newly created
When a quotation is created or updated
When an invoice is created or updated
When an invoice is updated (trigger only if billed status)
When a new delivery note is created
When a delivery note is created or updated
When a delivery note is updated (triggered only if issued status)
Create Recipient
Create Quote
Create Invoice
Request Postal Mailing for Invoice
Download Invoice PDF
Get Estimate PDF
Create Client
Retrieve Customer Information
Retrieve Recipient Information
Send Estimate by Email
Get Recipient IDs Linked to a Specific Customer
Create Invoice (specify line items as a list)
Create Estimate (specify line items as a list)
Get Delivery Note PDF
Get Customer List