Enrich new leads and write personalized icebreakers with Google Sheets and Claude
Ready for 3.0What this workflow does
This AI workflow has 8 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets and Anthropic Chat Model.
How it runs
Trigger: On Google Sheets events (row added).
- Config (edit me) (Edit Fields (Set)): sets 1 field: icp_definition
- Fetch Prospect Website (HTTP Request): calls an HTTP API
- Extract Page Text (HTML): parses or builds HTML
- Generate Icebreaker + ICP Score (Basic LLM Chain): sends a prompt to an LLM, with model: Anthropic Chat Model; output parser: Structured Output Parser
- Write Results to Sheet (Google Sheets): update
Services it uses
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
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 (8)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - HTTP Request
n8n-nodes-base.httpRequest - HTML
n8n-nodes-base.html - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set
From the author
Quick overview This workflow watches a Google Sheets lead list, fetches each new lead’s website, extracts page text, and uses Anthropic Claude to generate a personalized cold-email icebreaker plus an ICP fit score and reasoning, then writes the results back…