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.
Uses
Claude
Google Sheets
Serper
Log new property search results from one site each week
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 blankYes
Change listingsSheetName to Search results.Change listingsSheetName to Search results.No
No steps
If summarySheetName is blankIf summarySheetName is blankYes
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 emptyYes
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 emptyYes
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 recordErrorTry
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 listingErrorTry
Trim hit.link and save it as listingLink.Trim hit.link and save it as listingLink.If listingLink is nullIf listingLink is nullYes
Change listingLink to blank.Change listingLink to blank.No
No steps
If listingLink is emptyIf listingLink is emptyYes
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 yesYes
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 nullYes
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 nullYes
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 0Yes
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 noteErrorTry
ClaudeAsk Claude: notePrompt. Save it as written.Ask Claude: notePrompt. Save it as written.
Maximum response length: 400Trim 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 figureYes
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 emptyYes
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 emptyYes
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 yesYes
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.