Hi All, 

I am struggling to figure out the last piece of the puzzle with my Zap. I am trying to create a zap that creates a new trello card each time a new row (or batch of rows) are added to a google sheet worksheet. 

The Google worksheet has 12 columns that need to correspond with 12 associated custom fields in a Trello card. Where it gets complex (I think) is in two problem areas: 

1. I would like the same color-coded text labels in Google Sheets to automatically create the same/corresponding label (same text AND color) in Trello. I.e., “needs editing” is a red label in google sheets, so I’d like it to be “needs editing” in red in Trello too. Worth mentioning that I’ve already created the labels in both sheets and Trello...they’re just not able to match when I test the Zap. I’ve tried the ‘add label to Trello card’ action with no luck. 
    
2. In the Google Sheet, some columns are drop-down lists like yes or no...or “needs editing” / “for review.” How do I structure my Zap to automatically match the drop down menu selection in Sheets to the corresponding drop-down menu in Trello? 

​​​​Any and all help is deeply appreciated!!