Shopify Product Listing by Collection or Collections

I have what I think is a reasonable request. I want to automatically bring my Shopify products into Stackby using the API connector. I want each stack to contain all products for one or more collections. Some of my collections are similar items so I want to group them together into one stack. Other collections will have their own stack. I watched the only video I could find on connecting Shopify via a API connector. I really don’t understand the results and why they are setup the way they are. I simple want a list of products by collection. Each row would be a product. I would select what columns to display based upon the API connector. When new products are added in Shopify, I want the API to update the stack and add a new row. Right now everything is backwards to me. All the products are being listed in the same row. I don’t want them all listed in the same row, Do I? As far as I know each stack can have 15,000 rows. I don’t know the capacity of the row for the number of columns, but I would think you would run into issues if too many products are listed in one row. See below. How best to set this up? A Shopify template for this would be helpful, if all I had to do is update my API key and my collection numbers. FYI - I was able to reproduce the results similar to the Shopify video where collections are listed by product handle. I hope there is an automated way to do this, manually copying and pasting from one worksheet to the next makes no sense. This is suppose to make our lives easier. Also The system has been crashing for the last 5 hours. Very difficult to work on:(. Your support and guidance is greatly appreciated! Thank You!