{"product_id":"n8n-supplier-shortlisting-workflow-sheets-gemini-gmail","title":"n8n Supplier Shortlisting Workflow: Sheets, Gemini \u0026 Gmail","description":"\u003ch3\u003eShortlist the best suppliers automatically—right from your RFx request\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Supplier Shortlisting Workflow: Sheets, Gemini \u0026amp; Gmail\u003c\/strong\u003e takes an incoming RFx request, matches it to requirements in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, scores candidate suppliers using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e plus a supplier-intelligence API, and then \u003cstrong\u003eemails your top 5\u003c\/strong\u003e while logging everything for auditability.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives an RFx request via webhook:\u003c\/strong\u003e Accepts a \u003ccode\u003ePOST\u003c\/code\u003e payload containing a \u003ccode\u003erequest_id\u003c\/code\u003e (to \u003ccode\u003e\/rfx-request\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls matching RFx requirements from Google Sheets:\u003c\/strong\u003e Filters the \u003cstrong\u003eSourcing_Re\u003c\/strong\u003e (source sheet) to keep only the row where \u003cstrong\u003eRequest_ID\u003c\/strong\u003e matches the incoming \u003ccode\u003erequest_id\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes RFx criteria:\u003c\/strong\u003e Prepares category, country, certification, ESG\/diversity requirements, and search criteria for supplier matching.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFinds candidate suppliers:\u003c\/strong\u003e Queries a \u003cstrong\u003eSupplier_Master\u003c\/strong\u003e Google Sheet using category, country, and certification.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores fit with Google Gemini:\u003c\/strong\u003e Sends combined supplier + RFx data to Gemini and receives a JSON fit assessment (including \u003cstrong\u003eai_fit_score\u003c\/strong\u003e, strength, and recommendation).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches with supplier intelligence:\u003c\/strong\u003e Calls an external \u003cstrong\u003eHTTP supplier-intelligence endpoint\u003c\/strong\u003e to add risk\/financial fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRanks and shortlists:\u003c\/strong\u003e Computes a weighted \u003cstrong\u003efinal_score\u003c\/strong\u003e, sorts suppliers, and keeps the \u003cstrong\u003etop 5\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails and logs results:\u003c\/strong\u003e Sends shortlisted recommendations via \u003cstrong\u003eGmail\u003c\/strong\u003e and appends the outcomes to a \u003cstrong\u003eSupplier_Shortlist_Log\u003c\/strong\u003e Google Sheet for auditing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate supplier selection for RFQs in sourcing operations without manual screening.\u003c\/li\u003e\n  \u003cli\u003eRank vendors using consistent criteria (category, country, certification, ESG\/diversity) and AI fit.\u003c\/li\u003e\n  \u003cli\u003eProvide traceable, email-ready supplier shortlists with a logged decision record.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow nodes:\u003c\/strong\u003e set, code, sort, gmail, limit, merge\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle integrations:\u003c\/strong\u003e Google Sheets (Sourcing_Re, Supplier_Master, Supplier_Shortlist_Log) and \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExternal enrichment:\u003c\/strong\u003e HTTP supplier-intelligence API for risk\/financial fields\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook entry point:\u003c\/strong\u003e \u003ccode\u003e\/rfx-request\u003c\/code\u003e with \u003ccode\u003erequest_id\u003c\/code\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eIdeal for \u003cstrong\u003en8n users\u003c\/strong\u003e, automation engineers, and \u003cstrong\u003eSaaS operators\u003c\/strong\u003e who want an SEO-friendly, production-minded \u003cstrong\u003esupplier shortlisting workflow\u003c\/strong\u003e that combines Sheets data, Gemini scoring, and Gmail outreach.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45865754525875,"sku":"N8N-18396","price":21.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/EP0WGwIqxDcn7Fbdpq1fb_We1D1U6C.png?v=1787043676","url":"https:\/\/buyflowscripts.com\/products\/n8n-supplier-shortlisting-workflow-sheets-gemini-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}