Log new property search results from one site each week
Runs your property search on Google for one site each week and logs every result page you have not seen, with its title and any price.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1Google SheetsRead rowsReads the results tab to collect every link already on record, and checks whether the summary tab has headings yet.
If
recordHeadersis empty- 2Google SheetsAppend rowWrites heading rows to empty tabs, then a row per new result page and one summary row per run with counts and note.
- 2
- 3SerperSearch webRuns your search on Google, restricted to the property site you named, and returns the result pages to compare against the record.
For each
hitIf
listingLinkis not empty,onSiteand (listingLinkContainsis empty orlinkLowercontainslistingLinkContains)If
seenLinksdoes not includelinkLower- 4Google SheetsAppend row
- 4
If
newCountis more than 0- 5AnthropicGenerate model responseAsks the AI for a short note describing only the new results and the prices they show, with no opinion or forecast.
- 5
If
summaryHeadersis empty- 6Google SheetsAppend row
- 6
- 7Google SheetsAppend row
How it works
What happens on each run, in plain English.
Describe one property search once, such as two bedroom flats for sale in one city, and name the property site. Every week the workflow runs that search on Google, limited to that site, and logs what comes back in Google Sheets: each result page it has not seen before goes on your results tab with the date first seen, the page title, the first price its text shows, the link and Google's short description of the page. A second tab gets one row per run with the counts and a short note on what was added.
Google's results for a property site mix single listings with search pages and area guides, and all of them are logged unless you say how the site's listing links look: set a piece of the address such as '/properties/' and every other page is counted but left out. It is a record, not advice: nothing is valued, no price is called high or low and no prediction is made, and any money figure in the AI's note must appear in the results or the note is dropped for plain counts. A page whose text shows no price gets an empty cell, links already on record are skipped, and rows are only ever appended.
You need Google Sheets, Serper (for the Google search) and Anthropic connected, and a Google Sheet with two tabs, named 'Search results' and 'Weekly summary' unless you choose others; heading rows are written into empty tabs for you. Fill in the search, the site, a name for the market and the sheet's link.
You may also be interested in
Work out the questions worth asking, then answer themName a subject and it decides which questions are worth asking, then answers each one from a page it actually read.
Look up an unfamiliar website before you deal with itGathers what public records, the web archive and search results say about a site you don't know, each with its source.
Extract purchase orders from GmailReads each new purchase order email, looks its items up in your product list, and logs every line with name and price.Score client health from your email logScores how satisfied each client sounds in the emails you log every week and keeps a client health dashboard tab up to date.Start from a workflow that already works.
Add "Log new property search results from one site each week" to your workspace, connect its apps, and make it yours.
Free plan, no credit card