n8n Workflow: Rank Supplier Bids with MySQL, Groq LLM, Notion & Gmail

Rank supplier bids faster—using MySQL data, Groq AI scoring, and automatic Notion + Gmail reporting

This n8n workflow manually runs an AI-assisted procurement pipeline that pulls submitted supplier bids from MySQL, normalizes pricing with FreeCurrencyAPI exchange rates, evaluates proposal text with Groq LLM, ranks suppliers across multiple scenarios, then logs top results in Notion and emails an executive summary via Gmail.

What this workflow does

• Starts with a manual trigger in n8n.
• Fetches live exchange rates from FreeCurrencyAPI and retrieves submitted bids for a specific RFP (based on configured MySQL table and status/RFP filters).
• Normalizes each bid: converts quoted prices to USD, converts delivery durations to days, and anonymizes suppliers using blind aliases.
• Uses Groq-hosted LLM to score qualitative proposal text and compliance certifications into structured SLA, support, compliance, and risk scores.
• Applies a risk penalty, calculates weighted rankings for multiple scenarios (standard, cost optimized, risk averse, and speed to market), and outputs only the top three suppliers.
• Creates a Notion database page per shortlisted supplier with key metrics and the AI justification.
• Generates a structured executive procurement summary with the Groq LLM, converts markdown to HTML, and sends it via Gmail.

Use cases

• Procurement teams comparing vendor bids and compliance evidence for RFPs.
• Automation engineers building repeatable supplier ranking workflows with human-controlled execution.
• SaaS operators who need consistent executive summaries and decision-ready scoring across bids.

Technical details

• MySQL node: reads submitted bids using configurable table name and RFP/status filters.
• FreeCurrencyAPI: retrieves exchange rates (requires your apikey included as a query parameter).
• Groq LLM: transforms proposal text + certifications into structured SLA/support/compliance/risk scores and an executive summary.
• Notion: writes results to a database page for each top supplier.
• Gmail: emails the HTML report to stakeholders.
• Workflow logic uses nodes such as if, set, code, wait, plus notification/output steps.