Monitor and alert stalled deals in Zoho CRM with Gemini AI and Gmail

by WeblineIndia ✓ · 46 views · created 2025-12-22 · CRM, AI Summarization

What this workflow does

This AI workflow has 12 nodes and runs on a schedule (every week at 09:00). Along the way it connects Google Gemini Chat Model and Gmail. It also calls zohoapis.com over HTTP.

How it runs

Trigger: On a schedule (every week at 09:00).

1. Edit Fields (Edit Fields (Set)): sets or maps fields
2. Fetch Active Deals From Zoho (HTTP Request): calls an HTTP API
3. Split Deals Into Individual Items (Split Out): splits a list into separate items
4. Calculate Deal Metrics - Deal Inactivitu and Stage Age (Code): runs custom JavaScript code
5. Filter stalled Deals (If): checks a condition and branches into true / false
6. AI Deal Health Scoring (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model; output parser: Structured Output Parser
7. Is Deal At-Risk? (If): checks a condition and branches into true / false
8. Send At-Risk Alert Email (Gmail): uses Gmail
9. Create At-Risk Task (Zoho CRM) (HTTP Request): calls zohoapis.com (POST)

Services it uses

Google Gemini Chat ModelGmail

HTTP calls to: zohoapis.com

Before you upgrade to n8n 3.0

Nodes used (10)

• HTTP Requestn8n-nodes-base.httpRequest
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Ifn8n-nodes-base.if
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Split Outn8n-nodes-base.splitOut
• Coden8n-nodes-base.code
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Gmailn8n-nodes-base.gmail
• Edit Fields (Set)n8n-nodes-base.set

From the author

Zoho CRM – Deal Health Predictor with AI Scoring This n8n automation monitors open Zoho CRM Deals every week, identifies stalled opportunities, scores their health using Google Gemini AI and triggers sales intervention by emailing the deal owner and creating…

View the original on n8n.io → Check your own copy