{"product_id":"foreclosure-zip-watchlist-automation-with-google-sheets-gmail-n8n","title":"Foreclosure ZIP Watchlist Automation with Google Sheets \u0026 Gmail (n8n)","description":"\u003ch3\u003eAutomate Daily Foreclosure ZIP Watchlists with n8n, Google Sheets \u0026amp; Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically builds a daily foreclosure watchlist by ZIP code using \u003cstrong\u003eForeclosure Finder (RapidAPI)\u003c\/strong\u003e, saves source-deduplicated matches to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and (optionally) sends a digest via \u003cstrong\u003eGmail\u003c\/strong\u003e. The preview starts \u003cstrong\u003einactive\u003c\/strong\u003e with \u003cstrong\u003eemail disabled\u003c\/strong\u003e, so you can validate results before notifying anyone.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily\u003c\/strong\u003e at \u003cstrong\u003e8:00 AM (America\/New_York)\u003c\/strong\u003e or via a \u003cstrong\u003emanual trigger\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates settings\u003c\/strong\u003e including ZIP, radius, price\/bed filters, Google Sheets details, and an optional email recipient.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQueries the Foreclosure Finder API (RapidAPI)\u003c\/strong\u003e to fetch up to \u003cstrong\u003e500 listings\u003c\/strong\u003e across \u003cstrong\u003eAuction, HUD, Fannie Mae, Freddie Mac, and Redfin\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVerifies the API response\u003c\/strong\u003e to ensure the full set of sources is included and the result set is complete.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your Google Sheets watchlist history\u003c\/strong\u003e and identifies \u003cstrong\u003eunnotified\u003c\/strong\u003e listings using a \u003cstrong\u003esource + listing ID\u003c\/strong\u003e key for deduplication.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts matches\u003c\/strong\u003e into Google Sheets as pending rows, then generates a \u003cstrong\u003edigest preview\u003c\/strong\u003e. The digest includes existing matches in the first run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends email only when enabled\u003c\/strong\u003e using Gmail. Rows are marked notified \u003cem\u003eonly\u003c\/em\u003e if a Gmail message ID is returned—confirmation of send acceptance, not inbox delivery. Empty results send \u003cstrong\u003eno email\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReal estate operators monitoring specific ZIP codes for new foreclosure opportunities.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a reliable \u003cstrong\u003eforeclosure watchlist workflow\u003c\/strong\u003e with audit-friendly sheet history.\u003c\/li\u003e\n  \u003cli\u003eSaaS teams demonstrating recurring listings updates with controlled notification behavior.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eNodes\/tech stack: \u003cstrong\u003eSet\u003c\/strong\u003e, \u003cstrong\u003eCode\u003c\/strong\u003e, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, and a \u003cstrong\u003eSticky Note\u003c\/strong\u003e for workflow guidance.\u003c\/li\u003e\n  \u003cli\u003eIntegration: \u003cstrong\u003eForeclosure Finder on RapidAPI\u003c\/strong\u003e with header authentication.\u003c\/li\u003e\n  \u003cli\u003eStorage \u0026amp; deduplication: Google Sheets rows keyed by \u003cstrong\u003esource + listing ID\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46001875189939,"sku":"N8N-19451","price":31.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ykWfWhmBYyP1UKMLfwebT_b2sxuYWE.png?v=1789118135","url":"https:\/\/buyflowscripts.com\/products\/foreclosure-zip-watchlist-automation-with-google-sheets-gmail-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}