STR market scan → Google Sheet dataset
Scan a short-term-rental market — discover listings across platforms, price the top N for your dates, and append a normalized row-per-listing dataset to a Google Sheet.
What it does
The job it gets done
Underwriting a short-term-rental market means one repeatable dataset: what is listed, on which platform, at what price, with how many beds and what rating. This workflow fans a search across platforms to discover listings in your area and dates, keeps the top N, re-prices each precisely with the dedicated price endpoint, and appends a normalized row per listing — name, platform, beds, occupancy, rating (on its native scale), nightly and total price, and URL — to a Google Sheet or CSV. Re-run it on a cadence to build a time series for comps and occupancy signals.
How it works
Step by step
- 1
Define the market + dates
Give the workflow a location, the check-in / check-out dates, occupancy, which platforms to scan, how many results to discover per platform, and how many of them to price precisely.
- 2
Discover listings across platforms
It calls GET /v1/search across the requested platforms and merges every match into one normalized Property list — the discovery pass.
- 3
Price the top N precisely
It ranks the discovered listings, keeps the top N, and calls GET /v1/price for each with the exact dates and occupancy — a precise per-date quote per listing.
- 4
Append the market dataset
Each listing becomes one normalized row (name, platform, beds, occupancy, rating + scale, nightly + total price, URL) appended to a Google Sheet or CSV — re-run on a cadence for a time series.
What you'll need
Two ways to run it
Using an AI agent
Just your ScoutingAPI key. Your agent is the brain — it calls the endpoint and reports the result itself, so there's no separate AI key to buy. Install the SKILL.md below.
Using n8n
A running n8n instance, the workflow JSON below, a ScoutingAPI Header Auth credential, and a delivery credential (e.g. Slack) — or swap the last node. The transform is plain JavaScript, so no LLM key is required.
Try it live
Run the core call now — sandbox, 0 credits
Exercise the endpoint this workflow is built on against the deterministic sandbox — a real 200, zero credits, no sign-up.
/v1/searchRuns against the deterministic Airbnb + Booking sandbox fixtures — a real 200, zero credits.
Run the call to see a live, deterministic sandbox response.
curl -sS "https://api.scoutingapi.com/v1/search" \
-H "Authorization: Bearer $SCOUTINGAPI_KEY"Code samples
The same call, every way that matters
# 1) Discover listings in the market
curl -sS "https://api.scoutingapi.com/v1/search?location=Split,HR&checkIn=2026-07-13&checkOut=2026-07-20&platforms=airbnb,vrbo,booking&sort=price_asc&limit=20" \
-H "Authorization: Bearer $SCOUTINGAPI_KEY"
# 2) Price one discovered listing precisely (repeat for your top N)
curl -sS "https://api.scoutingapi.com/v1/price?platform=airbnb&listingId=42307961&checkIn=2026-07-13&checkOut=2026-07-20&adults=2¤cy=EUR" \
-H "Authorization: Bearer $SCOUTINGAPI_KEY"Get it for your platform
Download & import
Typical cost
from 5 credits per platform per run — scales with the results returned (v3 per-result).
search· from 5 credits per platformprice· 3 credits per calllisting· 3 credits per call
Failed & empty calls are always free; sandbox calls cost 0. Live costs are on the pricing page.
FAQ
Common questions
Get your free key — no card
300 credits, the full API, the sandbox, and the native MCP server. Power this workflow and more.
No credit card · failed calls cost 0 credits