Plan weekly SEO content from Google Trends and news with Apify, OpenAI and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 19 nodes and runs on a schedule (every week at 08:00) (plus 1 other trigger). Along the way it connects OpenAI Chat Model, Google Sheets and Gmail. It also calls api.apify.com over HTTP.
How it runs
Trigger: On a schedule (every week at 08:00) (plus 1 other trigger).
- Your settings (Edit Fields (Set)): sets 6 fields: topics, country, audience…
- Get rising searches (HTTP Request): calls api.apify.com (POST)
- Find rising searches (Code): runs custom JavaScript code
- Skip searches already covered (Remove Duplicates): removes duplicate items
- Pick this week's searches (Code): runs custom JavaScript code
- Anything rising? (If): checks a condition and branches into true / false
- Find the news behind each search (HTTP Request): calls api.apify.com (POST)
- Score trends and build the AI brief (Code): runs custom JavaScript code
- Write content ideas (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model; output parser: Ideas format
- One item per idea (Split Out): splits a list into separate items
…plus 4 more steps. See the full node list below.
Services it uses
HTTP calls to: api.apify.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (14)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Remove Duplicates
n8n-nodes-base.removeDuplicates - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Split Out
n8n-nodes-base.splitOut - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail
From the author
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…