■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
Retrieve Companies
Create Unsettled Deal
Create Settled Deal
Retrieve Wallet Accounts
Retrieve Unsettled Deal IDs
List IDs of Unpaid Transactions Past Due Date
Get Transaction
Record Payment for Transaction
List Invoices
Get Invoice Details
Get Estimate List
Get Estimate Details
Create Partner
Search Partners
Get Partner Details
Update partner (Basic information)
Update partner (Bank account information)
Get account item list
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)
Retrieve Companies
Create Unsettled Deal
Create Settled Deal
Retrieve Wallet Accounts
Retrieve Unsettled Deal IDs
List IDs of Unpaid Transactions Past Due Date
Get Transaction
Record Payment for Transaction
List Invoices
Get Invoice Details
Get Estimate List
Get Estimate Details
Create Partner
Search Partners
Get Partner Details
Update partner (Basic information)
Update partner (Bank account information)
Get account item list
Upload receipt files to File Box
Get bank transaction list
List Approval Requests
Get Approval Request Details
Search Approval Requests
Create Journal Entry
Create Approval Request
List Departments
Create Unsettled Deal (Multiple Line Items)
Create Settled Deal (Multiple Line Items)
Create Payment Request
List Payment Requests
Search payment requests
Get a specific payment request
Update File Box receipt file information
Get a list of approval routes
Get a list of approval request forms
Get Approval Request Form Info
Download Receipt File from File Box
Update Approval Request
Update transaction
Create Expense Request
Get expense request list
Search expense requests
Get details of a specific expense request
Delete deal
Get Profit and Loss Statement
Get Balance Sheet
Retrieve Manufacturing Cost Report
Retrieve Manufacturing Cost Report (Year-on-Year Comparison)
Retrieve Manufacturing Cost Report (Department Comparison)
Approval actions for requests
取引を検索
Get list of users in the company
Create Invoice
Get company tax codes
Create deal line items
List items
List tags
List segment tags
Update deal line items
List Deals
Update Deal Payment Line
Search Account Transactions
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