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. π§Ή