{"product_id":"n8n-purchase-requisition-approvals-google-sheets-gmail","title":"n8n Purchase Requisition Approvals: Google Sheets + Gmail","description":"\u003ch3\u003eRoute Purchase Requisition Approvals with n8n Forms, Google Sheets Budget Checks, and Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically collects purchase requisitions, validates cost center budgets in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends approval\/rejection requests via \u003cstrong\u003eGmail\u003c\/strong\u003e—then logs outcomes back to Google Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives submissions\u003c\/strong\u003e from an \u003cstrong\u003en8n form\u003c\/strong\u003e for a purchase requisition.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStandardizes and validates data\u003c\/strong\u003e: it generates a requisition ID, calculates the estimated total cost, and \u003cstrong\u003erejects requests with missing\/invalid required data\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks cost center status\u003c\/strong\u003e in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e by looking up the selected cost center and rejecting the requisition if the cost center is not \u003cem\u003eActive\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnforces budget availability\u003c\/strong\u003e: compares the requisition total against the cost center’s available budget from Google Sheets and rejects if funds are insufficient.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetermines approval level\u003c\/strong\u003e using configured spend thresholds, then selects the appropriate approver email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends approval requests\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e with approve\/reject links, and \u003cstrong\u003ewaits for the approver’s decision\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs results\u003c\/strong\u003e: if rejected, it logs the rejection to Google Sheets and emails the employee the outcome; if approved, it updates the cost center’s used\/available budget, appends the requisition to a requisition log sheet, and emails an approval confirmation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eOrganizations that need \u003cstrong\u003epurchase requisition approvals\u003c\/strong\u003e with spend-based routing (e.g., managers approve small requests; executives approve larger ones).\u003c\/li\u003e\n  \u003cli\u003eTeams that want \u003cstrong\u003ebudget guardrails\u003c\/strong\u003e enforced automatically using a Google Sheets cost center budget ledger.\u003c\/li\u003e\n  \u003cli\u003eCompanies standardizing workflows where every requisition must be \u003cstrong\u003etracked\u003c\/strong\u003e with an ID and logged approvals\/rejections.\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 and Gmail\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used\u003c\/strong\u003e: if, set, code, wait, gmail, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements\u003c\/strong\u003e: connect Google Sheets credentials and provide the Google Sheets document ID and sheet\/tab IDs for \u003cstrong\u003eBudget_Master\u003c\/strong\u003e and \u003cstrong\u003eRequisition_Log\u003c\/strong\u003e (as configured in the workflow).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978926481587,"sku":"N8N-19332","price":20.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9qzGw0GA5xJ2g4oxcLf7z_MUiB4izt.png?v=1788859362","url":"https:\/\/buyflowscripts.com\/products\/n8n-purchase-requisition-approvals-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}