Log Zendesk Cancellation Requests to Google Sheets
Cancellation requests are easy to lose when they sit in a busy Zendesk queue next to every other ticket. This workflow watches for tickets your team marks as a cancellation request, adds one row per ticket to a Google Sheet with the ticket number, customer, order number and status, then tags the ticket as logged so an update to the same ticket never creates a second row.
How it works
4 steps to track every cancellation request in one Google Sheet
When an agent or rule changes a Zendesk ticket
When an agent or rule changes a Zendesk ticket
Keep cancellation requests not yet logged
Keep cancellation requests not yet logged
Add the request to your Google Sheets log
Add the request to your Google Sheets log
Tag the Zendesk ticket as logged
Tag the Zendesk ticket as logged
Ready to track every cancellation request in one Google Sheet
Get setup in 4 minutes.
FAQs
How does the workflow know a ticket is a cancellation request?
It looks for the tag your team already uses, such as cancellation_request. You can add that tag by hand, with a Zendesk trigger that matches words like cancel in the subject, or by switching the filter to a custom field or ticket form.
Why doesn't an updated ticket create a second row?
After the row is added, the workflow tags the ticket logged_to_sheet, and the filter skips any ticket that already has that tag.
Can the row include the order number?
Yes. Map the order number from a custom ticket field if your form collects one, or from the subject if customers include it there.
Personalize this template
Customize this workflow even further:
You're in good company
"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."
"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."
"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"
track every cancellation request in one Google Sheet
4 min setup • Fully supported if you need help
