Score and route property enquiries with Groq, Google Sheets, and Gmail
Ready for 3.0What this workflow does
This workflow has 13 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and Gmail. It also calls api.groq.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- If: checks a condition and branches into true / false
- Classify Enquirer Type (Code): runs custom JavaScript code
- Append Incomplete Enquiry to Sheets (Google Sheets): append
- Post to Groq AI for Intent Score (HTTP Request): calls api.groq.com (POST)
- Respond 400 Missing Email (Respond to Webhook): sends the response back to the webhook caller
- Integrate AI Score with Enquiry (Code): runs custom JavaScript code
- Fallback Buying Intent Score (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Update Personal Leads in Sheets (Google Sheets): append or update
- Update Business Leads in Sheets (Google Sheets): append or update
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: api.groq.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
Quick overview This workflow receives property enquiries via a webhook, validates and classifies them as Personal or Business, scores buying intent with Groq (LLM), then saves the lead to the appropriate Google Sheets tracker and alerts agents via Gmail. How…