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.
Steps
- Trigger: Monitors a Google Sheet for new submissionsGoogle Sheets
- Azure OpenAI analyzes the lead detailsAzure OpenAI
GPT-4o-mini; value, stage, company; action items. - Parses the AI response into JSON
- Saves the lead to the lead Status sheetGoogle Sheets
- Categorizes leads Hot, Warm or Cold
- Creates or updates the HighLevel contactHighLevel
- 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
Lead scoring with Claude Haiku
Also for sales and leads, 7 steps.
Overdue lead follow-ups with Gemini
Also for sales and leads, 7 steps.
Tally B2B lead scoring with OpenAI
Also for sales and leads, 7 steps.
Azure OpenAI and Google Sheets: 2 templates compared
Same two apps, different steps.
Google Sheets and Email (SMTP): 2 templates compared
Same two apps, different steps.
Capture a lead
Other templates that do this task.