■Overview
This is a flow that adds ticket information to Google Sheets when a ticket is created in Chat Plus.
With Yoom, you can easily achieve this flow without any programming, as it allows for integration between applications.
■Recommended for
1. Those who use Chat Plus for business
・Those who handle customer or internal inquiries using Chat Plus
・Those who want to eliminate the hassle of manually transferring data
2. Those who use Google Sheets for business
・Those who manage ticket information with Google Sheets
・Those who want to expedite follow-ups and analysis of inquiries
■Benefits of using this template
When handling customer or internal inquiries with Chat Plus, manually registering information into a database when ticketing cases that are difficult to respond to immediately is inefficient.
By utilizing this template, ticket information can be automatically reflected in Google Sheets, making it easier to grasp new tickets and perform data analysis smoothly. It also helps prevent transcription errors and omissions.
■Notes
・Please integrate both Chat Plus and Google Sheets with Yoom.
・For instructions on setting triggers in Chat Plus, please refer to here.


When a chat is received
When a chat is started
When a chat is ended
When a ticket is created
When a ticket is updated
When a row is added
When a row is updated
Retrieve Visitor Information
Send Message
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
When a chat is received
When a chat is started
When a chat is ended
When a ticket is created
When a ticket is updated
Retrieve Visitor Information
Send Message
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