Score every new Airtable property on commute and reach

When a new property lands in Airtable, get a plain-English location summary, drive times to your key places, a commute score, and an annotated map.

Agentic Task
AirtableMapboxOperationsLead EnrichmentData SyncResearch & Monitoring
PromptCreate

Build me a real-estate location-intelligence workflow that runs every time a new property row lands in my Airtable base.

Trigger: Airtable new_record event on the "Properties" table of my base. The workflow should only fire on brand-new records, never on updates to existing ones.

When a new property row appears, do the following:

1. Read the new property row from Airtable and pull its full street address (and any city / state / postal-code fields). Then call Airtable List Records on a second table in the same base called "Important Destinations". Each row in that table has a destination name (e.g. Downtown, My office, Train station, Primary school, Airport) and an address.

2. Geocode the property's address using Mapbox Forward Geocode (v6) to get latitude / longitude. Geocode every important destination the same way. If a destination row already has cached lat/lng columns, reuse them instead of re-geocoding.

3. Call Mapbox Get Isochrone from the property's coordinates with the mapbox/driving profile and contour minutes [15, 30, 45]. This returns a GeoJSON FeatureCollection of three reachable-area polygons. Keep the GeoJSON for the map render in step 5.

4. Call Mapbox Get Distance Matrix with the property as the single origin and every important destination as a destination, on the mapbox/driving profile. Capture the travel time to each destination in minutes.

5. Render a Mapbox Static Map Image centered on the property, roughly 800x500. Overlay the three isochrone polygons as colored bands (green for 15 min, yellow for 30 min, orange for 45 min) using the GeoJSON overlay parameter. Drop a pin on the property and a labeled pin on each important destination. Use a clean Mapbox street style. The resulting image URL must be publicly fetchable so Airtable can render it.

6. Compute an overall commute score from 1 (very poor) to 10 (excellent). Use this rough mapping per destination drive time: 10 min or less = great, 10 to 20 min = good, 20 to 30 min = ok, 30 to 45 min = weak, over 45 min = poor. Average across destinations and round to the nearest whole number. Destinations the user flags as high-importance (a boolean column on the Important Destinations row) should count double.

7. Write a one-paragraph plain-English location summary, 3 to 5 sentences, that calls out anything notable about this property's location: short or long airport commute, easy or slow highway access, isolation from transit, walkable downtown, etc. Ground the language in the isochrone reach and the matrix drive times so it's honest and scannable.

8. Call Airtable Update Record on the new property row to populate the following fields. Create any that don't exist yet:

- "Location Summary" (long text): the paragraph from step 7.

- One number field per destination, named "Commute: <destination name>": the drive time in minutes.

- "Commute Score" (number, 1 to 10): the score from step 6.

- "Location Map" (URL field or attachment): the Mapbox Static Map Image URL from step 5.

Error handling: if the property address can't be geocoded, write "Could not geocode" to a "Location Status" field and skip the rest of the analysis. If a single destination address can't be geocoded, leave that destination's commute field blank but still complete the summary, score, and map with the remaining destinations.

Keep the tone of the location summary neutral and useful, like a buyer's agent giving a quick honest read. No marketing fluff.

What does this prompt do?

  • Spot every new property record in your Airtable base the moment it lands.
  • Fill in plain-English notes on the location and drive times to the places that matter to you.
  • Score each property from 1 to 10 so you can scan a long list and shortlist fast.
  • Drop a clean reach-and-commute map onto every row, no map editor required.

What do I need to use this?

  • An Airtable base with a Properties table and an Important Destinations table.
  • A Mapbox account (the free tier covers most personal real-estate searches).
  • The list of places that matter to you (office, train station, school, airport, etc.).

How can I customize it?

  • Change the reach windows (15, 30, 45 minutes) to your own thresholds.
  • Swap the driving profile for walking, cycling, or live-traffic driving.
  • Tweak which destinations weigh most heavily in the commute score, or how harshly long commutes are penalized.

FAQs

Do I need a paid Mapbox plan?
No. The free tier includes generous monthly quotas for geocoding, isochrones, distance matrix, and static maps that comfortably cover a personal home search or a small brokerage pipeline.
What if I'm looking at properties in another country?
Mapbox geocoding and routing work worldwide on the same workflow. Just make sure each property and destination row in Airtable has a full address (street, city, region, country).
Can I use walking or transit instead of driving?
Driving is the default. You can swap the profile to walking or cycling, or to driving with live traffic. Public transit is not one of the Mapbox routing profiles, so transit commute times are out of scope.
What happens if Airtable can't find the address?
If the address can't be geocoded, the workflow writes a short status note on the row and skips the rest of the analysis so your downstream views stay clean.
Can I run this on properties that are already in my base?
The trigger fires on brand-new rows. To re-analyze an older property, clear its analysis fields and ask Geni to re-run that single row, or duplicate the row to fire the trigger again.

Related templates

Run your nutrition clients' weekly meal plans from one console

See who is due, build a week of dinners on demand, swap anything you do not like, then send the recipe and grocery links yourself.

Instacart
Airtable
Gmail
App
Instagram UGC rights tracker and repost approval board

See every customer photo that tags your brand, ask for permission in one click, and repost only once a yes is on the record.

Instagram
Airtable
Slack Bot
App
A verification desk for every document your team scans

See every scan next to the details pulled out of it, correct anything wrong, and let only verified numbers reach your ledger sheet.

JigsawStack
Airtable
Google Sheets
App
Browse and shortlist creators without burning audit credits

Search creators for free, shortlist the best with your team, and spend an audit credit only when you decide someone is worth a closer look.

HypeAuditor
Airtable
Slack
App
Global operations exposure map for your sites and suppliers

Open one board each morning to see which of your facilities, suppliers and shipping lanes are sitting near trouble in the news right now.

GDELT
Airtable
Slack
App
Deal sourcing kanban board for your Harmonic saved searches

Drag every new company from your Harmonic saved searches through New, Tracking, Meeting and Passed, with a one click diligence brief on every card.

Harmonic
Airtable
Slack
App

Stop hand-checking commute times for every new listing.

Connect Airtable and Mapbox once, and Geni delivers a scored location brief on every property the moment it lands in your base.