{"product_id":"n8n-expense-triage-workflow-forms-to-google-sheets-gmail","title":"n8n Expense Triage Workflow: Forms to Google Sheets \u0026 Gmail","description":"\u003ch3\u003eAutomatically triage employee expenses from Forms into Google Sheets—and notify the right people by Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n Expense Triage Workflow captures each expense submission via \u003cstrong\u003en8n Form Trigger\u003c\/strong\u003e, checks for duplicates in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, classifies entries by review status, and sends an \u003cstrong\u003eemployee Gmail receipt\u003c\/strong\u003e—while alerting a reviewer only when an expense needs attention.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCaptures submissions\u003c\/strong\u003e: An n8n \u003cstrong\u003eForm Trigger\u003c\/strong\u003e captures each employee expense as it’s submitted.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and de-duplicates\u003c\/strong\u003e: The workflow normalizes the submission, creates a \u003cem\u003eduplicate key\u003c\/em\u003e using \u003cstrong\u003eemployee email + date + vendor + amount\u003c\/strong\u003e, and checks the \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e data for repeat submissions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes with clear review rules\u003c\/strong\u003e: A \u003cstrong\u003eSwitch\u003c\/strong\u003e node routes every expense:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eInvalid amounts\u003c\/strong\u003e → marked \u003cstrong\u003eNeeds Correction\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eAmounts above the USD 500 threshold\u003c\/strong\u003e or \u003cstrong\u003epossible duplicates\u003c\/strong\u003e → marked \u003cstrong\u003eNeeds Review\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eClean small expenses\u003c\/strong\u003e → marked \u003cstrong\u003ePending Review\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results back to Sheets\u003c\/strong\u003e: Appends each expense row with \u003cstrong\u003ereview_status\u003c\/strong\u003e and \u003cstrong\u003ereview_reason\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails the right notifications\u003c\/strong\u003e: The employee always receives a \u003cstrong\u003eGmail receipt\u003c\/strong\u003e; the reviewer is alerted only for expenses requiring attention.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKeeps humans in control\u003c\/strong\u003e: Approval and reimbursement decisions remain with your team.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSmall businesses triaging expense claims currently handled by hand in spreadsheets.\u003c\/li\u003e\n  \u003cli\u003eTeams validating expense amounts and flagging entries over \u003cstrong\u003eUSD 500\u003c\/strong\u003e for extra scrutiny.\u003c\/li\u003e\n  \u003cli\u003eOrganizations that want duplicate detection and consistent intake without changing their existing review process.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTech stack \/ nodes\u003c\/strong\u003e: if, set, gmail, switch, sticky note, form trigger\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (append + duplicate checks) and \u003cstrong\u003eGmail\u003c\/strong\u003e (employee receipt + reviewer alerts)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup essentials\u003c\/strong\u003e: Import the workflow JSON, connect Google Sheets and Gmail credentials, create a sheet with these 11 headers in row 1:\n    \u003cem\u003esubmission_id, employee_email, expense_date, vendor, amount, currency, description, submitted_at, review_status, review_reason, duplicate_key\u003c\/em\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequirements\u003c\/strong\u003e: n8n supporting Form Trigger 2.6, Google Sheets 4.7, Gmail 2.2; a Google account with Sheets and Gmail access.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCustomization\u003c\/strong\u003e: Adjust the USD 500 threshold in \u003cem\u003eCheck Expense Amount\u003c\/em\u003e and update the duplicate-key fields if needed.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46164199637171,"sku":"N8N-20493","price":52.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/M-EuDqlMQ6HRKqgF_0pox_wQZVRlwe.png?v=1791278011","url":"https:\/\/buyflowscripts.com\/products\/n8n-expense-triage-workflow-forms-to-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}