Weekly Market Real Estate Survey

Automate weekly competitive rent analysis by scraping listings and generating reports
OpenAI integrationsOpenAI
Google Sheets integrationsGoogle Sheets
Use this template
Created by
Relay.app logoRelay.app Team
Relay.app screenshot of: Weekly Market Real Estate Survey

Steps in this workflow

1
Relay.app logo
Trigger
2
Relay.app logo
Create table of constants
3
repeat
Loop over a list
4
Relay.app logo
Scrape content from website
5
Relay.app logo
Write weekly market survey report (AI)
6
Relay.app logo
Extract with AI
7
Google Sheets logo
Write list to new spreadsheet
8
Relay.app logo
Send market survey report to me
Use this template

Automatically analyze your competitive real estate market position by scraping competitor listings and comparing rental prices. Here's how it works:

  • The workflow runs automatically every Saturday morning
  • It scrapes configured competitor websites to gather current rental listings
  • AI analyzes the data to compare your building's rents against competitors
  • A comprehensive report and data table are generated and emailed to you
1
Relay.app logo
Trigger

Starts the workflow on a configured schedule. Runs automatically at the specified day and time each week.

Relay.app screenshot of: Trigger
2
Relay.app logo
Create table of constants

Creates a table containing the URLs of competitor real estate websites to scrape. These URLs should be configured when setting up the workflow.

Relay.app screenshot of: Create table of constants
3
repeat
Loop over a list

Iterates through each URL in the table, running the scraping steps in parallel. Collects all scraped content into a single list for analysis.

Relay.app screenshot of: Loop over a list
Iterator steps
4
Relay.app logo
Scrape content from website

Scrapes the content from each competitor website using stealth proxy to avoid anti-bot measures. Waits for pages to fully load before extracting data.

Relay.app screenshot of: Scrape content from website
5
Write weekly market survey report (AI)

Uses AI to analyze the scraped data and write a comprehensive market survey report. Compares advertised rents between your building and competitors, highlighting pricing differences and market position.

Prompt used
You are an expert leasing agent. Write a weekly market survey report that compares the current advertised rents of our building (Aren) to other buildings in the scraped data. Identify which buildings are competitors, summarize key differences in rent, and highlight Aren's leasing position. Format the report as a concise executive summary. Use emoji and formatting to make it look nice. Please start your report with a competitive pricing comparison across each unit type. Be sure to note where we are off market and should change our pricing or services.
Relay.app screenshot of: Write weekly market survey report (AI)
6
Extract with AI

Extracts structured pricing data from the report into a spreadsheet format. Creates rows for each building with studio, 1-bedroom, and 2-bedroom prices and summaries.

Prompt used
You are a leasing analyst. Given a market summary report I want to create a spreadsheet represention. Please output a list of buildings. For each building, output: 1. Studio price and summary 2. 1br price and summary 2. 2br price and summary
Relay.app screenshot of: Extract with AI
7
Google Sheets logo
Write list to new spreadsheet

Writes the extracted pricing data to a new Google Sheets spreadsheet. Creates a formatted table for easy analysis and record-keeping.

Relay.app screenshot of: Write list to new spreadsheet
8
Relay.app logo
Send market survey report to me

Sends the market survey report via email with the analysis as the email body. Delivers the weekly competitive analysis directly to your inbox.

Relay.app screenshot of: Send market survey report to me