Tells a VIP customer's account manager in Slack when they open a Zendesk ticket.
Uses
Google Sheets
Slack
Zendesk
Alert the account manager when a VIP customer opens a ticket
ZendeskWhen a ticket is created. Save it as ticket.When a ticket is created. Save it as ticket.
VIP customers sheetSet vip_sheet_url to blank.VIP row for this customerRead the rows of vip_sheet_url. Save it as vip.Google Sheets
If vip.count is greater than 0If vip.count is greater than 0Yes
Tell 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.urlSlackNo
No steps