Weekly SEO Content Plan: Apify + OpenAI + Google Sheets (n8n)

Turn Google Trends into a weekly SEO content calendar—automatically

This n8n workflow runs every Monday (or on demand) to pull rising Google Trends searches and related Google News via Apify, generates structured SEO content ideas with OpenAI, appends them to your Google Sheets calendar, and emails you a ranked digest via Gmail.

What this workflow does

• Schedules or triggers: Executes weekly at 8:00 every Monday, or you can run it anytime by submitting the n8n form with topics, a country, and an optional email recipient.
• Fetches rising queries: Uses Apify’s Google Trends API to retrieve related rising searches for your topics, filters irrelevant breakouts, and skips searches already used in previous executions.
• Selects this week’s best targets: Chooses a balanced set across topics and stops early if there are no new trends to cover.
• Scrapes supporting news: Calls Apify’s Google News Scraper for each selected search and computes a priority score based on growth, press coverage, and topic momentum.
• Briefs OpenAI for structured outputs: Sends a fact-only brief to OpenAI (gpt-5-mini) and parses the structured response into one content idea per search (title, format, target search, why now, plus a 3-point outline).
• Publishes to your system: Appends ranked ideas, sources, and tracking fields to Google Sheets, then emails an HTML digest via Gmail.

Use cases

• SaaS SEO teams that need consistent weekly content planning tied to rising Google Trends.
• Automation engineers building an end-to-end SEO content pipeline with Apify + OpenAI + Google Sheets.
• Operators who want a prioritized, source-backed weekly digest sent straight to their inbox.

Technical details

• Apify HTTP requests with Bearer Auth using your Apify API token (used for both Trends API and Google News Scraper).
• OpenAI Chat Model using gpt-5-mini and structured response parsing.
• n8n nodes/logic including: if, set, code, no op, gmail, split out.