Route supplier risk alerts from Gmail to Slack with Gemini and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 13 nodes and runs on Gmail events. Along the way it connects Gmail, Google Gemini, Slack and Google Sheets.
How it runs
Trigger: On Gmail events.
- Filter Valid Supplier Emails (If): checks a condition and branches into true / false
- Structure Email Data (Code): runs custom JavaScript code
- Data Processing Buffer (Wait): waits 2 seconds
- Analyze Sentiment & Intent (Google Gemini): uses Google Gemini
- Extract & Normalize Insights (Edit Fields (Set)): sets 10 fields: sentiment_score, raw_text, sentiment_label…
- Detect Supplier Risk (If): checks a condition and branches into true / false
- Pre-Analysis Pause (Wait): waits 3 seconds
- Generate Engagement Strategy (Google Gemini): uses Google Gemini
- Parse Strategy Output (Code): runs custom JavaScript code
- Build Slack Alert Message (Code): runs custom JavaScript code
…plus 2 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.
- Still check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (Monitor Incoming Emails).
Nodes used (8)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Edit Fields (Set)
n8n-nodes-base.set - Slack
n8n-nodes-base.slack - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait
From the author
Quick overview This workflow monitors incoming Gmail messages from suppliers, uses Google Gemini to analyze sentiment and relationship risk, generates an engagement strategy for risky emails, sends an alert to Slack, and logs the analysis and recommended…