Hi @jotas10, welcome to the Community!
Hmm, there’s a couple of ways I can think of to handle this.
1) Create duplicate Zap for each country
This option could work well if you’re only ever going going to have two lists. Here you’d have two Zaps that would both trigger for the order on Shopify, but each would have a Filter by Zapier action that what country the customer is from. So the USA version would have a filter set up so that it would only continue if the Country Code field (Text) Contains the value “US”. Then the subsequent Brevo/Sendinblue action would add them to the USA list. And the other Zap would check for the Country Code field for “CA” and the Brevo/Sendinblue action would add them to the Canada list.
If you’ve not worked with filters in Zaps before you can find out more about how to set them up here: Add conditions to Zaps with filters
2) Create a lookup table
If you might have lots of different country lists in the future then this may be a better option. For this, you’d create a lookup table which would have a list of the country values sent by Shopify, and the corresponding IDs for the relevant country list in Brevo/Sendinblue. Then if a new country list is added you can just add it to the Lookup table and not have to duplicate the Zap.
It also allows you to set a fallback value so if the user is from a country that isn’t mentioned in the lookup table you can assign it to a different list ID. With this option you would then use the custom value option on the Brevo/Sendinblue action when selecting the list. This would allow you to select the list ID that’s output by the Formatter action.
You can find out more about how to create lookup tables and custom values here:
Hope that helps. If you run into any issues in giving either of those options a try let us know. Really happy to help further!