■Overview
This is a flow to register a customer in Money Forward Kakebarai when a row is added to a Google Spreadsheet.
■Recommended for
1. Those who use Google Spreadsheets for work
・Those who utilize Google Spreadsheets for managing customer information
・Teams that share Google Spreadsheets to proceed with work
2. Those who use Money Forward Kakebarai for work
・Those in charge of billing operations
・Those who manually add customer information from Google Spreadsheets to Money Forward Kakebarai
■Benefits of using this template
Google Spreadsheets is a tool suitable for team work as it allows data management and editing online.
However, if you are manually linking Google Spreadsheet data to Money Forward Kakebarai for customer registration each time, you might find it cumbersome.
This template automates the registration of customer information in Money Forward Kakebarai when customer information is added to a Google Spreadsheet, thus streamlining data integration between tools.
It eliminates the need to add customer information to both Google Spreadsheets and Money Forward Kakebarai, maintaining data consistency between tools.
■Notes
・Please link both Google Spreadsheets and Money Forward Kakebarai 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 a row is added
When a row is updated
When Credit Examination is Completed
When Transaction Examination is Completed
When Invoice Issuing is Completed
When Customer Name Change Request is Completed
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 Credit Examination is Completed
When Transaction Examination is Completed
When Invoice Issuing is Completed
When Customer Name Change Request is Completed
Customer Registration
Retrieve Customer Information
Update Customer Information
Assign Transfer Account
Request Direct Debit
Register Transaction
Retrieve Transaction Information
Retrieve Invoice List
Update Billing Destination
Register Billing Address
Retrieve Billing Information
Retrieve Billing Address
Retrieve Invoice List (Supporting Invoice System)