{"product_id":"route-approval-requests-gpt-4o-mini-supabase-gmail","title":"Route Approval Requests: GPT-4o-mini + Supabase + Gmail","description":"\u003ch3\u003eAutomatically route approval requests with AI risk scoring—and one-click approvals\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures incoming approval requests from an n8n form, uses \u003cstrong\u003eGPT-4o-mini\u003c\/strong\u003e to summarize and score risk, logs everything in \u003cstrong\u003eSupabase\u003c\/strong\u003e, emails the correct approver through \u003cstrong\u003eGmail\u003c\/strong\u003e with \u003cstrong\u003eapprove\/reject\u003c\/strong\u003e links, and finally notifies the requester once a decision is made.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a new request\u003c\/strong\u003e from an n8n form (type, title, amount, department, justification, and requester email).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSummarizes and scores risk with OpenAI (GPT-4o-mini)\u003c\/strong\u003e, producing a short summary plus a risk score, priority, and suggested approval level.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects the approver\u003c\/strong\u003e based on \u003cem\u003eamount thresholds\u003c\/em\u003e and the \u003cem\u003eAI risk score\u003c\/em\u003e, then merges the AI output with the original form data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStores the request in Supabase\u003c\/strong\u003e by creating a new row in the \u003ccode\u003eapproval_requests\u003c\/code\u003e table, including the request details, AI fields, and a generated request ID set to \u003cstrong\u003epending\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends decision emails via Gmail\u003c\/strong\u003e to the approver, including one-click \u003cstrong\u003eapprove\/reject URLs\u003c\/strong\u003e that point to a webhook.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles the approver’s action\u003c\/strong\u003e: when the approver clicks, the workflow updates the Supabase record to \u003cstrong\u003eapproved\u003c\/strong\u003e or \u003cstrong\u003erejected\u003c\/strong\u003e with audit details, then \u003cstrong\u003eemails the requester\u003c\/strong\u003e the final outcome via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRoute purchase or expense approvals to the right manager based on \u003cstrong\u003eamount\u003c\/strong\u003e and \u003cstrong\u003eAI risk\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eStandardize approvals for departments (e.g., Finance, Engineering) using consistent risk summaries.\u003c\/li\u003e\n  \u003cli\u003eProvide approvers with a fast, auditable approval process using email-based links.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e: GPT-4o-mini for summary, risk score, priority, and suggested approval level.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupabase\u003c\/strong\u003e: writes to \u003ccode\u003eapproval_requests\u003c\/code\u003e and updates status\/audit details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: emails approvers with approve\/reject links and notifies requesters of results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhooks\u003c\/strong\u003e: webhook endpoints to receive approve\/reject clicks.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n logic nodes\u003c\/strong\u003e: if, set, code, plus supporting flow control.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916231565491,"sku":"N8N-18831","price":38.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/eEOGU5lchmoZbBK4IngYl_44wsJU6E.png?v=1788012565","url":"https:\/\/buyflowscripts.com\/products\/route-approval-requests-gpt-4o-mini-supabase-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}