Skip to main content
Participant
January 16, 2025
Question

Auto Populate Multiple Product Mockups From Google Sheet Data

  • January 16, 2025
  • 1 reply
  • 131 views

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?

1 reply

Inspiring
January 16, 2025

I developed a tool for doing this with apparel and would be happy to discuss and demo the product as is that could be modified to do what your looking to do. Feel free to reach out via PM and I will provide contact details