Weekly podcast guest pitch list

Every Monday at 7:00am, build me a fresh pitch list of podcasts I should target for guest appearances this week. The trigger is a cron schedule running Mondays at 07:00 in my local time zone.

Step 1. Search the Podchaser catalog using the Search Podcasts operation, filtered by my configured target categories (for example Entrepreneurship and SaaS), a minimum average rating, a minimum total episode count, and recent activity defined as having published at least one episode in the last 30 days. Pull a generous candidate set, roughly 100 to 150 shows, so there is room to score and rank.

Step 2. For each candidate podcast, call Podchaser Search Credits to see who they have hosted recently, especially across the last 10 to 20 episodes, so we can tell whether they regularly book outside guests in my space. Also call Podchaser Search Reviews on each candidate to gauge audience tone and what listeners praise or complain about.

Step 3. Score each podcast on fit using these inputs: category match against my target categories, average rating, recency of the last episode, whether the recent guest pattern shows outside guests in topics adjacent to mine, and any signal from reviews. Produce a single fit score from 0 to 100 and a shortlist of the top 25 podcasts.

Step 4. Before writing anything, call Airtable List Records on my Pitch Pipeline base to fetch the existing rows and dedupe. Skip any podcast already in the base (match on Podchaser show ID or Podchaser URL). For every remaining shortlisted podcast, call Airtable Create Records to write one row with the columns: Show Name, Host Name, Podchaser URL, Average Rating, Recent Guest Pattern (a short summary string), Fit Score, and Why This Podcast (a 2-sentence rationale you write).

Step 5. After the run, call Slack Send a Message to post a summary in my PR channel that includes how many new pitches were added this week, the top 3 podcasts by fit score with their show names and scores, and a one-line note if zero new shows were added.

Configuration I will provide: my target categories, minimum rating, minimum episode count, recency window in days, the Airtable base ID and Pitch Pipeline table name, the Slack channel for the recap, and a short personal brief describing my topics and ideal audience so the rationale and scoring are accurate.