{"product_id":"automate-procurement-spend-classification-in-google-sheets","title":"Automate Procurement Spend Classification in Google Sheets","description":"\u003ch3\u003eAutomate Procurement Spend Classification in Google Sheets with Google Gemini\u003c\/h3\u003e\n\u003cp\u003eStop manually tagging procurement transactions. This n8n workflow reads pending spend records in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to classify each transaction against an approved taxonomy, and then either \u003cstrong\u003eauto-updates\u003c\/strong\u003e confident results or \u003cstrong\u003eroutes uncertain cases for review via Gmail\u003c\/strong\u003e—capturing the final decision through an n8n form.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily\u003c\/strong\u003e on a schedule trigger and loads workflow settings such as the \u003cstrong\u003econfidence threshold\u003c\/strong\u003e, review statuses, and the \u003cstrong\u003ereview recipient email\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds the spend taxonomy\u003c\/strong\u003e by reading active categories from Google Sheets and incorporating \u003cstrong\u003eapproved historical classification feedback\u003c\/strong\u003e to guide Gemini.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies each pending transaction\u003c\/strong\u003e by sending Gemini the transaction context, the allowed taxonomy, and a limited set of feedback examples.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates structured output\u003c\/strong\u003e, checking that the predicted category code\/name exist in the active taxonomy and that required fields like \u003cstrong\u003econfidence\u003c\/strong\u003e and \u003cstrong\u003ereasoning\u003c\/strong\u003e are present and well-formed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuto-updates when confident\u003c\/strong\u003e: if the result is valid, above the threshold, and not ambiguous, it logs to a Google Sheets \u003cstrong\u003eaudit log\u003c\/strong\u003e and updates the transaction as \u003cstrong\u003eClassified\u003c\/strong\u003e with AI details and the final category.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes for human review when needed\u003c\/strong\u003e: otherwise, it marks the row as \u003cstrong\u003eReview Required\u003c\/strong\u003e, logs the event, and emails the reviewer via \u003cstrong\u003eGmail\u003c\/strong\u003e with the suggested category, confidence, and validation\/ambiguity notes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCaptures final decisions\u003c\/strong\u003e when a reviewer submits the \u003cstrong\u003en8n form\u003c\/strong\u003e, which the workflow then uses for the completed classification outcome.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily reconciliation of procurement spend categories across business units in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eReducing manual effort by automatically classifying straightforward transactions while escalating only ambiguous cases.\u003c\/li\u003e\n  \u003cli\u003eImproving taxonomy consistency using prior human feedback embedded into Gemini prompts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic \/ nodes:\u003c\/strong\u003e if, set, code, gmail, merge, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore automation:\u003c\/strong\u003e scheduled run, structured Gemini parsing, confidence-threshold gating, Google Sheets audit logging\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46275604906163,"sku":"N8N-21509","price":59.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/X7CgiNz4uONqHMpS42AYb_sCyanGuQ.png?v=1792832668","url":"https:\/\/buyflowscripts.com\/products\/automate-procurement-spend-classification-in-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}