Templates / Generate competitor SEO topical maps with Gemini 2.5 Flash, Olostep and Google Sheets

Generate competitor SEO topical maps with Gemini 2.5 Flash, Olostep and Google Sheets

Unknown

by Yasser Sami ✓ · 81 views · created 2026-05-04 · Market Research, AI Summarization

Unknown. 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 13 nodes and runs when someone submits an n8n form (“Competitor Topical Map Generator”). Along the way it connects Google Gemini, Google Sheets and Olostep (community).

How it runs

Trigger: When someone submits an n8n form (“Competitor Topical Map Generator”).

Get article titles (Olostep Scrape): work with answer
Pillar analyzer (Google Gemini): uses Google Gemini
articles (Split Out): splits a list into separate items
Strategy director (Google Gemini): uses Google Gemini
parse pillers (Edit Fields (Set)): sets 1 field: pillars
Merge: merges the data from its input branches
Parse content gaps (Edit Fields (Set)): sets 1 field: test
pillers (Split Out): splits a list into separate items
Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
content gaps (Split Out): splits a list into separate items

…plus 2 more steps. See the full node list below.

Services it uses

Google Gemini Google SheetsOlostep (community)

Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).

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 n8n-nodes-olostep is verified or supports 3.0 (used in Get article titles).

Nodes used (9)

n8n Form Triggern8n-nodes-base.formTrigger
Olostep Scrapen8n-nodes-olostep.olostepScrape
Google Gemini@n8n/n8n-nodes-langchain.googleGemini
Mergen8n-nodes-base.merge
Google Sheetsn8n-nodes-base.googleSheets
Split Outn8n-nodes-base.splitOut
Edit Fields (Set)n8n-nodes-base.set
Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
Waitn8n-nodes-base.wait

From the author

AI SEO Content Strategy: Competitor Topical Map Generator Crush your competition's SEO strategy by visualizing their entire content architecture in seconds. The AI SEO Content Strategy: Competitor Topical Map Generator workflow automates the "topical mapping"…
Excerpt from Yasser Sami's description on n8n.io.

View the original on n8n.io → Check your own copy

Generate competitor SEO topical maps with Gemini 2.5 Flash, Olostep and Google Sheets

What this workflow does

How it runs

Services it uses

Before you upgrade to n8n 3.0

Nodes used (9)

From the author

Get the weekly “what broke” email