Tells a VIP customer's account manager in Slack when they open a Zendesk ticket.

UsesGoogle SheetsSlackZendesk

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.

ZendeskZendeskWhen a ticket is created. Save it as ticket.When a ticket is created. Save it as ticket.
ValuesVIP customers sheetSet vip_sheet_url to blank.
Google SheetsVIP row for this customerRead the rows of vip_sheet_url. Save it as vip.Google Sheets
Decisions & LoopsIf vip.count is greater than 0If vip.count is greater than 0
Yes
SlackTell the account managerSend a direct message to vip.rows[0]["Account manager email"]. Save it as alert.VIP ticket from ticket.requester_name: ticket.subject ticket.urlSlack
No
No steps