The Scenario
You're a content strategist at a B2B SaaS company. Every quarter, you pitch the editorial calendar to the VP of Marketing. Every quarter, you've been pulling together keyword ideas in a workbook, labeling some "seems popular" and others "probably niche," and hoping the room agrees with your intuition.
This time, you have 60 candidate blog topics in column A. You want real numbers. Specifically, you want the 12-month average Google Trends interest score for each topic and the top 3 related queries so you can rank the list by demand rather than gut feel — and actually defend the choices in the meeting.
The bad version:
- Open Google Trends. Type the first keyword. Set the time range to the past 12 months. Note the average interest score (which isn't even displayed as a number — you're eyeballing the graph). Open the related queries section. Copy the top 3. Paste into the workbook. Next keyword.
- After 12 topics you realize the interest scores aren't comparable across keywords because you forgot to set the region filter consistently. Start over.
- Use the Trends API. Discover it requires a pytrends Python script, which requires a Python environment, which requires convincing IT to install something, which requires explaining what pytrends is.
The VP is going to ask why you picked topic 23 over topic 7. "It felt more timely" is not the answer that ends the conversation.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the topic list in column A, queries Composio Search's Google Trends tool for each keyword, and writes interest scores and related queries back in columns B and C.
For each keyword in column A, get the 12-month average Google Trends interest score and the top 3 related queries and write the interest score into column B and the related queries as a comma-separated list into column C.
Sixty keywords. Numbers and context for each. The editorial ranking becomes a sort by column B.
What You Get
- Column B: 12-month average normalized interest score (0-100) for each keyword
- Column C: Top 3 related queries from Google Trends as a comma-separated list
- Keywords with no trend data return a score of 0 rather than an empty cell
- Results are consistent because every query uses the same region and time range
What If the Data Is Not Quite Ready
You want to compare trend trajectory, not just average score
You need to know whether a keyword is growing, flattening, or declining — not just its average.
Compare the trend trajectory for each keyword in column A over the past 12 months and label each as 'Trending Up', 'Trending Down', or 'Stable' in column B. Write the 12-month average interest score into column C.
You have keyword pairs and want head-to-head comparisons
Columns A and B each have a keyword. You want to know which one is trending stronger.
Compare the trend trajectory for each keyword pair in columns A and B over the past year and label each pair: write the stronger-trending keyword into column C and the margin difference in average interest score into column D.
You want to filter the list to only high-potential topics before presenting
Fetch the 12-month average Google Trends interest score for each keyword in column A and write it into column B. Then filter the workbook to show only rows with a score of 50 or above and sort those rows by score descending.
Kill chain: score, label trajectory, pull related queries, flag low-signal topics
For each keyword in column A, fetch the 12-month average Trends interest score into column B, label the trajectory as Trending Up / Stable / Trending Down in column C, write the top 3 related queries into column D, and mark any keyword with a score below 20 as 'Low Signal' in column E.
One prompt scores, classifies, enriches, and filters the full list.
Try It
Get the 7-day free trial of SheetXAI and open your content calendar planning workbook. Ask it to score every keyword by real search interest and pull related queries in bulk. See also: Build a Competitor News Digest Into an Excel workbook With Composio Search or the Composio Search hub.