Ask Janek AI with Janek

All questions

Auto-Generate Social Media Posts for Products Using AI + Make.com · published 23 May 2025

Play at 4:14 Watch on YouTube Products

How do I match a product photo file name to a Google Sheets row in Make?

I use Google Sheets, Search rows, and I set the product name column equal to the image name.

It is the same product table: name, description, and price. I do not need a huge range. A to Z is enough, because I only use the first five columns. The filter is the product name equal to the image name.

The file on Drive still ends in .png, so the names do not match until that extension is gone. I send the file name through Grok for that cleanup. It does not cost much. After the search, the module returns the whole matching row.