The Scenario
You are a content strategist at a SaaS company planning next quarter's editorial calendar. You have 30 keyword candidates in column A of an Excel workbook — topic ideas, long-tail variations, competitor-adjacent terms. Before you pitch the editorial plan to the marketing director, you need Google Trends data to defend which topics are worth pursuing.
The meeting is Thursday. It's Tuesday morning.
The bad version:
- Open Google Trends in one tab, Zenserp in another.
- Type the first keyword, note the interest score, flip back to the workbook, type it into column B.
- Do it again for keyword 2. Keyword 3.
- Hit keyword 12, realize you forgot to record whether the trend was rising or falling. Go back and redo.
Thirty keywords, two columns, at least an hour of tab-switching — and the numbers will be stale by Thursday if you pull them today.
The real issue is that Trends data only matters in comparison. The answer to "should we write about topic A?" depends on whether A has more interest than B, C, and D. But you can't compare what you haven't pulled.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads column A, calls Zenserp's Trends endpoint for each keyword, and writes the interest score and direction back into columns B and C.
Look up Google Trends interest for all keywords in column A using Zenserp and populate this Excel sheet with the trend score and relative popularity for each keyword
What You Get
- Column B: interest score (0–100 scale from Trends)
- Column C: trend direction — "rising," "stable," or "declining" based on the data Zenserp returns
- Rows sorted by your original order; you can sort by column B afterward to see the ranking
What If the Data Is Not Quite Ready
Some keywords are phrases that need quotation for exact match
A few of the candidates are multi-word phrases that return inflated Trends scores when searched loosely.
For each keyword in column A, if the term contains more than two words, wrap it in quotes before fetching Trends data via Zenserp. Write interest score and trend direction into columns B and C for all rows.
You want 12-month trend scores and a 30-day trend score side by side
The editorial director wants to see both the sustained interest and the recent momentum for each topic.
For each keyword in column A, fetch two Google Trends interest scores via Zenserp — one for the past 12 months and one for the past 30 days — and write the 12-month score in column B and the 30-day score in column C.
You need to compare trends across three keyword groups in separate worksheets
The workbook has worksheets named "Awareness," "Consideration," and "Decision." Each has keywords in column A. You want Trends data on all three.
On each of the worksheets named Awareness, Consideration, and Decision, fetch Google Trends interest data via Zenserp for each keyword in column A and write the interest score and trend direction into columns B and C.
Full pipeline: normalize keywords, pull Trends, rank and flag top targets
Trim and lowercase all keywords in column A, then fetch Google Trends interest score via Zenserp for each one and write it into column B. In column C, write "priority" if the interest score is 60 or above and "low priority" if it is below 60. Sort the sheet by column B descending.
Pull the data and apply the editorial filter in one instruction instead of two steps.
Try It
Get the 7-day free trial of SheetXAI and open your keyword research workbook, then ask it to pull Google Trends interest scores via Zenserp for everything in column A. For competitive price research using Google Shopping data, see the Google Shopping competitive pricing spoke.