The Scenario
You're three hours into building a content brief for a new product line — twenty blog posts, each targeting a different keyword. The brief template has a column for reference images: source domain, image title, and URL. Someone on the team filled in the first two rows months ago, manually. The other eighteen are blank.
You know the keywords. You need the top Google image results for each one. And you know what the bad version looks like:
The bad version:
- Open Google Images, search keyword 1, right-click the first five results, copy each image URL and source domain one at a time
- Paste into the sheet, fix the column alignment, search keyword 2, repeat
- Forty minutes in, realize you've been copying preview URLs instead of source URLs for the last eight rows and have to redo them
The brief goes to the creative director at 3 PM. Redoing eight rows of image research is not where your afternoon should go.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your keyword list, calls the Autom image search API for each row, and writes the results — URL, title, source domain — back into the adjacent columns. You open the sidebar, type one prompt, and watch the columns fill.
For each search query in column A of the "Content Brief" tab, fetch the top 5 Google image results from Autom and write the image URL into column B, the image title into column C, and the source domain into column D.
What You Get
- Columns B, C, and D populated for every non-empty row in column A
- Image URLs are direct source links, not preview thumbnails
- Titles pulled from Autom's structured response, not scraped alt text
- Any keyword that returns fewer than 5 results writes what's available and leaves remaining rows blank rather than erroring
What If the Data Is Not Quite Ready
The keyword list has inconsistent capitalization and trailing whitespace
Before fetching image results, trim whitespace and normalize each keyword in column A to lowercase. Then fetch the top 5 Google image results from Autom for each cleaned keyword and write the image URL, title, and source domain into columns B, C, and D.
Some rows have multi-keyword phrases that need to be treated as exact queries
For each search query in column A of the "Content Brief" tab, treat the entire cell value as a single exact-match query — do not split on spaces. Fetch the top 5 Google image results from Autom and write image URL, title, and source domain into columns B, C, and D.
The results need to be filtered to exclude a specific domain
Fetch the top 10 Google image results from Autom for each keyword in column A. Write only results where the source domain is not "pinterest.com" into columns B, C, and D — up to 5 qualifying results per row.
Full cleanup-plus-fetch in one shot
Column A has search keywords with inconsistent casing and some blank rows. Skip blank rows. Normalize each keyword to lowercase and trim whitespace. For each cleaned keyword, fetch the top 5 Google image results from Autom. Write the image URL into column B, title into column C, and source domain into column D. If a keyword returns zero results, write "no results" in column B for that row.
The pattern is to fold the data cleaning into the same instruction as the fetch — one prompt handles both ends.
Try It
Open your content brief sheet and get the 7-day free trial of SheetXAI — then ask it to pull Autom image results for every keyword in your list. Also see: looking up Google country codes and the Autom hub overview.