# Plan weekly SEO content from Google Trends and news with Apify, OpenAI and Google Sheets

> Quick overview This workflow runs weekly (or on demand via an n8n form) to pull rising Google Trends searches and related Google News via Apify, scores and briefs them, uses OpenAI to generate structured content ideas, then appends them to a Google Sheets content calendar and emails a ranked digest via Gmail. How it works 1. Runs every Monday at 8:00 or when a user submits the n8n form with topics, country, and an optional email address. 2. Calls Apify’s Google Trends API to fetch related rising queries for the topics, filters irrelevant breakouts, and skips searches already used in previous executions. 3. Selects a balanced set of this week’s best new searches across topics and stops if there are no new trends to cover. 4. Calls Apify’s Google News Scraper to collect recent articles for each selected search and computes a priority score from growth, press coverage, and topic momentum. 5. Sends a fact-only brief to OpenAI (gpt-5-mini) and parses a structured response containing one con

- **Domain**: `n8n-workflow-20847.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20847
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20847.n8n.io
- Documentation: https://n8n.io/workflows/20847