■Overview
This is a flow to register a billing destination in the billing management robot when a row is added to a Google Spreadsheet.
■Recommended for
1. Those who use Google Spreadsheets to manage billing information
・Those responsible for adding billing destinations in back-office operations
・Those who want to automatically link billing information to the billing management robot
2. Those who utilize the billing management robot in their operations
・Those who use the billing management robot for invoice issuance operations
・Those who manually enter billing information
■Benefits of using this template
Managing billing information in Google Spreadsheets and transferring the information to other tools can be cumbersome.
Additionally, manual data transfer increases the risk of errors.
This template allows you to automatically register billing destinations in the billing management robot when they are added to Google Spreadsheets.
By automating the registration to the billing management robot, the risk of input errors is reduced, and work time can be shortened.
Furthermore, since the information is synchronized between tools, the invoice issuance process can proceed smoothly.
■Notes
・Please link both Google Spreadsheets and the billing management robot 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
Register/Update Billing Information
Register Payment Information (Bank Transfer)
Register Payment Information (Credit Card)
Register Payment Information (Bank Check)
Register Payment Information (RP Account Transfer)
Register Billing Information (One-time)
Register Billing Information (Fixed Subscription)
Register Billing Information (Metered Subscription)
Issue Invoice
Send Invoice via Email
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace Values
Register/Update Billing Information
Register Payment Information (Bank Transfer)
Register Payment Information (Credit Card)
Register Payment Information (Bank Check)
Register Payment Information (RP Account Transfer)
Register Billing Information (One-time)
Register Billing Information (Fixed Subscription)
Register Billing Information (Metered Subscription)
Issue Invoice
Send Invoice via Email
When a row is added
When a row is updated
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get sheet names
Apply a formula to a range
Write values to a range
Insert image into a cell
Sort by a specific column
Hide a sheet
Add a note to the specified cells
Insert columns
Delete columns
Write values to multiple columns