Tells a VIP customer's account manager in Slack when they open a Zendesk ticket.
Uses
Google Sheets
SlackZendesk
Alert the account manager when a VIP customer opens a ticket
Your most important customers should never wait in the general queue. When a new Zendesk ticket arrives, this looks up the sender in your VIP sheet.
If they are listed, their account manager gets a Slack message with the subject and a link to the ticket. Everyone else is ignored. The sheet needs the columns Customer email and Account manager email.
ticket.When a ticket is created. Save it as ticket.vip_sheet_url to blank.vip_sheet_url. Save it as vip.Google Sheetsvip.count is greater than 0If vip.count is greater than 0Yes
vip.rows[0]["Account manager email"]. Save it as alert.VIP ticket from ticket.requester_name: ticket.subject
ticket.urlSlackNo
No steps