Google Trends Content Calendar Generator

Turn Google Trends data into a ready-to-publish content calendar.

Drop in your keyword list and get back a dated, prioritized publishing schedule — breakout topics scheduled first to ride the wave, rising topics next, evergreen topics filling the gaps, and declining topics flagged for refresh. Each slot comes with a headline idea, a content angle, and a one-line "why now" rationale.

Setup: supply your SerpApi key in the secret serpApiKey field, add your keywords, and run. Check your provider account for its current quota and charges.

---

What it does

Most keyword tools hand you a spreadsheet and leave the "so what do I publish, and when?" to you. This Actor closes that gap:

1. Pulls Google Trends interest-over-time + related queries for each keyword (via SerpApi).
2. Scores each keyword with the TrendPulse engine (growth, momentum, related demand, breakout signal, confidence, volatility).
3. Classifies it: breakout / rising / stable / volatile / declining.
4. Schedules it onto a real calendar — strongest, most time-sensitive opportunities get the earliest slots.
5. Generates a headline idea, content type, content angle, and rationale per slot.

Output is one dataset row per scheduled piece of content, ordered by publish date.

---

Who it's for

• Content & SEO teams — turn keyword research into next quarter's editorial calendar in one run.
• Agencies — generate a client-ready content plan per portfolio in minutes.
• Newsletter writers — know which rising topics to feature this week.
• YouTubers & creators — line up your next 8 weeks of videos by momentum.
• Solo founders — replace "what should I write about?" with a dated plan.

---

Popular content planning use cases

• SEO content calendar generator - turn keyword lists into dated blog, video, social, or newsletter slots.
• Trending topic planner - schedule breakout and rising Google Trends topics while demand is climbing.
• Agency editorial calendar - generate client-ready publishing plans from a keyword export.
• YouTube content schedule - prioritize video topics by trend status and momentum.
• Newsletter planning - fill upcoming issues with rising themes and timely angles.
• Content refresh queue - flag declining keywords as update tasks instead of net-new posts.

---

How scheduling works

Trend status	Priority	Where it lands	Content treatment
breakout	urgent	Earliest open slots	Fast-response news/explainer — ride the surge
rising	high	Early–mid calendar	Build authority as interest climbs
volatile	medium	Mid calendar	Cover, but flagged as uncertain
stable	evergreen	Fills remaining slots	Reliable, always-relevant content
declining	refresh	Optional	"Update existing content" task, not net-new
insufficient_data	—	Skipped	Not enough signal to plan around

Within each tier, keywords are ordered by TrendPulse score so the strongest opportunities get the most valuable early slots. Total slots = postsPerWeek × calendarWeeks; extra keywords beyond capacity are dropped (logged).

---

Input

Field	Type	Default	Description
keywords	string[]	—	Keyword list
keywordsText	string	—	One keyword per line or comma-separated
serpApiKey	string (secret)	—	Required. Free key from serpapi.com
calendarStartDate	string	tomorrow	First publish date, YYYY-MM-DD
postsPerWeek	integer	3	Slots scheduled per week (1–14)
calendarWeeks	integer	8	Weeks to plan ahead (1–52)
contentFormats	string[]	["blog"]	Rotate across blog, video, social, newsletter
includeDecliningAsRefresh	boolean	true	Schedule declining keywords as refresh tasks
geo	string	"US"	Google Trends geo code
timeRange	enum	"today 12-m"	Trend window
fetchMode	enum	"serpapi"	Data source (keep serpapi)

At least one of keywords / keywordsText is required.

Example input

{
  "keywords": ["ai seo tools", "chatgpt", "vibe coding", "content marketing"],
  "geo": "US",
  "timeRange": "today 12-m",
  "fetchMode": "serpapi",
  "serpApiKey": "@SERPAPI_KEY",
  "postsPerWeek": 3,
  "calendarWeeks": 8,
  "contentFormats": ["blog", "video"]
}

More in examples/.

---

Output

One dataset row per scheduled slot:

{
  "publishDate": "2026-06-15",
  "weekNumber": 1,
  "keyword": "ai seo tools",
  "contentFormat": "blog",
  "contentType": "News/explainer article",
  "headlineIdea": "AI SEO tools explained: the trend everyone is searching this week",
  "contentAngle": "Publish a fast-response piece while interest is surging.",
  "priority": "urgent",
  "rationale": "Breakout signal (+46% growth, TrendPulse 58). Publish ASAP to capture the surge before it peaks.",
  "trendStatus": "breakout",
  "trendPulseScore": 57.86,
  "growthPercentage": 46.38,
  "currentAverageInterest": 59.12,
  "relatedQueries": ["best ai seo tools", "ai seo tools 2026"],
  "risingQueries": ["ai seo tools alternatives"],
  "geo": "US",
  "timeRange": "today 12-m",
  "source": "google-trends-serpapi",
  "generatedAt": "2026-06-14T01:43:23.649Z"
}

Key-value store outputs

• SUMMARY — totals, slots by priority + format, what's urgent this week
• CALENDAR — the full slot list
• URGENT_NOW — breakout slots to publish first
• THIS_WEEK — everything scheduled in week 1
• ERRORS — keywords that failed to fetch

---

Pricing and billing

Base result price checked September 14, 2026: $1.00 per 1,000 dataset items ($0.001 each). 100 result items cost $0.10 in result fees.

The separate Actor start event is $0.00005 per billable start unit, with one unit per GB of configured memory and a minimum of one. It applies even when a run returns no results.

Each generated calendar slot is a dataset item. SerpApi access is configured separately; its current quota and fees are determined by SerpApi.

The live Pricing tab is authoritative for current rates, tier discounts and any separately charged usage. Set a maximum run charge and inspect a small sample before scaling. Charges from an external provider, where used, are not controlled by the Apify run-charge limit.

Limitations & honesty

• Google Trends scores are normalized estimates, not absolute search volumes — comparable within a (geo, time range) window, not across windows.
• The calendar is a prioritized starting point, not a guarantee. Trends can shift after you plan.
• Keywords with too little data are skipped (reported in SUMMARY.keywordsSkippedNoData).
• Headlines are deterministic templates, not LLM output — edit them to your brand voice.

---

FAQ

Q: Do I need a SerpApi key? A: A SerpApi key is required. Provider quotas and plan availability can change; check your account before running a large keyword list.

Q: Can I plan a full quarter? A: Yes — set calendarWeeks up to 52 and postsPerWeek up to 14.

Q: What if I have more keywords than slots? A: The strongest keywords (by trend tier + TrendPulse score) fill the available slots; the rest are dropped and logged. Increase calendarWeeks / postsPerWeek to schedule more.

Q: Related tool? A: For pure ranking/monitoring without scheduling, see TrendPulse Keyword Monitor.

---

Changelog

See CHANGELOG.md.