Sounds like you have to create the products in Shopify before adding them to a collection. Our “Send to Shopify” step does not support product creation just yet.
You can create products using our “Send to an API” step. Check out this post where another user needed to create products:
Once the products are in Shopify, you should be able to merge your data to add those products to a collection.
