Hi everyone,

I'm building a Zap that should do the following:

User submits form > form generates row of data in spreadsheet > data used to create trello card > when trello card is moved to done, email is sent to form submitter to tell them issue is done. I have already got the Google form to write to sheets, and the sheet to create a trello card. But I am getting stuck when trying to get the Trello card moving to ‘done’ to trigger an email lookup and send.

Here’s how I’ve set it up:

• Step 1: Trello trigger works fine — it detects the card moving to "Done"

• Step 2: I'm using the Lookup Spreadsheet Row action. I’m searching by Description (which exists in both the Trello card description and the sheet)
   

It’s at this point that I get stuck. There is no option to add any further actions to my zap, so I can lookup the data but whether it works or not is not clear because the zap then doesn’t perform any kind of action. So from here, I am unable to test the zap, and I can’t do anything else either, like send an email to the address in that row. 

Here’s a quick recap of what I want to achieve, any advice would be gratefully received:

Form submission > generates row of data in spreadsheet > creates trello card  with that data > trello card is moved to done > email sent to form submitter to tell them issue is done.

 

Thanks so much!

Elle