Log Zendesk Cancellation Requests to Google Sheets

4 min setup
No coding required
Runs automatically

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.

zendesk logo icon
When an agent or rule changes a Zendesk ticket
Keep cancellation requests not yet logged
google sheets logo icon
Add the request to your Google Sheets log
zendesk logo icon
Tag the Zendesk ticket as logged

How it works

4 steps to track every cancellation request in one Google Sheet

zendesk logo icon

When an agent or rule changes a Zendesk ticket

App connector: Zendesk • Time to complete: 1 minute

Runs whenever a ticket changes, such as when an agent or a Zendesk trigger adds the cancellation tag.

Keep cancellation requests not yet logged

App connector: Filter • Time to complete: 1 minute

Continue only when the ticket's tags include your cancellation tag (for example cancellation_request) and do not include logged_to_sheet. Use a custom field or the ticket form instead if that is how your team marks cancellations.

google sheets logo icon

Add the request to your Google Sheets log

App connector: Google Sheets • Time to complete: 1 minute

Add a row with the ticket ID and link, the date, the requester's name and email, the subject, the order number from the ticket's order field or subject, and the ticket status.

zendesk logo icon

Tag the Zendesk ticket as logged

App connector: Zendesk • Time to complete: 1 minute

Add the logged_to_sheet tag to the ticket, so later updates to the same ticket are skipped by the filter and never add a second row.

Trusted by 1,000+ merchants
Logo: Rothy's Logo: Adidas Logo: Allure Logo: GQ Logo: DraftKings Logo: Chubbies Logo: Made In Cookware Logo: MUD/WTR

Ready to track every cancellation request in one Google Sheet

Get setup in 4 minutes.

Use this template →

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:

Catch tickets that arrive already tagged
If a Zendesk trigger tags cancellation requests the moment they come in, build a copy of this workflow on Ticket Created so those tickets are logged too. The logged_to_sheet tag keeps the two from adding the same ticket twice.
Add the order total from Shopify
Add a Shopify step that looks up the order by its number and include the total and fulfillment status in the row, so the log shows what each cancellation is worth.
Alert the team in Slack
Add a Slack message after the row so whoever handles cancellations sees each new request right away.

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."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

track every cancellation request in one Google Sheet

4 min setup • Fully supported if you need help