About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Send email to address from Google Sheets based on Trello card moving

  • 12 August 2020
  • 1 reply
  • 74 views
P
Userlevel 1

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!

icon

Best answer by Janine_Anderson 12 August 2020, 17:04

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Janine_Anderson
Userlevel 4
Badge +4

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