Back to Templates

Personalized Lead Nurturing with GPT-4.1 Based on Commitment Scoring via Google Sheets

Created by

Created by: Matthew || matthew-synteria

Matthew

Last update

Last update 2 days ago

Share


AI-Powered Personalized Email Nurturing

This workflow automates sending tailored onboarding and follow-up emails based on lead commitment levels. It's designed for coaches, consultants, and service-based businesses who want to personalize their outreach and nurture prospects more effectively.


How It Works

  1. Triggered by New Data: The workflow automatically starts whenever a new row is added to your specified Google Sheet.
  2. Assess Commitment: An If node checks the "Commitment" score from your Google Sheet data.
    • If the commitment score is 8 or higher, the lead is considered "warm" and receives a detailed onboarding email.
    • If the commitment score is below 8, the lead is considered "colder" and receives a gentle nudge email.
  3. Craft Warm Email (for high commitment): For "warm" leads, an OpenAI node generates an aspirational and confident first-touch email. This email highlights their goals, introduces your flagship offers, and invites them to a 30-minute discovery call.
  4. Craft Colder Email (for lower commitment): For "colder" leads, a different OpenAI node generates an encouraging, non-pushy follow-up email. This email thanks them for sharing their goals, reinspires them with the ROI of personal branding, asks a reflective question, and offers a no-pressure Q&A session.
  5. Send Emails: The appropriate Gmail node sends the personalized email to the lead.
  6. Record Activity: Finally, the Google Sheets node appends the lead's information and details of the sent email to a separate "Contacts" sheet, keeping a clear record of all interactions.

Google Sheet Structure

Your primary Google Sheet (the one triggering the workflow) must have the following exact column headers:

  • Email
  • First name
  • Last name
  • Phone number
  • Industry
  • Title
  • Three goals you wish to achieve this year
  • 1-10 how commited are you to your goals

Your secondary Google Sheet (for appending contacts) must have these exact column headers:

  • name
  • email
  • phone
  • industry
  • title
  • three goals
  • commitment

Setup Instructions

  1. Add Credentials:

    • In n8n, add your OpenAI API key via the Credentials menu.
    • Connect your Google account via the Credentials menu for Google Sheets and Gmail access.
  2. Configure Google Sheets Trigger:

    • Select the Google Sheets Trigger node.
    • Choose your Google Sheets credential, select your spreadsheet, and the specific sheet name that contains your incoming lead data.
  3. Configure Commitment Logic:

    • Select the Commitment ≥ 8? If node.
    • The condition is set to ={{ $json['1-10 how commited are you to your goals'] }} >= 8. Ensure your Google Sheet column name for commitment matches exactly, including spacing and capitalization.
  4. Configure OpenAI Nodes:

    • Select both crafting warmer email and crafting colder email nodes.
    • Choose your OpenAI credential from the dropdown.
    • Crucially: In both nodes' Messages section, replace placeholder information with your actual company name, founder name, and any specific details about your flagship offers and booking links (https://calendly.com/brandied/discovery).
  5. Configure Gmail Nodes:

    • Select both Send warmer email and Send colder email nodes.
    • Choose your Gmail credential.
  6. Configure Append Row in Sheet:

    • Select the Append row in sheet node.
    • Choose your Google Sheets credential, select the spreadsheet and sheet name where you want to log sent emails (your "Contacts" sheet).
    • Verify that the column mappings correctly align with the "Google Sheet Structure" for your secondary sheet.

Customization Options 💡

  • Commitment Threshold: Adjust the number in the Commitment ≥ 8? If node to change what constitutes a "warm" lead (e.g., gte 7 for a commitment score of 7 or higher).
  • Email Content & Tone: Modify the prompts in the crafting warmer email and crafting colder email OpenAI nodes to fine-tune the email tone, length, specific calls to action, or any other elements to better suit your brand voice and strategy.
  • Follow-Up Cadence: Instead of immediate sending, you could introduce a Wait node after the email crafting to space out follow-ups or integrate with an email sequence tool.
  • CRM Integration: Replace the final Google Sheets node with an integration to your CRM (e.g., HubSpot, Salesforce) to automatically log these interactions and enrich lead profiles directly within your CRM.