{"product_id":"gmail-property-enquiry-auto-reply-with-gpt-4o-google-sheets","title":"Gmail Property Enquiry Auto-Reply with GPT-4o + Google Sheets","description":"\u003ch3\u003eInstant Gmail property enquiry replies—auto-drafted with GPT-4o and matched to your Google Sheets listings\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your Gmail inbox for new property enquiries, extracts key details with \u003cstrong\u003eGPT-4o\u003c\/strong\u003e, matches each enquiry to the right property in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, logs everything, and then either creates a threaded \u003cstrong\u003eGmail draft for approval\u003c\/strong\u003e or auto-sends a safe, personalised reply.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls Gmail every minute\u003c\/strong\u003e (or runs manually using a test message) and lists unread emails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates\u003c\/strong\u003e by message ID, fetches each full email via the Gmail API, and parses headers and body text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters out non-enquiry emails\u003c\/strong\u003e by classifying the enquiry source (Rightmove, Zoopla, OnTheMarket, SpareRoom, or website) and dropping admin\/irrelevant messages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenAI (GPT-4o)\u003c\/strong\u003e to extract structured contact, property, and qualification details, normalises the data, and detects which qualification fields are missing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches to your property catalogue\u003c\/strong\u003e by searching the \u003cstrong\u003eProperties\u003c\/strong\u003e tab in Google Sheets (by reference or address), determines availability, and prepares a pre-qualification link or suggests similar properties.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a personalised HTML reply\u003c\/strong\u003e that acknowledges already-provided details and follows the correct call-to-action.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs outcomes\u003c\/strong\u003e to the \u003cstrong\u003eEnquiry Log\u003c\/strong\u003e tab in Google Sheets and either creates a Gmail thread draft for staff approval or auto-sends the reply and marks the original email as read.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReduce response times for \u003cstrong\u003eRightmove \/ Zoopla \/ OnTheMarket\u003c\/strong\u003e enquiries without missing qualification details.\u003c\/li\u003e\n  \u003cli\u003eAutomate consistent pre-qualification follow-ups for website enquiries.\u003c\/li\u003e\n  \u003cli\u003eGive your team an approval queue via threaded \u003cstrong\u003eGmail drafts\u003c\/strong\u003e while keeping your Google Sheets enquiry history up to date.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow\u003c\/strong\u003e using: if, code, sticky note, http request, google sheets, manual trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Gmail OAuth2 (Gmail API), \u003cstrong\u003eOpenAI GPT-4o\u003c\/strong\u003e, and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (Properties + Enquiry Log tabs).\u003c\/li\u003e\n  \u003cli\u003eRequires an OAuth2 Gmail credential configured for the mailbox you want to monitor.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146371846323,"sku":"N8N-20233","price":73.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/gUBa3jZStei8uH6_Kd8jj_fFEEeS5C.png?v=1790846398","url":"https:\/\/buyflowscripts.com\/products\/gmail-property-enquiry-auto-reply-with-gpt-4o-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}