{"product_id":"n8n-quote-request-workflow-google-sheets-gmail-validation","title":"n8n Quote Request Workflow: Google Sheets + Gmail Validation","description":"\u003ch3\u003eCapture quote requests, validate missing details, and email confirmations automatically—using n8n, Google Sheets, and Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n Quote Request Workflow collects submissions from an n8n Form, checks which required details are missing, stores each request in Google Sheets, and sends both the business owner and the customer the right Gmail messages based on the validation result.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a new quote request\u003c\/strong\u003e from an n8n Form submission.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes submitted fields\u003c\/strong\u003e, generates a unique \u003cstrong\u003erequest reference\u003c\/strong\u003e, and validates the submission against a configurable list of \u003cstrong\u003erequired_fields\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicate entries\u003c\/strong\u003e by looking up the generated request reference in Google Sheets (to avoid saving duplicate requests from the same day).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves the request to Google Sheets\u003c\/strong\u003e in the \u003cstrong\u003e“Requests”\u003c\/strong\u003e tab with a status of either \u003ccode\u003eready_to_quote\u003c\/code\u003e or \u003ccode\u003emissing_info.\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail the business owner via Gmail\u003c\/strong\u003e with the request details and the current status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail the customer via Gmail\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eIf details are missing: asks for the missing information.\u003c\/li\u003e\n      \u003cli\u003eIf everything is present: confirms the request and includes the expected \u003cstrong\u003ereply_within\u003c\/strong\u003e timeframe.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDisplays a thank-you completion page\u003c\/strong\u003e after customer messaging.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLead capture for services where quotes require specific customer details (e.g., project specs, contact information, or scope fields).\u003c\/li\u003e\n  \u003cli\u003eReducing back-and-forth by automatically requesting missing information before preparing a quote.\u003c\/li\u003e\n  \u003cli\u003eKeeping a clean quote pipeline in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e while notifying your team immediately with the right status.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/nodes:\u003c\/strong\u003e \u003ccode\u003eform\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, plus \u003ccode\u003esticky note\u003c\/code\u003e for workflow documentation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets requirements:\u003c\/strong\u003e a spreadsheet with a tab named \u003cstrong\u003e“Requests”\u003c\/strong\u003e, including a \u003cstrong\u003erequest_id\u003c\/strong\u003e column matching what the workflow appends.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail setup in n8n:\u003c\/strong\u003e configure \u003ccode\u003eowner_email\u003c\/code\u003e, \u003ccode\u003ebusiness_name\u003c\/code\u003e, \u003ccode\u003ereply_within\u003c\/code\u003e, and \u003ccode\u003erequired_fields\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46228888649907,"sku":"N8N-20976","price":42.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/XKoOS0Wz6cjfh2YokUK_O_a8JGv9Tc.png?v=1792055449","url":"https:\/\/buyflowscripts.com\/products\/n8n-quote-request-workflow-google-sheets-gmail-validation","provider":"N8N Commerce","version":"1.0","type":"link"}