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 — 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 sheet, 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 Google Sheet. 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.
For each keyword in column A, fetch Google Trends data via Zenserp and write the interest score and trend direction into columns B and C
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 tabs
The sheet has tabs named "Awareness," "Consideration," and "Decision." Each has keywords in column A. You want Trends data on all three.
On each of the tabs 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
You want clean inputs, Trends data, and a final editorial priority score in a single pass.
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 sheet, 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.