Automate Google Sheets Lead Enrichment with GPT-4o-mini & Gmail Draft

Turn new Google Sheets leads into ready-to-send Gmail drafts—automatically

This n8n automation workflow continuously watches your Google Sheets for new or updated lead rows, uses GPT-4o-mini to generate a short company summary and automation value proposition, and then creates a personalized Gmail draft. Finally, it writes the AI output and draft status back to your sheet—saving you time while keeping outreach consistent.

What this workflow does

• Polls Google Sheets every minute for new or updated rows in the selected worksheet.
• Extracts lead fields—including the lead’s Company and Industry.
• Generates AI content with GPT-4o-mini: a two-sentence company summary plus an automation-focused value proposition.
• Creates a Gmail draft email addressed to the lead, using the AI-generated text and a company-specific subject line.
• Updates the originating row in Google Sheets with the AI Summary and sets Status to “Draft Created.”

Use cases

• SaaS sales ops: Enrich and draft outreach emails for every newly imported lead without manual copywriting.
• Automation engineers: Validate a reliable lead-enrichment pipeline that ties Google Sheets → OpenAI → Gmail → Sheets together.
• Founder-led outreach: Maintain a structured lead tracker while generating tailored drafts for each company and industry.

Technical details

• Google Sheets Trigger to detect new/updated rows on a 1-minute polling schedule.
• OpenAI (GPT-4o-mini) via n8nn8n-nodes-langchainopenai to produce the two-sentence summary and value proposition.
• Gmail integration to draft the personalized outreach email.
• Google Sheets update action to write back AI Summary and set Status to “Draft Created.”
• Example required columns include: FirstName, Company, Industry, Status, and AI Summary.

Setup tip: Add valid credentials for Google Sheets, OpenAI, and Gmail in n8n, then select your target spreadsheet and worksheet in both the trigger and update steps.