# Benchmark procurement KPIs with Google Sheets, Gmail, and Google Gemini

> Quick Overview This workflow runs monthly to benchmark procurement KPI results stored in Google Sheets against external peer benchmarks, calculates gap and severity, uses Google Gemini to generate management-ready analysis, writes results back to Google Sheets, and emails leadership alerts and a consolidated monthly report via Gmail. How it works 1. Runs on a monthly schedule trigger. 2. Loads benchmarking settings and fetches all procurement KPI rows marked Ready from Google Sheets. 3. For each KPI, looks up the active KPI definition and active external benchmark in Google Sheets, and routes missing items to Review Required. 4. Builds a comparison context, validates numeric inputs, and calculates the benchmark gap percentage, performance status, and severity. 5. Sends the KPI context and calculated results to Google Gemini to generate a structured gap summary, likely causes, recommended actions, and a management comment. 6. Appends the completed benchmark result to a Google Sheets res

- **Domain**: `n8n-workflow-20454.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20454
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20454.n8n.io
- Documentation: https://n8n.io/workflows/20454