Weekly podcast guest pitch list, built every Monday

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.

Additional information

What does this prompt do?

Searches the Podchaser catalog every Monday morning for shows in your target categories that are active, well rated, and regularly book guests.
Looks at recent guest history and listener reviews to judge whether each show is a real fit for someone like you.
Scores every candidate, picks the top 25, and writes a row per show into your Pitch Pipeline base in Airtable with the rationale already written.
Skips podcasts that are already in your Airtable so the list is always fresh, then posts a Slack summary with the top three picks of the week.

What do I need to use this?

A Podchaser account with API access for searching shows, guest credits, and reviews.
An Airtable base with a Pitch Pipeline table you want new podcast leads written into.
A Slack workspace and the channel where the weekly summary should be posted.
A short brief on you: your topics, the categories of podcasts you want to be on, and any minimum rating or recency bar.

How can I customize it?

Change the day and time. The default is Monday at 7am, but any weekly cadence works.
Tune the filters: target categories, minimum rating, minimum number of episodes, and how recent the last episode has to be.
Adjust shortlist size, scoring weights, the Airtable columns the agent fills, or the Slack channel the recap goes to.

Frequently asked questions

How does it decide which podcasts make the shortlist?

It scores each candidate on category fit, average rating, how recently they published, and whether they regularly book guests in your space, then takes the top 25.

Will it ever pitch me to the same podcast twice?

No. Before adding anything new, it checks your Airtable Pitch Pipeline and skips shows that are already there.

Do I have to write the pitch rationales myself?

No. For every shortlisted podcast it writes a two-sentence why this show note that you can use as the starting point for your outreach.

Can I run it more or less often than weekly?

Yes. The schedule is just a setting. You can move it to twice a week, monthly, or any cadence that matches how fast you actually pitch.

What if I want a different set of categories?

You can edit the target categories, ratings bar, and recency rules at any time and the next run will use the new criteria.