Create 10,000 product thumbnails in one click, automatically and in bulk

First, let me briefly explain why we created this workflow.

Today's house changed its business model to increase the contribution transaction volume of rental category products. In the past, the partner or brand directly registered the product and today's house was only in charge of the brokerage (as-is), but today's house has been converted to a model (to-be) where the rental subscription is brokered by signing a contract directly with the partner.

As a result, I was tasked with researching 10,000 product thumbnails in today's home direct brokerage rental category.

In general, each brand manages product information differently, so the general grammar of exploring rental products was that the model name or option (color, commitment) information was displayed visually well.

Card discounts and other information are important and shouldn't seem too messy. Here, it was also necessary to reliably announce that it was a product managed by today's house. It's practically impossible for a designer to fit these conditions into hundreds of products by hand.

It was impossible for the designer to fit hundreds of items by hand, so the first step was to reduce the repetition. Instead of creating a new model name, options, and benefits for each brand, we decided that if we could process them in dynamic text within the template, the information could be reflected immediately without design requests.

The next question was how to get the Ops person to hand over the information. If you familiarize yourself with the new tool, it can be a bottleneck, so we adopted the Google Sheets you're already familiar with as the input channel. It was a structure that only needed to be filled, so there was almost no running curve.

Once this direction was established, we designed an automation solution that automatically synthesizes data into templates as a trigger for sheet updates to create thumbnails.