Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello everyone,

 

I already created a zap that emails someone when a Trello card is moved to a certain list. The card is formatted like this:

Title: anything

Description: message that should be emailed

Comment: email address that the message should be sent to

 

The problem is that I want to remove the address from the card comments and have Zapier search for it in a Google Sheet. I was thinking of setting the card title like “Client X” and then Zapier searches for “Client X” in the first column and gets the email address from the corresponding cell in the second column. Is it possible to do this?

 

I hope that I made myself clear, sorry for any English mistakes. Thanks!

Hi @pedromanfroi! This should be possible. It will be a three-step Zap.

  • Start with the Card Moved to List trigger in Trello
  • Then use the Google Sheets action to Lookup Spreadsheet Row. That will look for a row by column and value, and return all data in the row if the value is found in the specified column. Your strategy of naming the card “Client X” and having that be what is in your first column should work!
  • Finally, add your email step. You’ll be able to use the info from your Google Sheets search step to pull in the correct email and set up the message to use the info from your Trello step.

When you customize your email, you’ll be able to click in boxes that says “Type or insert...” and see a menu of options from which to choose. You can select either of your previous steps to find the information you need. It should look something like this:

 

I hope that helps!

Terms & Conditions