How to send custom email notification to matched username

[Kevin Shiflet]

I would like to create custom email notifications for certain activities my users could take in Trello, including assigning a card, changing a label or custom field, or commenting and tagging someone. 

Butler appears to limit the recipients of custom email notifications to 1) specific email address, 2) All members of a card, 3 All members of a board. 

Is there any way to instead dynamically insert the email address dynamically according to the matched user name or triggering user name? 

Butler variables - Trello Help

[Hannah Humbert - Simpla Workflows · Accepted solution]

Hi @Kevin Shiflet ! Welcome to the community :) I guess Trello would need some way of understanding what username corresponds to what email address. An idea could be to create a list and then add a card for each user. The title of the card would be the user's Trello username. This list could exist on the board where the activity is happening, or you might want to store it on a separate board. From there, you can create a custom field called "Email". In each "user card", input their email address. Then, your rule could look like this:

when X happens, find a card titled "{username}" on board "Directory", and send an email notification to "{{%Email}}"

If you don't have custom fields due to being on the free plan, you could just add the email address to the description and just use the {carddescription} variable.

[Kevin Shiflet]

@Hannah Humbert - Simpla Workflows  thanks so much for getting back to me so quickly. I did try the solution you suggested and I'm still having trouble. I put together a new board called Directory, and named a card my username, as you said. The activity I'm looking for to trigger is a tagged comment on a card on a different board. 

Then I added a custom field called 'EmailAddress' to that Directory board with my email address and attempted to run the rule like you mentioned. 

The rule goes as:

'find a  card titled {username} on board 'Directory'

then

'send an email notification to 'EmailAddressvalue' with subject blahblahblah...

I'm not receiving a notification though. Can you see any obvious error I'm missing?

Thanks for all your help on this. 

[Hannah Humbert - Simpla Workflows]

@Kevin Shiflet try instead: "send an email notification to "{{%Emailaddress}}""

[Kevin Shiflet]

@Hannah Humbert - Simpla Workflows I tried that and a few variants of that and haven't had success yet. :(

Attaching some screenshots. Let me know if you think I'm missing anything obvious. 

[Hannah Humbert - Simpla Workflows]

Try {{%Emailaddress}} - you don't need to add "value" into it.

[Hannah Humbert - Simpla Workflows]

[Kevin Shiflet]

@Hannah Humbert - Simpla Workflows thanks for your continued assistance on this. I tried this formatting and got an error: 

The email address {{%emailaddress} is invalid.

I tried a few different permutations and either got the above error or 'No email address to send to'. 

Any thoughts? I don't want to, but I could try moving the directory bit to the same board and just squirrel away the list far to the right. 

[Hannah Humbert - Simpla Workflows]

Oops, looks like my screenshot had a typo. The variable should be {{%Emailaddress}} as mentioned above. Just make sure the field name is spelled the same as your custom field (including any spaces). There's more info on custom field variables here: https://help.trello.com/article/1160-custom-field-variables#custom-field-variables 

[Kevin Shiflet]

@Hannah Humbert - Simpla Workflows thanks for sharing this! It finally worked! I switched it to {matchedusername} and it still worked so I think this should be good. 

Thanks for all your help on this. 

[Kevin Shiflet]

@Hannah Humbert - Simpla Workflows One caveat on this, the email body references the card link, which should go back to the commented card, but instead it's going back to the directory card with the email address on it. 

Do you know what's best to get the commented card instead?

[Hannah Humbert - Simpla Workflows]

For your particular trigger, {matchedusername} would find the user that has been @mentioned. {username} will be the user who was associated with the action. 

If you're wanting to pull details from the trigger card into your email message, prefix everything with "trigger". So, {triggercardname}, {triggercardlink}, etc.

[Kevin Shiflet]

@Hannah Humbert - Simpla Workflows that did the trick!

[Hannah Humbert - Simpla Workflows]

Awesome! Glad that's all working now :)