Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do I deduce a card's email address from its card URL?

I am using Google Sheets to generate a file that I want to attach to a selected Trello card. I have access to the card's URL using Trello's integration with Zapier, but I can't find the email address for the card via the integration. 

While I could have the user manually attach the file to the card, that is not particularly user-friendly for my users. I would prefer to deduce the email address for the card and automate an email to that address with the file attached to the email.

Since I have the card URL, is there a way to retrieve (or decode) the card's email address from the URL?

1 answer

0 votes

Hi there,

Crystal from Trello Support here! 

You can find the email address of the card while inside of Trello. To do this please click on the card and on the card back under "Share and more" you will find the email address. From there you can include the email address for your customers! Here's more information on that: https://help.trello.com/article/809-creating-cards-by-email

 

Thank you...I understand how to navigate to the email address manually on a card.

My question is different. I want to access the email address from a formula in Google Sheets based on the card URL. In particular, I need to use the IMPORTXML function using the card URL and the appropriate XPATH to return the email address. The function call looks like this:
=IMPORTXML("card URL","XPATH to email address")

Can you tell me what the XPATH should be?

My browser tells me it should be 
//*[@id="classic"]/div[5]/div/div[2]/div/div/div/div/div[3]/input
but I'm not successful in getting Google Sheets' IMPORTXML to return the email address (or any value) for that XPATH. 

Thank you.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

Develop a new Habit during Lockdown

If you had to thrive a new habit during a lockdown, what would it be? Trello

1,665 views 16 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you