Automate Gmail lead follow-up with OpenAI GPT-4O, HubSpot, Slack & Google Sheets

How it works

This workflow automates the handling of new lead responses received in Gmail. It captures emails with a specific label, analyzes the message using AI to determine sentiment, intent, urgency, next action, and priority, and then decides whether follow-up is needed. If required, it creates tasks in HubSpot, notifies the sales team via Slack, and logs all details into Google Sheets for tracking.

Step-by-step

Trigger on New Lead Email

• Workflow starts whenever a new email with a defined Gmail label arrives.

• Captures the sender’s email, subject, message snippet, and timestamp.

Normalize Email Data

• Standardizes Gmail fields into structured values:

  • leadEmail (sender’s address)

  • subject (email subject)

  • message (email content snippet)

  • source (Gmail)

  • receivedAt (timestamp)

AI-Powered Lead Analysis

• Uses OpenAI to analyze the lead’s message.

• Extracts:

  • Sentiment (Positive / Neutral / Negative)

  • Intent (Interested, Not Interested, Needs Info, Ready to Buy, Objection)

  • Urgency (High / Medium / Low)

  • Next Action (Call, Email, Demo, Quote, No Action)

  • Summary (1–2 sentence description)

  • Priority (Hot / Warm / Cold)

• Parsed results are merged with the original email data.

• Flags are added:

  • needsFollowUp (true/false)

  • isHighPriority (true/false)

Decision: Needs Follow-Up?

• If AI suggests a follow-up action, the workflow continues.

• Otherwise, the process stops here.

Create HubSpot Task

• Automatically creates a HubSpot CRM task for the sales team.

• Task includes email subject, body, and lead details.

Notify Sales Team on Slack

• Sends a formatted message to Slack with key lead insights:

  • Summary

  • Lead email

  • Priority

  • Urgency

  • Date of analysis

Log Lead Data to Google Sheets

• Appends structured data to Google Sheets for record-keeping.

• Stores all fields: Email, Date, Subject, Message, Sentiment, Intent, Urgency, Next Action, Summary, and Priority.

Why use this?

• Automates lead triage directly from Gmail.

• Saves time by using AI-powered analysis instead of manual review.

• Ensures no potential lead is missed by logging into Google Sheets.

• Provides instant sales team alerts on high-priority leads.

• Integrates seamlessly with HubSpot CRM for structured follow-up.

• Keeps your sales pipeline efficient, organized, and proactive.