agent-image-lead-qualification-assistant
Auto-Personalized First Touch for New Leads using GPT-4o-mini & Google Sheets
DescriptionGenerate personalized first-touch messages for every new lead β€” automatically. This workflow researches each company using AI, crafts a natural...
screenshot-daily-task-reminder-bot
Created by:
Rahul Joshi
Last Updated:

June 15th 2025

Agent Details:
n8n
OpenAI
general
Google Sheets
Loop Over Items (Split in Batches)
Sticky Note
Description
Description Generate personalized first-touch messages for every new lead β€” automatically. This workflow researches each company using AI, crafts a natural opener referencing their mission or focus, and writes the result back to your Google Sheet. Perfect for SDRs, founders, and marketers who want outreach personalization without the manual work. ✨ What This Template Does Fetches lead data from Google Sheets (e.g., company, geography, category). πŸ“„ Uses Azure OpenAI GPT-4o-mini to research each company’s mission, focus, and audience. 🧠 Generates a 2-sentence personalized message tailored for outreach. πŸ’¬ Parses AI output into structured fields (company info + message). 🧩 Writes the personalized message back to the original sheet for tracking. πŸ’Ύ Runs in batches to process leads one by one efficiently. πŸ” Key Benefits Create authentic, tailored messages for every lead β€” instantly. πŸš€ Save hours of manual research and copywriting. ⏱️ Keep all personalization data centralized in Google Sheets. πŸ“Š Scalable and repeatable for any lead list. ♻️ Uses cost-efficient GPT-4o-mini for fast responses. ⚑ Features Manual or scheduled trigger to process new leads. ▢️ Google Sheets integration for lead data input/output. πŸ”— AI research and personalization via Azure OpenAI GPT-4o-mini. πŸ€– Structured JSON parsing for clean, usable output. ✨ Automatic update to the β€œPersonalised message” column in your sheet. πŸ’¬ Visual documentation with sticky notes for clarity. πŸ—’οΈ Requirements n8n instance (cloud or self-hosted). 🧰 Google Sheet with columns: Account, Geography, Category, Personalised message. πŸ“‘ Azure OpenAI API connection (GPT-4o-mini). ☁️ Google Sheets OAuth credentials linked to n8n. πŸ” Target Audience SDRs and sales teams scaling personalized outreach. 🎯 B2B marketers automating LinkedIn or email personalization. πŸ’Œ Founders or agencies building warm first-touch messages for prospects. 🀝 Step-by-Step Setup Instructions (Concise) Prepare a Google Sheet with required columns. πŸ“‹ Connect Google Sheets credentials in n8n. πŸ”‘ Add your Azure OpenAI connection and set model to GPT-4o-mini. 🧠 Import and test the workflow with a few sample leads. πŸ§ͺ Adjust message tone or structure in the system prompt if needed. 🧩 Run manually or schedule the workflow for automation. ⏰ Security Best Practices Share your Google Sheet only with the n8n service account (Editor access). πŸ”’ Keep API keys and credentials stored securely in n8n. πŸ›‘οΈ Validate AI outputs before using them in outreach tools. βœ… Regularly back up your sheet and clean old data. 🧹

Build Dynamic AI Agents

Join a community of growing Agentic AI Developers.