{"product_id":"n8n-workflow-rank-supplier-bids-with-mysql-groq-llm-notion-gmail","title":"n8n Workflow: Rank Supplier Bids with MySQL, Groq LLM, Notion \u0026 Gmail","description":"\u003ch3\u003eRank supplier bids faster—using MySQL data, Groq AI scoring, and automatic Notion + Gmail reporting\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow manually runs an AI-assisted procurement pipeline that pulls submitted supplier bids from \u003cstrong\u003eMySQL\u003c\/strong\u003e, normalizes pricing with \u003cstrong\u003eFreeCurrencyAPI\u003c\/strong\u003e exchange rates, evaluates proposal text with \u003cstrong\u003eGroq LLM\u003c\/strong\u003e, ranks suppliers across multiple scenarios, then logs top results in \u003cstrong\u003eNotion\u003c\/strong\u003e and emails an executive summary via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eStarts with a \u003cstrong\u003emanual trigger\u003c\/strong\u003e in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches live exchange rates\u003c\/strong\u003e from FreeCurrencyAPI and retrieves submitted bids for a specific RFP (based on configured MySQL table and status\/RFP filters).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes each bid\u003c\/strong\u003e: converts quoted prices to \u003cstrong\u003eUSD\u003c\/strong\u003e, converts delivery durations to \u003cstrong\u003edays\u003c\/strong\u003e, and anonymizes suppliers using \u003cstrong\u003eblind aliases\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eGroq-hosted LLM\u003c\/strong\u003e to score qualitative proposal text and compliance certifications into structured \u003cstrong\u003eSLA, support, compliance, and risk scores\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eApplies a \u003cstrong\u003erisk penalty\u003c\/strong\u003e, calculates weighted rankings for multiple scenarios (standard, cost optimized, risk averse, and speed to market), and outputs only the \u003cstrong\u003etop three suppliers\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCreates a \u003cstrong\u003eNotion database page\u003c\/strong\u003e per shortlisted supplier with key metrics and the AI justification.\u003c\/li\u003e\n  \u003cli\u003eGenerates a structured executive procurement summary with the Groq LLM, converts markdown to \u003cstrong\u003eHTML\u003c\/strong\u003e, and sends it via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProcurement teams comparing vendor bids and compliance evidence for RFPs.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building repeatable supplier ranking workflows with human-controlled execution.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who need consistent executive summaries and decision-ready scoring across bids.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMySQL\u003c\/strong\u003e node: reads submitted bids using configurable table name and RFP\/status filters.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFreeCurrencyAPI\u003c\/strong\u003e: retrieves exchange rates (requires your \u003cstrong\u003eapikey\u003c\/strong\u003e included as a query parameter).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroq LLM\u003c\/strong\u003e: transforms proposal text + certifications into structured SLA\/support\/compliance\/risk scores and an executive summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotion\u003c\/strong\u003e: writes results to a database page for each top supplier.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: emails the HTML report to stakeholders.\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic uses nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, plus notification\/output steps.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46063673901235,"sku":"N8N-19711","price":76.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/H7LJhWAf34oyjiXffounO_PhYCqOcv.png?v=1789808955","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-rank-supplier-bids-with-mysql-groq-llm-notion-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}