Evaluate and rank supplier bids with MySQL, Groq LLM, Notion, and Gmail
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 19 nodes and runs manually, when you click “Execute workflow”. Along the way it connects MySQL, Groq Chat Model, Notion and Gmail. It also calls api.freecurrencyapi.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fetch Live Exchange Rates (HTTP Request): calls api.freecurrencyapi.com
- Fetch Submitted Bids (MySQL) (MySQL): select
- Normalize & Anonymize Data (Code): runs custom JavaScript code
- Loop Through Bids (Loop Over Items (Split in Batches)): loops over the items in batches
- Extract Evaluated Scores (Edit Fields (Set)): sets 6 fields: sla_score, support_score, compliance_score…
- AI Proposal Auditor (Basic LLM Chain): sends a prompt to an LLM, with model: Groq LLM (Auditor); output parser: Enforce Scoring Schema
- Check Security Risk (If): checks a condition and branches into true / false
- Wait: pauses before continuing
- Math & Ranking Engine (Code): runs custom JavaScript code
- Log Supplier to Notion (Notion): work with database page
…plus 4 more steps. See the full node list below.
Services it uses
HTTP calls to: api.freecurrencyapi.com
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 (14)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - MySQL
n8n-nodes-base.mySql - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Wait
n8n-nodes-base.wait - Edit Fields (Set)
n8n-nodes-base.set - Notion
n8n-nodes-base.notion - Markdown
n8n-nodes-base.markdown - Gmail
n8n-nodes-base.gmail - If
n8n-nodes-base.if
From the author
Quick overview This workflow manually runs an AI-assisted procurement pipeline that pulls submitted bids from MySQL, converts pricing using FreeCurrencyAPI exchange rates, scores qualitative proposal text with Groq LLMs, ranks suppliers across multiple…