Skip to main content

Hi there,

I’d like to set up a zap which sends a direct message to a user based on a ticket event and the assignee of that ticket in zendesk.

For this purpose I’m trying to use: Send Slack direct messages for new Zendesk tickets

I’ve then created a view which returns open tickets.

The bit I’m struggling with, is how to set the username notified to be variable upon who the ticket is assigned to in Zendesk.

In the custom fields it has zendesk assignee email, but when I test the zap I get a channel not found error.

I’ve tested the trigger and it picks up the ticket perfectly. So I’m pretty certain the issue is with going from the zendesk assignee’s email to a slack users DM.

Has anyone done this before, or know a way to set it up?

 

 

@TCurry 

To send a direct message, it’s best to use the “Slack ID” of that person since the username can change. You can see the Slack ID below: U1K7SHA9J


To translate Assignee Email to Slack ID, I would advise using a Lookup Table:

 


Hi @MarijnVerdult thanks for the suggestion. I was hoping that as zendesk and slack hold the same email address for our agents that there would be a way to automatically link up the two based on that. Rather than the agents username which as you say can change.

 

The lookup table I think requires me to manually input all of our agents emails and their relevant slack ids which isn’t a sustainable solution for me as we have several hundred agents. Am I understanding this correctly, or is there a way to set up the translation from Assignee Email to Slack ID to be a bit more automatic, or is there a way this can be uploaded in bulk?

 

Thanks!

 


@TCurry - With so many agents a Lookup Table is indeed not the best way to go. Unfortunately there doesn’t seem to be the option to message based on email address directly.

 

I just found the Find User by Email in Slack search step. You should be able to use this to translate the email into a user id:

 

The Zap would then be:

  1. Trigger by Zendesk
  2. Find User by Email in Slack
  3. Private Message based on User ID

 


@MarijnVerdult what a find!! That works an absolute treat.

This unlocks a load of cool applications for us, really appreciate the help :raised_hands:

For anyone interested in how I set up the trigger to work when a tickets status changes as I don’t think there’s currently that option.

I created a view looking for tickets in status open, so when a tickets status changed to open it ended up in the view triggering the rest of the zap.