Realtor → Google Sheets Daily Extraction + Client Dashboard

The challenge

realtor.com has no public API - only browser-only GraphQL with rotating queries and real rate limits.

The solution

A two-layer system: (1) Apps Script Code.gs runs daily on a trigger, iterates the parent Users sheet, fires 8 reverse-engineered realtor.com GraphQL queries, paginates 100+ results, and writes to each client's own spreadsheet. (2) Standalone Apps Script web app under webapp/ serves one URL template ?ss=<id> with a branded Realtorships dashboard - sidebar filters, sortable sticky-header table, pagination, CSV export, ACL via parent-sheet hyperlink whitelist, with caching at both layers.

Results