The Scenario
You are a content marketing manager. You have 30 topic keywords in column A of a Google Sheet and the editorial calendar for next quarter is due to the team on Friday.
You need a 12-month trend line for each keyword — monthly popularity index by month — so you can identify seasonal peaks and schedule content accordingly.
It is Wednesday morning.
The bad version:
- You open Google Trends in the browser and type keyword 1
- You screenshot the chart because there is no easy export
- You try the CSV export and open it in a separate spreadsheet
- The months are in the wrong order and the keyword name is not in the file
- You copy-paste the values manually into the right row of your editorial sheet
- You do this for five keywords before running out of time Wednesday and picking it back up Thursday
- You deliver an editorial calendar on Friday based on nine keywords instead of thirty.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads your keyword list, submits DataForSEO Google Trends tasks for each keyword, and writes the monthly values directly into the sheet.
Open the SheetXAI sidebar and type:
For each keyword in column A of my ContentKeywords sheet, create a DataForSEO Google Trends task and once complete write the monthly popularity values for the past 12 months into columns B through M.
SheetXAI submits a Trends task for each of your 30 keywords, waits for all results, and fills columns B through M with the monthly index values. You come back to a complete trend matrix.
What You Get
A ContentKeywords sheet with 12 new columns per keyword:
- Columns B-M — monthly popularity index (0-100 scale) for each of the past 12 months, one column per month
All 30 keywords, all 12 months, fully populated. Sort by the peak month to identify which keywords are strongest in Q3 versus Q4. Sum the row to rank keywords by overall annual popularity. The editorial calendar writes itself.
What If the Data Is Not Quite Ready
Content keyword sheets come from multiple sources and have different research needs. SheetXAI handles the variations in one prompt.
When keywords need to be region-specific
You want UK search trends, not global, because the campaign targets a UK audience.
For each keyword in column A of my ContentKeywords sheet, fetch DataForSEO Google Trends data for the UK region for the past 12 months. Write monthly popularity values into columns B through M.
When you want to compare two related keywords side by side
You have competing keyword variations and want to see which has stronger seasonality before committing to one for the editorial calendar.
For each keyword pair in columns A and B of my ContentKeywords sheet, fetch DataForSEO Google Trends data for both keywords together. Write the monthly popularity values for keyword A into columns C through N and for keyword B into columns O through Z so I can compare the trend lines side by side.
When you want the peak month identified automatically for each keyword
Instead of reading 30 rows of monthly values, you want each keyword's best month called out.
Fetch Google Trends data for all 30 keywords in column A of my ContentKeywords sheet. Write monthly values into columns B through M. Then add a column N called PeakMonth and write the calendar month with the highest index value for each keyword.
When you need the trends data plus the editorial calendar draft in one prompt
The Friday deliverable needs the data and a draft calendar, not just numbers.
Fetch Google Trends data for all 30 keywords in column A of my ContentKeywords sheet. Write monthly values into columns B through M. Then create a new Editorial Calendar sheet with one row per keyword, showing the recommended publish month based on peak trend timing, and a brief content angle suggestion based on what the keyword is about.
The pattern: the data pull and the calendar draft happen in one prompt, so Friday's deliverable is ready without a second step.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with a content keyword list, then ask it to pull Google Trends data from DataForSEO. The DataForSEO integration is included in every SheetXAI plan. For related workflows, see how to enrich keywords with search volume and CPC or the DataForSEO in Google Sheets overview.