{"product_id":"n8n-daily-property-match-email-via-google-sheets-gmail","title":"n8n Daily Property Match Email via Google Sheets \u0026 Gmail","description":"\u003ch3\u003eDaily property match emails from Google Sheets to leads—fully automated with n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads new property listings and buyer\/renter leads from a Google Sheet, matches each lead to the best available listings, and sends a single HTML digest email per lead via Gmail—then marks listings as alerted to prevent duplicate emails.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns daily at 8:00 AM\u003c\/b\u003e using an n8n \u003cb\u003eschedule trigger\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReads your Google Sheets\u003c\/b\u003e document and processes two tabs: \u003cb\u003eListings\u003c\/b\u003e and \u003cb\u003eLeads\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSelects only eligible records\u003c\/b\u003e: it filters for \u003cb\u003eavailable\u003c\/b\u003e listings that have not yet been sent (via an \u003cb\u003e“Alert Sent At”\u003c\/b\u003e timestamp) and for \u003cb\u003eactive leads\u003c\/b\u003e with valid email addresses and non-stop statuses.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eMatches leads to listings\u003c\/b\u003e based on:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cb\u003eIntent\u003c\/b\u003e (sale vs. rent)\u003c\/li\u003e\n      \u003cli\u003e\n\u003cb\u003eBudget\u003c\/b\u003e, using a configurable \u003cb\u003eprice tolerance\u003c\/b\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\u003cb\u003ePreferred areas\u003c\/b\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cb\u003eMinimum bedrooms\u003c\/b\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cb\u003eProperty type\u003c\/b\u003e\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRanks and limits results\u003c\/b\u003e per lead, then generates a \u003cb\u003eformatted HTML email digest\u003c\/b\u003e with their best matches and a booking link.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends via Gmail\u003c\/b\u003e, then updates each processed listing’s \u003cb\u003e“Alert Sent At”\u003c\/b\u003e value in Google Sheets so it won’t be emailed again.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAgencies and property managers who want \u003cb\u003edaily lead nurturing\u003c\/b\u003e without manual searching.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying a reliable \u003cb\u003en8n email digest\u003c\/b\u003e workflow from \u003cb\u003eGoogle Sheets\u003c\/b\u003e data.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who need a repeatable pattern for \u003cb\u003ematching + deduping\u003c\/b\u003e notifications across datasets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eNodes \/ tech stack\u003c\/b\u003e: \u003cb\u003eschedule trigger\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003egoogle sheets\u003c\/b\u003e, \u003cb\u003egmail\u003c\/b\u003e, and \u003cb\u003esticky note\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSetup requirements\u003c\/b\u003e: connect Google Sheets access, connect Gmail sending credentials, configure the \u003cb\u003eGoogle Sheet ID\u003c\/b\u003e, agency\/agent details, \u003cb\u003ebooking link\u003c\/b\u003e, \u003cb\u003ecurrency symbol\u003c\/b\u003e, \u003cb\u003eprice tolerance\u003c\/b\u003e, and \u003cb\u003emax listings per email\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExpected columns\u003c\/b\u003e: Listings (e.g., \u003cb\u003eListing Ref\u003c\/b\u003e, \u003cb\u003eStatus\u003c\/b\u003e, \u003cb\u003eAlert Sent At\u003c\/b\u003e) and Leads (e.g., \u003cb\u003eEmail\u003c\/b\u003e, \u003cb\u003eIntent\u003c\/b\u003e, \u003cb\u003eBudget\u003c\/b\u003e, and preference fields).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46164234502323,"sku":"N8N-20468","price":17.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/oGY9Mmb-zd7yomaZgrWaz_1ljuL0Va.png?v=1791278621","url":"https:\/\/buyflowscripts.com\/products\/n8n-daily-property-match-email-via-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}