Overview I am a New Zealand property investor. I use trademe.co.nz (NZ’s main marketplace) and have multiple saved search URLs for residential property listings. I need a Make.com scenario that collects listings from these saved searches regularly and stores them in Google Sheets. This is Phase 1: reliable data collection only. No AI scoring yet. Goal Build a Make.com automation that: * Reads Trade Me saved-search URLs from a Google Sheet * Backfills older listings gradually (non-aggressive) * Then runs daily to capture new listings * Saves each unique listing once (dedupe by ListingID from URL) * Stores full raw description text for future analysis This is for trademe.co.nz (New Zealand website). Tools * Make.com * Google Sheets * Optional but preferred: Make Data Store for dedupe Inputs (Google Sheet tab: Searches) Columns: SearchName SearchURL NextPage (start at 1) Enabled (Y/N) Outputs (Google Sheet tab: Listings) Must include at minimum: ListingID (extracted from /listing/##########) ListingURL TradeMeListedDate FirstSeenDate LastSeenDate FoundInSearches (semicolon separated if multiple searches) Title AddressText PriceText Beds (if available) Baths (if available) LandAreaText (if available) DescriptionRawText (full description, truncate only if exceeding Google Sheets 50k character limit) Core Logic Required * Iterate enabled searches * Fetch search results page * Extract listing URLs * Open each listing page * Extract required fields * Dedupe by ListingID (never dedupe by address) * If already exists, append SearchName to FoundInSearches * Limit processing to 50 new listings per run (configurable) * Throttle requests (2–5 second delay between fetches) * Support pagination via NextPage field Error Handling * Retry failed fetches 1–2 times * Log failures to a Logs tab * Do not crash entire run due to one bad listing Deliverables * Working Make scenario built in my Make account * Exported Make Blueprint JSON * Short runbook explaining: * how to add searches * how to enable/disable searches * how to adjust daily cap * how backfill works * how to switch to daily mode No password sharing. Access via normal Google/Make sharing only. Please confirm: * Estimated hours * Experience parsing HTML from marketplace sites * Whether you will deliver the Blueprint JSON Example search URL: 1) https://www.trademe.co.nz/a/search?category=3399&search_string=%22dual%20income%22®ion=1&sort_order=expirydesc 2) https://www.trademe.co.nz/a/property/residential/sale/auckland/search?search_string=%22fully%20legal%20homes%22&sort_order=expirydesc 3) https://www.trademe.co.nz/a/property/residential/sale/auckland/search?search_string=%22legal%20houses%22&sort_order=expirydesc