■Overview
This flow adds a new ticket created in Zendesk to a Microsoft Excel database.
■Recommended for
1. Customer support teams using Zendesk
・Those who want to reduce the effort of manually syncing ticket information between Zendesk and Microsoft Excel
・Those who want to always check the latest ticket information in Microsoft Excel
2. Those who work based on Zendesk ticket information
・Those who want to import ticket information into Microsoft Excel for detailed analysis
■Benefits of using this template
While Zendesk is a tool that streamlines customer support operations, manually transferring tickets to a Microsoft Excel database is burdensome for support staff and poses risks of errors and information leaks.
By implementing this flow, ticket information is automatically added to the Microsoft Excel database whenever a new ticket is created in Zendesk. This frees support staff from manual data entry, allowing them to focus on more important tasks such as customer support.
■Notes
・Please connect both Zendesk and Microsoft Excel with Yoom.
・Zendesk is an app available only with the Team Plan and Success Plan. If you are on the Free Plan or Mini Plan, the operations and data connections set in the flow bot will result in errors, so please be aware.
・Paid plans such as the Team Plan and Success Plan offer a 2-week free trial. During the free trial, you can use apps that are normally restricted.
・Microsoft365 (formerly Office365) has both a Home Plan and a Business Plan (Microsoft365 Business). If you are not subscribed to the Business Plan, authentication may fail.


When a new ticket is created
When a ticket is updated
When a user is created
When an organization is created
When a comment is added to a ticket
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add Sheet
Change Sheet Name
Retrieve Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Get Item ID
Delete Sheet
Sort a specified range in ascending or descending order
Unprotect Worksheet
Get Drive Item ID from Sharing URL
Create Excel Session
Retrieve List of Open Ticket IDs
Create Ticket
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add Sheet
Change Sheet Name
Retrieve Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Get Item ID
Delete Sheet
Sort a specified range in ascending or descending order
Unprotect Worksheet
Get Drive Item ID from Sharing URL
Create Excel Session
When a new ticket is created
When a ticket is updated
When a user is created
When an organization is created
When a comment is added to a ticket
Retrieve List of Open Ticket IDs
Create Ticket
Retrieve Ticket Information
Update Ticket Status
Retrieve List of Agents
Create Ticket (Specify Requester)
Upload File
Attach File to Ticket Comment
Retrieve User Information
Add Comment to Existing Ticket
Search Tickets (Subject Partial Match)
Create user
Search Pending Tickets
Update and Add User Information