Monitor Zoho CRM changes & alert on suspicious activity with Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 13 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Compute Time Window (Function): runs custom JavaScript (legacy Function node)
- SET - Workflow Config (Edit Fields (Set)): sets or maps fields
- Zoho: List Modules (HTTP Request): calls an HTTP API
- Prepare Modules List (Function): runs custom JavaScript (legacy Function node)
- Zoho: Search Module Records (HTTP Request): calls an HTTP API
- Normalize Module Records (Function): runs custom JavaScript (legacy Function node)
- Analyze for Suspicious Activity (Function): runs custom JavaScript (legacy Function node)
- Create Audit Attachment (JSON) (Function): runs custom JavaScript (legacy Function node)
- Log to Google Sheet (append/update) (Google Sheets): append or update
- Check Suspicious? (If) (If): checks a condition and branches into true / false
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Function (legacy) in Compute Time Window, Prepare Modules List, Normalize Module Records…: replace with Code node, mode 'Run Once for All Items'.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Compute Time Window, Prepare Modules List, Normalize Module Records, Analyze for Suspicious Activity, Create Audit Attachment (JSON), Update lastRun (staticData) | Code node, mode 'Run Once for All Items' |
Nodes used (7)
- Function
n8n-nodes-base.function - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
📄 Zoho CRM Change Tracking & Automated Suspicious Activity Alerts Workflow This n8n workflow automatically monitors selected Zoho CRM modules for record changes, identifies suspicious modification patterns, logs all activity into a Google Sheet, generates an…