Auto Populate Multiple Product Mockups From Google Sheet Data
Hello,
I am trying to find a way to use information from a google spreadsheet to help automatically fill in specific products onto a document. I work for a printing company and the idea is that we want to be able to have a way to automatically place specific items we want to show on a document. For example: Out of a total list of 10 items the customer wants to see mockups for items 1, 4, 5 and 7 and only those items.
Currently I am looking at using the variables tool however my biggest struggle is that sometimes customers will want to see upwards of 10-20 different mockups each and we have hundreds of customers. The way I understand it this would mean that we would have to have a really large number of cells per customer on the sheet. Is there any method that would allow for us to create a sort of condensed "check-list" that we could use to show only the items customers want to see?
