Question

Update Trello Card from Google Sheet: index board instead of list?

  • 8 December 2021
  • 3 replies
  • 69 views

I am having a whole lot of trouble with this Zap.

What I am trying to do is to “when row in google sheets is updated > find trello card > Update Trello Card”.

I thought this would be simple, but clearly, it is not.  I would like it to, every time I update a row in google sheets, find the appropriate Trello card in a workspace (or create one) and update it accordingly.  I would even be happy if it just indexed one board.

The problem I’m running into is that it’s requiring a list name to index.  I need it to index the whole board, not just one list.

Property Name Contact Name Contact Phone Contact Email Job Type Trello List State # Units bldg Type Quarter City Date Added Due Date Job Month Unweighted $ Probability Weighted $ Description Management Maint Name Maint Phone Maint Email AP Name AP Email AP Phone AP Software
Alexan at 20th St Jerri Doe 123.456.7890 asdf@abc.com Int Dryer Vents 🎯 Re-Market CO 354 Highrise Apts Q2 2021 Denver 2021-Apr 14-May June $ 16,500 100.0% $ 16,500 Lorem Ipsum Dolor Sit Amet Greystar Jane Doe 123.456.7890 qwerty@abc.com John Doe doe@abc.com 123.456.7890 OPS

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

3 replies

Userlevel 7
Badge +14

Hi @trin.vh 

Action: Trello Find Card

Org, Board, List are NOT required fields, only Card Name

 

Perhaps you can show screenshots with how your Zap steps are configured to help clarify your use case issue.

 

 

 

Thanks for responding Troy!  Appreciate your time

It’s only happening to me when I select “Find or Create a Card”.  I figured it would try to index the whole board and then create a card in a specific list if it didn’t find it in the board, but it seems to be indexing only that list and then creating a new card in the list if it didn’t find it in that specific list.

This post has been edited by a moderator to remove sensitive information. Please remember to obfuscate any personally identifiable information prior to posting as this is a public forum. 

Userlevel 7
Badge +14

@trin.vh

Try these Zap steps instead...

Action: Trello - Find Card

Action: Paths (https://zapier.com/help/create/customize/add-branching-logic-to-zaps-with-paths)

Action: Path A - Filter (Found = TRUE)

Action: Path A - Trello - Update Card

Action: Path B - Filter (Found = FALSE)

Action: Path B - Trello - Create Card