Classify purchase requisitions with Google Gemini, Gmail, Slack and Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 15 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Gemini Chat Model, Gmail, Google Sheets and Slack.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Validate & Normalize PR Data (Code): runs custom JavaScript code
- AI: Categorize Purchase Requisition (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model
- Merge: merges the data from its input branches
- Parse AI Classification Result (Code): runs custom JavaScript code
- Store Procurement Record (Google Sheets): append
- Calculate Classification Confidence (Code): runs custom JavaScript code
- Notify Procurement Approver (Gmail): uses Gmail
- Send Procurement Slack Alert (Slack): uses Slack
- Check Auto Approval Eligibility (If): checks a condition and branches into true / false
- Set Final Procurement Category (Edit Fields (Set)): sets 3 fields: approval_status, routing_status, processed_timestamp
…plus 3 more steps. See the full node list below.
Services it uses
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 (10)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Gmail
n8n-nodes-base.gmail - Edit Fields (Set)
n8n-nodes-base.set - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack
From the author
Quick overview This workflow receives purchase requisitions via a webhook, validates and normalizes the payload, uses Google Gemini to classify the requisition into a procurement category with confidence and risk signals, then routes for auto-approval or…