{"product_id":"n8n-workflow-procurement-kpi-benchmarking-with-sheets-gemini","title":"n8n Workflow: Procurement KPI Benchmarking with Sheets \u0026 Gemini","description":"\u003ch3\u003eBenchmark your Procurement KPIs against external peers—automatically, monthly, and with Gemini insights\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs on a monthly schedule to compare procurement KPI results in \u003cb\u003eGoogle Sheets\u003c\/b\u003e with external peer benchmarks, calculate KPI gaps and severity, generate management-ready analysis using \u003cb\u003eGoogle Gemini\u003c\/b\u003e, write results back to Sheets, and email leadership alerts plus a consolidated monthly report via \u003cb\u003eGmail\u003c\/b\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns monthly\u003c\/b\u003e using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLoads benchmarking settings\u003c\/b\u003e and fetches all procurement KPI rows marked \u003cb\u003eReady\u003c\/b\u003e from your Google Sheets (starting from the \u003cb\u003eProcurement_KPIs\u003c\/b\u003e tab).\u003c\/li\u003e\n  \u003cli\u003eFor each KPI, checks the \u003cb\u003eactive KPI definition\u003c\/b\u003e and \u003cb\u003eactive external benchmark\u003c\/b\u003e from Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eIf required benchmark inputs are missing or not active, routes the KPI to \u003cb\u003eReview Required\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eBuilds a comparison context\u003c\/b\u003e, validates numeric inputs, and calculates:\n    \u003cul\u003e\n      \u003cli\u003eBenchmark gap percentage\u003c\/li\u003e\n      \u003cli\u003ePerformance status\u003c\/li\u003e\n      \u003cli\u003eSeverity\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eSends the KPI context and calculated results to \u003cb\u003eGoogle Gemini\u003c\/b\u003e to generate structured output such as \u003cb\u003egap summary\u003c\/b\u003e, \u003cb\u003elikely causes\u003c\/b\u003e, \u003cb\u003erecommended actions\u003c\/b\u003e, and a \u003cb\u003emanagement comment\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAppends results\u003c\/b\u003e to a results sheet and marks the source KPI row as \u003cb\u003eProcessed\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eEmails leadership alerts\u003c\/b\u003e when a KPI is below benchmark and sends an \u003cb\u003eHTML monthly benchmark report\u003c\/b\u003e covering all processed KPIs via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonthly procurement performance reviews where teams need consistent KPI benchmarking.\u003c\/li\u003e\n  \u003cli\u003eAutomated identification of underperforming KPIs with severity scoring and AI-generated commentary.\u003c\/li\u003e\n  \u003cli\u003eOperational reporting for SaaS operators and automation engineers who want a repeatable procurement KPI benchmarking pipeline.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e Google Sheets, Gmail, Google Gemini (PaLM\/AI Studio).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes used:\u003c\/b\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, plus workflow annotations (sticky note).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRequired sheets\/tabs:\u003c\/b\u003e \u003ccode\u003eProcurement_KPIs\u003c\/code\u003e, \u003ccode\u003eKPI_Definitions\u003c\/code\u003e, \u003ccode\u003eExternal_Benchmarks\u003c\/code\u003e, and the benchmark results tab (“Bench…” as expected by the workflow).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSetup step:\u003c\/b\u003e connect credentials for Google Sheets, Gmail, and Google Gemini in n8n, then align your sheet structure with the workflow’s expected layout.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192874324147,"sku":"N8N-20454","price":63.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/rtBKoQgv5JlFYdSFB4693_CaxxeeVP.png?v=1791537934","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-procurement-kpi-benchmarking-with-sheets-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}