{"product_id":"n8n-gmail-portal-enquiry-auto-reply-w-openai-sheets","title":"n8n Gmail Portal Enquiry Auto-Reply w\/ OpenAI + Sheets","description":"\u003ch3\u003eInstant, accurate first replies to portal enquiries—automatically drafted in Gmail (with AI, but never unchecked)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your Gmail for new \u003cstrong\u003eRightmove, Zoopla, OnTheMarket\u003c\/strong\u003e, or website enquiry emails, extracts the key details using \u003cstrong\u003eOpenAI\u003c\/strong\u003e, and creates a \u003cstrong\u003eGmail draft\u003c\/strong\u003e reply for a quick human review—logging every lead to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with retention controls. Nothing is sent automatically, so you stay in control.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors a Gmail label\u003c\/strong\u003e: watches for new emails in the label \u003cem\u003eportal-leads\u003c\/em\u003e (set up via a Gmail filter).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends enquiry text to OpenAI\u003c\/strong\u003e with a strict SYSTEM prompt to extract: \u003cstrong\u003ename, contact details, property, position, finance and timeline\u003c\/strong\u003e, then write a short, personal first reply with \u003cstrong\u003eup to three qualifying questions\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates the AI output\u003c\/strong\u003e using a Code step: the reply address must appear in the original email, must not be your own address or a portal’s domain, and the AI must \u003cstrong\u003enot add links or contact details\u003c\/strong\u003e. The prompt treats the enquiry text as \u003cstrong\u003edata\u003c\/strong\u003e, never instructions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs the lead in Google Sheets\u003c\/strong\u003e (tab \u003cem\u003eLeads\u003c\/em\u003e) and applies a \u003cstrong\u003edelete-after date\u003c\/strong\u003e for data retention.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves a Gmail draft\u003c\/strong\u003e for the person to review and send—using your \u003cem\u003ebooking link\u003c\/em\u003e, \u003cem\u003esignature\u003c\/em\u003e, and \u003cem\u003eprivacy notice\u003c\/em\u003e from the Settings node. No automatic sending.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eUK letting\/estate agents needing a faster first response to portal enquiries without risking unchecked outbound messages.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying an \u003cstrong\u003eAI-assisted Gmail portal enquiry auto-reply\u003c\/strong\u003e with validation and audit logging.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators using n8n to standardise lead capture from email forms into Sheets + draft replies.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/steps\u003c\/strong\u003e used include: \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003egmail\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, and \u003cem\u003ehttp request\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Gmail, OpenAI, and Google Sheets (add your own credentials in your n8n instance).\u003c\/li\u003e\n  \u003cli\u003eCustomization: edit \u003cstrong\u003eSYSTEM_PROMPT\u003c\/strong\u003e (tone\/questions) and choose \u003cstrong\u003eAI_MODEL\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eMade by Burnt \u0026amp; To\u003c\/strong\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46236463169715,"sku":"N8N-21006","price":58.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/pCzxSA2NA5WbdTHv9Th1-_7pu2Plb4.png?v=1792227937","url":"https:\/\/buyflowscripts.com\/products\/n8n-gmail-portal-enquiry-auto-reply-w-openai-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}