Sheets lead scoring to HighLevel CRM

New Google Sheet rows scored by Azure OpenAI and sent to HighLevel. This n8n template uses a Google Sheets trigger for new form rows. An AI agent with Azure OpenAI GPT-4o-mini analyzes lead details such as value, stage and company and generates action items. The response is parsed into clean JSON and logged to a Lead Status sheet, and leads are categorized as Hot, Warm or Cold based on the AI scoring. The contact is created or updated in HighLevel CRM and an SMTP email notifies sales reps. The sheet needs six named headers, from Lead Name to Stage of Lead. It suits teams that already collect leads in a spreadsheet.

n8nRead on 2026-11-167 steps

Steps

  1. Trigger: Monitors a Google Sheet for new submissionsGoogle Sheets
  2. Azure OpenAI analyzes the lead detailsAzure OpenAI
    GPT-4o-mini; value, stage, company; action items.
  3. Parses the AI response into JSON
  4. Saves the lead to the lead Status sheetGoogle Sheets
  5. Categorizes leads Hot, Warm or Cold
  6. Creates or updates the HighLevel contactHighLevel
  7. Output: Emails the assigned sales repEmail (SMTP)
    Lead details and priority.

Limits

  • The Google Sheet needs six named headers.

What it does well

  • The Hot, Warm or Cold label comes from the AI scoring.

Before you import

Import the workflow, update the node settings and run a test submission.

Similar templates