I am want to use Zapier to create new cards and place them in the appropriate list when a new row is added to one of my Google Sheet tabs.

So you understand my company, think of it as a magazine, my google sheet is updated daily by the people selling ads into the magazine.

Tab1 - holds all the details for the current edition of the magazine. (I have successfully built a Zap to create a new board based on this input).

Tab2 - holds all details for the advertisers who have purchased advertisements with my company. Each row is unique to the advertiser and contains a code connecting the advertiser to the project they have purchased.

I want to create a new card and place it in the appropriate board under the correct list. I cannot get the lists to load because I cannot get my projects connected.

When I go to choose the board to attach the new card, I am only given a list of the currently available boards - these obviously change, sometimes multiple times a day. I have tried to use the formatter tool, but I cannot use the lookup function for this because I do not know what the future list of possible items will be. I can't just connect text to text because Trello is looking for a code (See attached photo).

Is there something I am missing? I've looked through support section, watched videos, etc. I'm not sure where else to ask. Thank you in advance!