Friday alert when competitors show up on podcasts

Build me an agent workflow that runs every Friday at 3:00pm Eastern Time and posts a roundup of fresh podcast appearances by people on my competitive watchlist.

Trigger: cron, Fridays at 15:00 America/New_York.

Inputs the agent should expect:

1) A Google Sheets spreadsheet ID. Tab one is the watchlist with columns: Name, Company, Role (competitor / target account / analyst / other), Notes. Tab two is the state log with columns: Name, Episode ID, Show, Episode Title, Publish Date, Reported At.

2) A Slack channel ID for the competitive intel channel.

What the agent should do on each run:

Step 1. Use Google Sheets Get Values to read the watchlist tab. Skip the header row and any rows missing Name or Company.

Step 2. Use Google Sheets Get Values to read the state log tab so you have the set of (Name, Episode ID) pairs that have already been reported. Treat that as the dedupe key.

Step 3. For each watchlist entry, call Podchaser Search Credits filtered to that person's name plus their company affiliation, restricted to credits added or episodes published in the last 7 days. Be strict about name matching, since common names will produce false positives. Prefer matches where the credit role is host or guest and the affiliated company on the credit matches (or is reasonably close to) the company in the watchlist.

Step 4. For every credit that is not already in the state log, call Podchaser Get Episode by Identifier to pull the episode title, show name, publish date, episode URL, and a transcript snippet around the watched person's name.

Step 5. For each new episode, decide if it is relevant to our market or just a personal-interest hobby appearance (true crime cameo, parenting podcast, fantasy football, etc.). Skip the noise. Use the transcript snippet, show name, and show category to judge. When in doubt, include it but flag it as borderline.

Step 6. If at least one relevant new appearance was found, use Slack Send a Message to post to the configured channel. Format: a short header like "Tracked podcast appearances this week" followed by one bullet per appearance with the person's name and company, the show name, the episode title as a link, the publish date, and a one-sentence summary of what they discussed pulled from the transcript snippet. Group multiple appearances by the same person under that person.

Step 7. If there were zero relevant new appearances, still post to the channel with a single line: "No new tracked appearances this week." Do not go silent.

Step 8. Use Google Sheets Append Values to append a row to the state log tab for every new appearance you fetched in step 4 (whether or not it ended up posted), so the same episode is not re-evaluated next week. Columns: Name, Episode ID, Show, Episode Title, Publish Date, Reported At (use the run timestamp).

Operational notes for the agent:

- Podchaser uses query points; batch fields per call and avoid running Get Episode by Identifier on credits already in the state log.

- If Podchaser returns rate-limit errors, respect Retry-After and continue.

- If a watchlist row is malformed, skip that row and continue rather than failing the whole run.

- Keep the Slack message under ~25 bullets; if there are more, link the rest as a thread reply or summarize the long tail in one line.