The Scenario
The handoff from the designer who left last month included one Excel workbook, one Figma link, and a note that said "here's the visual direction." The workbook has 50 product category keywords in column A. The Figma link is a mood board with no labels.
Your job is to figure out what visual styles are actually dominating search results for each of these categories — not what looks good in isolation, but what Google Images surfaces when a buyer types in the term. That's the competitive visual audit.
The bad version:
- Open Google Images, type the first keyword, screenshot the top results, save the file with a name that makes sense now but won't in a week
- Repeat for each of the 50 keywords, accumulating 50 folders of screenshots that need to be annotated later
- Realize that "later" never comes and you're presenting to the merchandising team on Thursday with half the audit done
You are supposed to be doing visual analysis, not running search queries by hand. The data collection is the bottleneck, and it's the least valuable part of the work.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads your keyword list from column A, calls Serply's image search endpoint for each term, and writes back image URLs, titles, and source domains without you touching a browser.
For each keyword in column A, search Google Images via Serply and fill in the top 5 image URLs and source domains into the next 10 columns
What You Get
- Columns B, C — image URL and source domain for the top image result per keyword
- Columns D through K — the same two fields for results two through five
- Source domains tell you immediately which publishers, retailers, or stock sites dominate for each category
- URLs are direct image links — usable in Figma or a presentation without any further lookup
What If the Data Is Not Quite Ready
I need image titles in addition to URLs and domains
For each keyword in column A, search Google Images via Serply and write the top image URL, image title, and source domain into columns B, C, and D
Some keywords are too generic — I want to scope them to a specific visual context
For each keyword in column A, search Google Images via Serply using the modified query "{keyword} product photography" and write the top 3 image URLs and source domains into columns B through G
I need to join image results with a category tag from a second worksheet
For each keyword in column A, search Google Images via Serply and write the top image URL and source domain into columns B and C; then look up the category tag from the "Categories" worksheet where column A matches the keyword and write it into column D
Pull top images, flag stock-photo-heavy categories, and note dominant domains in one pass
For each keyword in column A, search Google Images via Serply and pull the top 5 image URLs and source domains into columns B through K; then count how many of the 5 results come from stock photo domains (shutterstock.com, gettyimages.com, istockphoto.com, unsplash.com) and write that count into column L; flag any keyword where the count is 4 or 5 as "Stock-dominated" in column M
One prompt collects the data, runs the domain analysis, and surfaces the editorial insight in the same pass.
Try It
Open your keyword research workbook with product category terms in column A and get the 7-day free trial of SheetXAI. Ask it to run Serply image searches for each keyword and fill in the top image URLs and source domains. You can also explore pulling Google Scholar results with Serply or browse the full Serply integration overview.