Templates / Route and log ops requests with Jev, Google Sheets, Gmail, Telegram and OpenAI

Route and log ops requests with Jev, Google Sheets, Gmail, Telegram and OpenAI

Unknown

by Khairul Muhtadin ✓ · 48 views · created 2026-09-24 · Document Extraction, AI Summarization

Unknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 42 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Gmail, Google Sheets, Telegram and OpenAI Chat Model and 1 more.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).

Normalize Ops Request (Edit Fields (Set)): sets 6 fields: run_id, received_at, requester…
Read Jev Console Log (Google Sheets): uses Google Sheets
Request Text Usable? (If): checks a condition and branches into true / false
Summarize: summarizes / groups the items
Jev Classify Request Type (Jev Classification): uses Jev Classification
Mark Unusable Request (Edit Fields (Set)): sets 11 fields: run_id, received_at, requester…
Draft Weekly Console Report (AI Agent): runs an AI agent, with model: Console Report Chat Model
Route Vendor Invoice Request (Edit Fields (Set)): sets 10 fields: run_id, received_at, stage…
Route Incident Request (Edit Fields (Set)): sets 10 fields: run_id, received_at, stage…
Route User Report Request (Edit Fields (Set)): sets 10 fields: run_id, received_at, stage…

…plus 29 more steps. See the full node list below.

Services it uses

Gmail Google Sheets Telegram OpenAI Chat ModelJev Classification (community)

Before you upgrade to n8n 3.0

We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).

Check that n8n-nodes-jev-classification is verified or supports 3.0 (used in Jev Classify Request Type, Jev Ask Invoice Fields, Jev Score Incident Urgency).

Nodes used (11)

Webhookn8n-nodes-base.webhook
Edit Fields (Set)n8n-nodes-base.set
Ifn8n-nodes-base.if
Gmailn8n-nodes-base.gmail
Jev Classificationn8n-nodes-jev-classification.jevClassification
Google Sheetsn8n-nodes-base.googleSheets
Telegramn8n-nodes-base.telegram
Schedule Triggern8n-nodes-base.scheduleTrigger
Summarizen8n-nodes-base.summarize
AI Agent@n8n/n8n-nodes-langchain.agent
OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi

From the author

Quick overview This workflow receives operations requests via webhook, uses Jev (TypeSafe) to classify and evaluate them, logs outcomes to Google Sheets, and notifies teams via Gmail and Telegram, then generates a weekly route summary using OpenAI and emails…
Excerpt from Khairul Muhtadin's description on n8n.io.

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

Route and log ops requests with Jev, Google Sheets, Gmail, Telegram and OpenAI

What this workflow does

How it runs

Services it uses

Before you upgrade to n8n 3.0

Nodes used (11)

From the author

Get the weekly “what broke” email