Personalized lead nurturing with GPT-4.1 based on commitment scoring via Google Sheets

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: