Clean company names for cold emails with GPT-4 Mini and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 9 nodes and runs when someone submits an n8n form (“Clean Up Company Names”). Along the way it connects Google Sheets and OpenAI Chat Model.
How it runs
Trigger: When someone submits an n8n form (“Clean Up Company Names”).
- Create Destination Sheet (Google Sheets): create
- Get Leads (Google Sheets): uses Google Sheets
- Clean Company Name (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Merge: merges the data from its input branches
- Edit Fields (Edit Fields (Set)): sets 1 field: Clean Company Name
- Save Output (Google Sheets): append
Services it uses
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 (7)
- Google Sheets
n8n-nodes-base.googleSheets - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set - n8n Form Trigger
n8n-nodes-base.formTrigger
From the author
Overview In cold email campaigns, the lead's company name is the 2nd most frequently inserted variable after their first name. They're critical for effective cold email personalization. However, company names are often messy and can contain taglines, legal…