Auto-fill streaming options for new Airtable watchlist titles

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.