Analyze competitor content gaps with Gemini AI, Apify & Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 18 nodes and runs when an HTTP GET request hits its webhook URL. Along the way it connects Google Gemini Chat Model, Google Sheets, Gmail and Apify (community).
How it runs
Trigger: When an HTTP GET request hits its webhook URL.
- Submission form (Respond to Webhook): sends the response back to the webhook caller
- Prepare Apify Input (Code): runs custom JavaScript code
- Check if the data exist (If): checks a condition and branches into true / false
- Crawl Competitor Website (Apify): uses Apify
- Save Data Of The request (Google Sheets): append
- Fetch Crawled Dataset (HTTP Request): calls an HTTP API
- Extract Page Metadata (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: Analyze Page Content
- Parse and Normalize Gemini JSON (Code): runs custom JavaScript code
- Derive Sheet Name (Code): runs custom JavaScript code
…plus 6 more steps. See the full node list below.
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 Crawl Competitor Website).
Nodes used (12)
- AI Agent
@n8n/n8n-nodes-langchain.agent - Code
n8n-nodes-base.code - Apify
@apify/n8n-nodes-apify.apify - HTTP Request
n8n-nodes-base.httpRequest - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook - Edit Fields (Set)
n8n-nodes-base.set
From the author
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Capture More Traffic: AI-Mapped Topics & Keywords Stay ahead of competitors by uncovering their content strategies automatically. This workflow crawls…