The Scenario
You are a content marketing manager. You have 30 topic keywords in column A of an Excel workbook 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.
It is Wednesday morning.
The bad version:
- You open Google Trends in the browser and type keyword 1
- You try the CSV export and open it in Excel
- The date column is formatted as text and Excel refuses to sort it correctly
- You fix the date formatting, copy three columns, match them to your keyword row manually
- You do this for five keywords before running out of time and picking it back up Thursday
- You deliver an editorial calendar 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 Excel workbook that reads your keyword list, submits DataForSEO Google Trends tasks for each keyword, and writes the monthly values directly into the workbook.
Open the SheetXAI sidebar and type:
For each keyword in column A of my ContentKeywords tab, 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 tab with 12 new columns per keyword:
- Columns B-M — monthly popularity index (0-100 scale) for each of the past 12 months
All 30 keywords, all 12 months, fully populated. Sort by the peak month to identify which keywords are strongest in Q3 versus Q4. The editorial calendar writes itself from the trend matrix.
What If the Data Is Not Quite Ready
Content keyword workbooks come from multiple research sources. SheetXAI handles the variations in one prompt.
When keywords need region-specific trend data
You want UK search trends because the campaign targets a UK audience.
For each keyword in column A of my ContentKeywords tab, 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 keyword variations side by side
You have competing keyword options and want to see which has stronger seasonality before committing.
For each keyword pair in columns A and B of my ContentKeywords tab, fetch DataForSEO Google Trends data for both keywords. Write monthly values for keyword A into columns C through N and for keyword B into columns O through Z.
When you want the peak month identified automatically
Instead of reading 30 rows of monthly values, you want each keyword's best month surfaced.
Fetch Google Trends data for all 30 keywords in column A of my ContentKeywords tab. 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 an editorial calendar draft in one prompt
The Friday deliverable needs the data and a draft schedule, not just numbers.
Fetch Google Trends data for all 30 keywords in column A of my ContentKeywords tab. Write monthly values into columns B through M. Then create a new Editorial Calendar tab with one row per keyword showing the recommended publish month based on peak trend timing and a brief content angle suggestion.
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 Excel workbook 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 in Excel or the DataForSEO in Excel overview.