Draft cold email templates from Google Sheets with OpenAI and Gmail

by Jessy Mariau ✓ · 6 views · created 2026-09-07

What this workflow does

This AI workflow has 15 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets, OpenAI Chat Model and Gmail.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

1. Outreach Settings (Edit Fields (Set)): sets or maps fields
2. Get Sent Log (Data table): uses Data table
3. Read Leads Sheet (Google Sheets): uses Google Sheets
4. Normalize Lead Fields (Edit Fields (Set)): sets or maps fields
5. Skip Suppressed Leads (Data table): uses Data table
6. Apply Cooldown Filter (Code): runs custom JavaScript code
7. Cap Drafts Per Run (Limit): keeps the first few items
8. Draft Personalised Email (Information Extractor): extracts structured fields from text with AI, with model: Drafting Model
9. Prepare Reviewed Draft (Code): runs custom JavaScript code
10. Create Gmail Draft (Gmail): uses Gmail

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

Services it uses

Google SheetsOpenAI Chat ModelGmail

Before you upgrade to n8n 3.0

Nodes used (10)

• Manual Triggern8n-nodes-base.manualTrigger
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Data tablen8n-nodes-base.dataTable
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• Limitn8n-nodes-base.limit
• Information Extractor@n8n/n8n-nodes-langchain.informationExtractor
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Gmailn8n-nodes-base.gmail

From the author

Quick overview This workflow runs manually or weekly to read leads from Google Sheets, filters them against an n8n Data Table suppression list and a cooldown log, drafts short personalised cold emails with OpenAI, creates Gmail drafts for review, and records…

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