Auto-enrich an Airtable watchlist with where to stream

Build me an agent workflow that auto-enriches my Airtable watchlist with where I can actually stream each title.

Trigger: an Airtable poll trigger on the new_record event type, pointed at a configurable base and table (default field name for the watchlist is "Watchlist"). The base ID, table ID, and country code (default "us") should all be exposed as configurable inputs on the workflow.

For each new record the trigger delivers, the agent should:

1. Read the Title field (required) and the Year field (optional) from the new Airtable record. Also read an optional Type field that may say "movie" or "series" to constrain the match.

2. Call Streaming Availability's "Search Shows by Title" operation with the title phrase and the configured country code. From the candidates returned, pick the closest match by year first, then by media type, then by popularity. If no candidate is within +/- 1 year of the supplied year, treat it as no match.

3. Call Streaming Availability's "Get a Show" operation with the matched show ID and the configured country code to pull the full streaming option list, IMDb rating, runtime, and image.

4. From the streaming options, collect: the distinct streaming services (e.g. Netflix, Prime Video, Disney+, Max), the offer type for each (subscription, rent, buy, addon, or free with ads), and the deep link for the cheapest/best option (prefer subscription over rent over buy). Round IMDb rating to a 0-10 scale even though the API returns 0-100.

5. Use Airtable's "Update Record" operation to write back to the same record in the same table with these fields (use typecast=true so multi-selects and single-selects auto-create options as needed):

- Streaming Services: multi-select of every service the title is on right now

- Offer Type: single-select set to Subscription, Rent, or Buy (whichever is cheapest available)

- Direct Link: URL to the best deep link

- IMDb Rating: number, 0-10 scale, one decimal

- Runtime: number in minutes (movies) or text "~X min/episode" (series)

- Status: single-select set to "Available now" if at least one streaming option exists in the country, otherwise "Not currently streaming"

- Lookup Notes: short text. Leave empty on a clean match. If the title could not be found, write a one-sentence note like "No close match for 'X' (1999) in US; check spelling or try a different year." If the title was found but is not on any service in this country, write "Found but not streaming in US right now."

Never fail silently. If Streaming Availability returns zero candidates or the chosen candidate has no offers in the country, still update the row with Status and Lookup Notes so the user can see the lookup happened.

Keep the agent prompt focused: the model is doing fuzzy match judgment (year + type disambiguation) and prose for the notes column. Everything else is a straight pass-through from the lookup to the record.

Additional information

What does this prompt do?

Watches your Airtable watchlist base and reacts the moment a new title is added.
Identifies the right movie or show using the title and an optional year, even when there are several lookalikes.
Fills in the streaming services, a one-tap link to the title, the offer type (subscription, rent, or buy), the IMDb rating, and the runtime.
Marks each row Available now or Not currently streaming, with a short note when nothing matched, so the list never goes stale silently.

What do I need to use this?

An Airtable login with access to the base that holds your watchlist.
A watchlist table with a Title column and a few empty columns for the streaming details (services, link, rating, runtime, status, notes).
A Streaming Availability account so we can look up where each title is streaming.
The country code you want availability for, like us, gb, or ca.

How can I customize it?

Point it at any base and table you want, and rename the destination columns to match what you already use.
Switch the country code to match where you actually watch, or run separate copies for each household member.
Limit the streaming services you care about, like Netflix and Max only, instead of every option.

Frequently asked questions

What if the same movie has several lookalikes with the same name?

The agent uses the year you typed in (and whether it is a movie or a TV series) to pick the closest match. If you leave the year blank, it picks the most popular result.

Which streaming services does it cover?

All the big subscription services like Netflix, Prime Video, Disney+, Max, Hulu, Apple TV+, and Paramount+, plus rent and buy options on Apple TV, Amazon, and Google Play, across 60+ countries.

What happens if the title cannot be found?

The row is marked Not currently streaming and a short note is written into a Lookup Notes column so you know it was checked and why nothing landed.

Does this update old rows when a title shows up on a new service?

Not by default. This prompt fills rows in once when they are added. If you want a weekly refresh of every row, ask Geni to build that as a follow-up workflow.

Can I use it with a Notion or Google Sheets watchlist instead?

This version uses Airtable as the trigger. Ask Geni to swap the source to Notion or Sheets and it will rebuild the workflow against that tool.