■Overview
This is a flow to register a client in freee Accounting when a row is added to a Google Spreadsheet.
■Recommended for
1. Those who manage client information using Google Spreadsheets
・Back office staff responsible for adding client information
・Sales representatives managing customer lists
2. Those who use freee Accounting in their work
・Those who manually register clients in freee Accounting
・Those who want to streamline their work by integrating Google Spreadsheets with freee Accounting
■Benefits of using this template
Google Spreadsheets is a useful tool for data management and is suitable for collaborative editing.
However, when registering clients added to Google Spreadsheets in freee Accounting, there is a possibility of errors such as incorrect entries or omissions.
This template is suitable for those who want to automate the registration of clients in freee Accounting.
When a client is added in Google Spreadsheets, it is automatically registered in freee Accounting, allowing for more efficient manual work.
Additionally, maintaining data consistency between tools ensures that you can always check the latest information and proceed with your work quickly.
■Notes
・Please integrate both Google Spreadsheets and freee Accounting with Yoom.
・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
・Please note that the shortest trigger interval varies depending on the plan.


When an expense application, various applications, or payment request is created or updated
When expense claims, various requests, and payment requests are approved
When an expense application is created or updated (webhook)
When various applications are created or updated (webhook)
When a payment request is created or updated (webhook)
When a row is added
When a row is updated
Get Company List
Create Unsettled Deal
Create Settled Deal
Retrieve Wallet Accounts
Get Unsettled Deal IDs
Get Overdue Unsettled Deal IDs
Retrieve Deal
Create Deal Payment (Record Settlement)
List Invoices
Get Invoice Details
List Estimates
Get Estimate Details
Create Partner
Search Partners
Get Partner Details
Update Partner (Basic Info)
Update Partner (Bank Account Information)
Retrieve Account Items
When an expense application, various applications, or payment request is created or updated
When expense claims, various requests, and payment requests are approved
When an expense application is created or updated (webhook)
When various applications are created or updated (webhook)
When a payment request is created or updated (webhook)
Get Company List
Create Unsettled Deal
Create Settled Deal
Retrieve Wallet Accounts
Get Unsettled Deal IDs
Get Overdue Unsettled Deal IDs
Retrieve Deal
Create Deal Payment (Record Settlement)
List Invoices
Get Invoice Details
List Estimates
Get Estimate Details
Create Partner
Search Partners
Get Partner Details
Update Partner (Basic Info)
Update Partner (Bank Account Information)
Retrieve Account Items
Upload Supporting Documents to File Box
Retrieve Statement Lines
List Approval Requests
Retrieve Specific Request Information
Search Requests
Create Journal Entry
Create Request
Get Department List
Register Unsettled Transaction (multiple line items)
Register a settled transaction (multiple line items)
Create a payment request
Get payment request list
Search payment requests
Get a specific payment request
Update File Box receipt file information
Get list of approval routes
Get list of General Request forms
Get General Request form details
Download receipt file from File Box
Update a General Request
Update deal
Create expense application
List expense applications
Search expense applications
Get details of a specific expense application
Delete Transaction
Retrieve Profit and Loss Statement
Retrieve Balance Sheet
Retrieve Manufacturing Cost Report
Retrieve Manufacturing Cost Report (Year-over-Year Comparison)
Get Manufacturing Cost Report (Department Comparison)
Approval actions for requests
Search transactions
Get users in company
Create invoice
Get company tax codes
Create deal line items
Get item list
Get memo tag list
Get segment tag list
Update transaction line items
List transactions
Update transaction payment line
Search account statements
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