Log new property search results from one site each week

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.

Run every 7 days.Run every 7 days.

Set searchQuery to blank.Set searchQuery to blank.

Set listingSite to blank.Set listingSite to blank.

Set marketName to blank.Set marketName to blank.

Set spreadsheetUrl to blank.Set spreadsheetUrl to blank.

Set listingsSheetName to Search results.Set listingsSheetName to Search results.

Set summarySheetName to Weekly summary.Set summarySheetName to Weekly summary.

Set maxNewListings to 15.Set maxNewListings to 15.

Set resultsToScan to 20.Set resultsToScan to 20.

Set listingLinkContains to blank.Set listingLinkContains to blank.

If listingsSheetName is blankIf listingsSheetName is blank

Yes

Change listingsSheetName to Search results.Change listingsSheetName to Search results.

No

No steps

If summarySheetName is blankIf summarySheetName is blank

Yes

Change summarySheetName to Weekly summary.Change summarySheetName to Weekly summary.

No

No steps

Make listingSite lowercase and save it as siteHostRaw.Make listingSite lowercase and save it as siteHostRaw.

Get the first item of the last item of siteHostRaw split by :// split by / and save it as siteHost.Get the first item of the last item of siteHostRaw split by :// split by / and save it as siteHost.

If siteHost is emptyIf siteHost is empty

Yes

Stop and report a problem: 'listingSite' does not look like a web address. Write just the site, for example rightmove.co.uk.Stop and report a problem: 'listingSite' does not look like a web address. Write just the site, for example rightmove.co.uk.

No

No steps

Google SheetsRead the rows of spreadsheetUrl. Save it as record.Read the rows of spreadsheetUrl. Save it as record.

Set recordHeaders to record.headers.Set recordHeaders to record.headers.

Set recordRows to record.rows.Set recordRows to record.rows.

If recordHeaders is emptyIf recordHeaders is empty

Yes

Google SheetsAdd a row to listingsSheetName in spreadsheetUrl.Add a row to listingsSheetName in spreadsheetUrl.

No

No steps

Set seenLinks to an empty list.Set seenLinks to an empty list.

For each recordRow in recordRows:For each recordRow in recordRows:

If a step below fails, save the error as recordErrorIf a step below fails, save the error as recordError

Try

Add recordRow.Link in lowercase to the end of seenLinks and save it as seenLinks.Add recordRow.Link in lowercase to the end of seenLinks and save it as seenLinks.

On error

Show in the output: Ignored a row already on the record that has no Link column: recordError as text.Show in the output: Ignored a row already on the record that has no Link column: recordError as text.

Set searchUsed to searchQuery site:siteHost.Set searchUsed to searchQuery site:siteHost.

SerperSearch Google for searchUsed. Save it as search.Search Google for searchUsed. Save it as search.

Set hits to search.results.Set hits to search.results.

Set newCount to 0.Set newCount to 0.

Set alreadyCount to 0.Set alreadyCount to 0.

Set offSiteCount to 0.Set offSiteCount to 0.

Set newSummary to blank.Set newSummary to blank.

Set notListingCount to 0.Set notListingCount to 0.

Set hitLimit to false.Set hitLimit to false.

For each hit in hits:For each hit in hits:

If newCount multiplied by 1 is greater than or equal to maxNewListings multiplied…If newCount multiplied by 1 is greater than or equal to maxNewListings multiplied…

Yes

Change hitLimit to true.Change hitLimit to true.

Stop repeating.Stop repeating.

No

No steps

If a step below fails, save the error as listingErrorIf a step below fails, save the error as listingError

Try

Trim hit.link and save it as listingLink.Trim hit.link and save it as listingLink.

If listingLink is nullIf listingLink is null

Yes

Change listingLink to blank.Change listingLink to blank.

No

No steps

If listingLink is emptyIf listingLink is empty

Yes

Show in the output: Skipped a search result that came back with no link..Show in the output: Skipped a search result that came back with no link..

No

Make listingLink lowercase and save it as linkLower.Make listingLink lowercase and save it as linkLower.

Get the first item of the last item of linkLower split by :// split by / and save it as linkHost.Get the first item of the last item of linkLower split by :// split by / and save it as linkHost.

Set onSite to linkHost is siteHost or linkHost ends with .@siteHost.Set onSite to linkHost is siteHost or linkHost ends with .@siteHost.

If onSite is yesIf onSite is yes

Yes

If listingLinkContains isn't blank and linkLower doesn't contain…If listingLinkContains isn't blank and linkLower doesn't contain…

Yes

Add 1 to notListingCount.Add 1 to notListingCount.

Else if @seenLinks contains @linkLower

Add 1 to alreadyCount.Add 1 to alreadyCount.

Otherwise

Trim hit.title and save it as listingTitle.Trim hit.title and save it as listingTitle.

If listingTitle is nullIf listingTitle is null

Yes

Change listingTitle to blank.Change listingTitle to blank.

No

No steps

Trim hit.snippet and save it as listingSnippet.Trim hit.snippet and save it as listingSnippet.

If listingSnippet is nullIf listingSnippet is null

Yes

Change listingSnippet to blank.Change listingSnippet to blank.

No

No steps

Set listingText to listingTitle listingSnippet.Set listingText to listingTitle listingSnippet.

Extract the first match from listingText and save it as priceAsListed.Extract the first match from listingText and save it as priceAsListed.

Google SheetsAdd a row to listingsSheetName in spreadsheetUrl.Add a row to listingsSheetName in spreadsheetUrl.

Add linkLower to the end of seenLinks and save it as seenLinks.Add linkLower to the end of seenLinks and save it as seenLinks.

Change newSummary to newSummary- listingTitle | price as listed: priceAsListedChange newSummary to newSummary- listingTitle | price as listed: priceAsListed .

Add 1 to newCount.Add 1 to newCount.

No

Add 1 to offSiteCount.Add 1 to offSiteCount.

On error

Show in the output: Skipped a search result that could not be read: listingError as text.Show in the output: Skipped a search result that could not be read: listingError as text.

Set listingsOnRecord to the length of recordRows plus newCount.Set listingsOnRecord to the length of recordRows plus newCount.

Set note to Recorded newCount as text new search results for this market; alreadyCount as text results were already on the record.Set note to Recorded newCount as text new search results for this market; alreadyCount as text results were already on the record.

If newCount multiplied by 1 is greater than 0If newCount multiplied by 1 is greater than 0

Yes

Set notePrompt to You are writing one short note for a record of property search results.Set notePrompt to You are writing one short note for a record of property search results. Describe only what the search results below say: how many there are, what kinds of property they are, and the prices as they were listed. Quote a figure only if it appears in the text below, written exactly as it is there. Do not give advice, an opinion, a recommendation or a forecast. Do not say whether anything is cheap, expensive, good value, a bargain, over-priced or worth buying. Do not estimate a value, a yield, a return or a future price. Do not compare these results with any market figure you were not given here. Do not describe the market as rising, falling, hot, slow or recovering. Write at most four sentences of plain description, and nothing else. Market: marketName New search results recorded in this run: newSummary.

If a step below fails, save the error as noteErrorIf a step below fails, save the error as noteError

Try

ClaudeAsk Claude: notePrompt. Save it as written.Ask Claude: notePrompt. Save it as written. Maximum response length: 400

Trim written.response_text and save it as noteText.Trim written.response_text and save it as noteText.

Extract all matches from noteText and save it as noteFigures.Extract all matches from noteText and save it as noteFigures.

Set noteIsClean to true.Set noteIsClean to true.

For each figure in noteFigures:For each figure in noteFigures:

If newSummary doesn't contain figure If newSummary doesn't contain figure

Yes

Change noteIsClean to false.Change noteIsClean to false.

Stop repeating.Stop repeating.

No

No steps

If noteIsClean is yes and noteText isn't emptyIf noteIsClean is yes and noteText isn't empty

Yes

Change note to noteText.Change note to noteText.

No

Show in the output: The written note was left out: it quoted a figure that is not in the listings, or came back empty. The listing rows are unaffected..Show in the output: The written note was left out: it quoted a figure that is not in the listings, or came back empty. The listing rows are unaffected..

On error

Show in the output: Could not write the run note: noteError as text.Show in the output: Could not write the run note: noteError as text.

No

No steps

Google SheetsRead the rows of spreadsheetUrl. Save it as summary.Read the rows of spreadsheetUrl. Save it as summary.

Set summaryHeaders to summary.headers.Set summaryHeaders to summary.headers.

If summaryHeaders is emptyIf summaryHeaders is empty

Yes

Google SheetsAdd a row to summarySheetName in spreadsheetUrl.Add a row to summarySheetName in spreadsheetUrl.

No

No steps

Google SheetsAdd a row to summarySheetName in spreadsheetUrl.Add a row to summarySheetName in spreadsheetUrl.

Set limitNote to blank.Set limitNote to blank.

If hitLimit is yesIf hitLimit is yes

Yes

Build the text Stopped at the limit of @maxNewListings new results set in 'maxNewListings'; any others are not recorded this week. and save it as limitNote.Build the text Stopped at the limit of @maxNewListings new results set in 'maxNewListings'; any others are not recorded this week. and save it as limitNote.

No

No steps

Show in the output: Added newCount new search results to the '@listingsSheetName' tab. alreadyCount were already on the record, notListingCount were not listing pages and offSiteCount were not on siteHost.@limitNote.Show in the output: Added newCount new search results to the '@listingsSheetName' tab. alreadyCount were already on the record, notListingCount were not listing pages and offSiteCount were not on siteHost.@limitNote.