Generate AI sales pitches from website URLs with GPT-4o and 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 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI, Google Sheets and Firecrawl (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fetch website URL from sheet (Google Sheets): uses Google Sheets
- Loop over URLs (Loop Over Items (Split in Batches)): loops over the items in batches
- Scrape website and get its content (Firecrawl): scrape
- Personalize Message (OpenAI): uses OpenAI
- Shape output (Edit Fields) (Edit Fields (Set)): sets 1 field: Personalized Message
- Wait: waits 2 seconds
- Update sheet with personalized message (Google Sheets): append or update
Services it uses
Uses Firecrawl. New users get 10% off with our link.
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 @mendable/n8n-nodes-firecrawl is verified or supports 3.0 (used in Scrape website and get its content).
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Wait
n8n-nodes-base.wait - No Operation, do nothing
n8n-nodes-base.noOp - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Firecrawl
@mendable/n8n-nodes-firecrawl.firecrawl
From the author
Overview This n8n workflow converts a simple list of website URLs in Google Sheets into a concise, consultative Context + AI pitch for each organization. It scrapes real page content (markdown preferred), feeds it to OpenAI with tight prompts to avoid fluff,…