← Back to work
Data analysisPrivate

BatchData Property Search → Sheets

Filtered owner/property pulls into Google Sheets with dedupe.

What they needed

Real-estate prospecting needed repeatable BatchData searches into Google Sheets, with filters and APN-style dedupe for vacant-land / loan targeting.

What I delivered

  • Google Apps Script menu-driven search into Filters / Results / Run Log sheets
  • Post-filter and dedup logic; mock mode for safe testing
  • Field/filter lists aligned to the client’s targeting brief

Why it helped

Prospect lists refresh on demand without pasting duplicates into the sheet by hand.

Tech in the build

Google Apps ScriptBatchData Property Search API

Access

Private Google Sheets workflow