{"product_id":"n8n-sales-quote-approval-workflow-google-sheets-gmail","title":"n8n Sales Quote Approval Workflow: Google Sheets + Gmail","description":"\u003ch3\u003eInstant sales quote approval with n8n, Google Sheets \u0026amp; Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow streamlines your sales quotation process: it collects quote requests via an n8n Form, pulls pricing from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, calculates discounts and margin, and then \u003cstrong\u003eauto-approves\u003c\/strong\u003e or routes the deal for \u003cstrong\u003emanager approval\u003c\/strong\u003e using \u003cstrong\u003eGmail\u003c\/strong\u003e—finally logging results back to Google Sheets and notifying the customer by email.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives quote requests\u003c\/strong\u003e from an \u003cstrong\u003en8n Form submission\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates inputs\u003c\/strong\u003e: required fields, email formats, and that \u003cem\u003equantity\u003c\/em\u003e and \u003cem\u003ediscount\u003c\/em\u003e values are within allowed ranges.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLooks up products in Google Sheets\u003c\/strong\u003e using a \u003cstrong\u003eProduct_Master\u003c\/strong\u003e sheet (by Product Code). If the product is missing or inactive, the flow stops.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates totals\u003c\/strong\u003e: subtotal, discount amount, net amount, cost, gross profit, and gross margin using the unit price, unit cost, and requested quantity.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies pricing policy thresholds\u003c\/strong\u003e (maximum auto-approval discount and minimum profit margin) to decide whether manager approval is required.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequests approval when needed\u003c\/strong\u003e: sends an approval request via \u003cstrong\u003eGmail\u003c\/strong\u003e, waits for the manager’s decision via a form, then logs \u003cstrong\u003eapproved\/rejected\u003c\/strong\u003e outcomes to Google Sheets and emails the customer or sales executive.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuto-approves when allowed\u003c\/strong\u003e: marks the quotation as approved, logs it to Google Sheets, and emails approved quotation details to the customer via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReduce manual back-and-forth for quotes by automatically approving low-discount, margin-safe requests.\u003c\/li\u003e\n  \u003cli\u003eEnforce discount and margin rules consistently across sales reps using a centralized Google Sheets Product Master.\u003c\/li\u003e\n  \u003cli\u003eSpeed up approvals for exceptions by routing only the risky deals to managers via Gmail and a decision form.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFlow control with \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, and \u003cstrong\u003ecode\u003c\/strong\u003e nodes for validation and calculations\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ewait\u003c\/strong\u003e node to pause for manager decision\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003egmail\u003c\/strong\u003e integration to request and notify via email\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003esticky note\u003c\/strong\u003e nodes for clearer workflow documentation\u003c\/li\u003e\n  \u003cli\u003eRequires \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e and a \u003cstrong\u003eProduct_Master\u003c\/strong\u003e sheet containing fields like Product Code, Product Name, Unit Price, and Unit Cost\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46232417829043,"sku":"N8N-21050","price":24.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/szFBQOQjNeFzSz4we0hA__ZdI72p2q.png?v=1792141995","url":"https:\/\/buyflowscripts.com\/products\/n8n-sales-quote-approval-workflow-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}