Generate SEO content outlines from SERP analysis with OpenAI and Google Docs
UnknownWhat this workflow does
This AI workflow has 9 nodes and runs when someone submits an n8n form (“SEO SERP Analyzer - 競合分析ツール”). Along the way it connects OpenAI, Google Docs, Google Sheets and Apify (community).
How it runs
Trigger: When someone submits an n8n form (“SEO SERP Analyzer - 競合分析ツール”).
- Workflow Configuration (Edit Fields (Set)): sets 2 fields: maxResults, countryCode
- Store Form Responses (Google Sheets): append or update
- Google Search SERP (Apify): uses Apify
- Filter: keeps only the items that match a condition
- Scrape Article Headings (Apify): uses Apify
- Aggregate: combines items into one
- AI Content Structure Analysis (OpenAI): message
- Create Google Doc (Google Docs): uses Google Docs
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Google Search SERP, Scrape Article Headings).
Nodes used (8)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - Apify
@apify/n8n-nodes-apify.apify - Filter
n8n-nodes-base.filter - Aggregate
n8n-nodes-base.aggregate - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Docs
n8n-nodes-base.googleDocs - Google Sheets
n8n-nodes-base.googleSheets
From the author
Generate SEO content outlines from SERP analysis to Google Docs Overview Stop wasting hours on manual competitor research and content briefing. This workflow automates the creation of data-backed content briefs by analyzing the current top-ranking pages for…