The Scenario
An e-commerce merchandiser is preparing a competitive landscape review for a quarterly business review. She has 40 product image URLs in column A — her own catalog shots — and needs to know what visually similar products competitors are listing and on which domains. The QBR is next Tuesday.
The bad version:
- Open Google Lens, paste image URL 1, scroll through the visual matches, identify the top 3 competitor products, copy the product title and domain into columns B through G
- Do the same for image URL 2, then 3, realizing around image 10 that the results vary by how you paste the URL versus upload the file, so some rows are using web-based search and some are using upload, making the comparison inconsistent
- Spend an extra hour re-running the inconsistent rows with a standardized method, finishing with a sheet that took half a day to produce
The QBR is about strategic decisions — which product lines to expand, where to cut. This kind of data collection is not where those decisions get made.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the image URL list in column A, calls SerpApi's Google Lens endpoint for each one using a consistent method, and writes the visual match data back — all 40 rows. One prompt.
For each image URL in column A, run a Google Lens search via SerpApi and fill in the top 3 visually similar product titles and URLs into columns B through G
What You Get
- Columns B, D, F receive the product title for visual match positions 1, 2, and 3
- Columns C, E, G receive the source URLs for each match
- Image URLs that return no visual matches get a note in column H rather than empty rows that look like data gaps
- All 40 rows are processed with the same Lens query method, making the results comparable
What If the Data Is Not Quite Ready
Some image URLs in column A are broken or redirect
For each image URL in column A, first verify the URL is accessible (200 status), then run a Google Lens search via SerpApi for accessible URLs and write the top 3 visual match titles and source domains into columns B through G; mark broken URLs in column H
You want source domain extracted, not full URL
For each image URL in column A, run a Google Lens search via SerpApi and write the top 3 visually similar product titles and the source domain (not full URL) for each into columns B through G
You want to flag when our own domain appears in the results
Run Google Lens via SerpApi for each image URL in column A, write the top 3 visual match titles and URLs into columns B through G, and flag in column H any row where one of the result URLs contains our domain from cell A1
Full competitive pull with domain frequency count in one prompt
For each image URL in column A, run Google Lens via SerpApi and write the top 3 visual match titles and source domains into columns B through G; after all rows are complete, count how many times each competitor domain appears across all results and write a frequency table starting at row 45
One prompt, a per-row enrichment and a cross-sheet summary.
Try It
Get the 7-day free trial of SheetXAI and open your product catalog sheet, then ask SheetXAI to run Google Lens searches for every image URL. Also see the spoke on building a Google Shopping price-tracking sheet, or the hub overview of all SerpApi workflows.