Templates / Monitor foreclosure listings by ZIP with Google Sheets and Gmail

Monitor foreclosure listings by ZIP with Google Sheets and Gmail

Ready for 3.0

by Foreclosure Finder · 5 views · created 2026-09-10 · Market Research

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 14 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets and Gmail. It also calls foreclosure-finder1.p.rapidapi.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

  1. Watchlist settings (Edit Fields (Set)): sets 10 fields: zipcode, radius, minPrice…
  2. Validate settings (Code): runs custom JavaScript code
  3. Search five sources (HTTP Request): calls foreclosure-finder1.p.rapidapi.com (GET)
  4. Validate complete scan (Code): runs custom JavaScript code
  5. Read watchlist history (Google Sheets): read (sheet)
  6. Find unnotified matches (Code): runs custom JavaScript code
  7. Save pending matches (Google Sheets): append or update (sheet)
  8. Build email preview (Code): runs custom JavaScript code
  9. Release email if enabled (Code): runs custom JavaScript code
  10. Send watchlist email (Gmail): send (message)

…plus 2 more steps. See the full node list below.

Services it uses

Google SheetsGmail

HTTP calls to: foreclosure-finder1.p.rapidapi.com

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (7)

From the author

Quick overview Build a daily ZIP-code property watchlist with Foreclosure Finder on RapidAPI, Google Sheets and Gmail. Save source-deduplicated matches and optionally email records not yet marked notified. This preview starts inactive with email disabled. How…

Excerpt from Foreclosure Finder's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.