Daily podcast chart movement digest in Slack
Every weekday at 8am ET, get a Slack digest of overnight movers on the Apple and Spotify podcast charts for your tracked categories and countries.
Integrations
Podchaser
Google Sheets
Slack
Type
Categories
- Marketing
- Operations
Build me an agent workflow that runs every weekday (Monday through Friday) at 8:00am ET and posts a podcast chart movement digest to a Slack channel. The workflow should track a configured list of categories and countries on both the Apple Podcasts and Spotify charts. A reasonable starting set is Business, Marketing, and Technology in the US and UK, but make the list easy to edit at the top of the agent's instructions.
For each (category, country, platform) combination, call Podchaser's Get Charts to retrieve today's chart positions. Then read yesterday's snapshot from a Google Sheet history tab using Google Sheets Get Values. Diff the two to compute, per chart: brand-new entrants (podcasts on today's chart that were not on yesterday's), the three biggest climbers (largest positive rank deltas), the three biggest droppers (largest negative rank deltas), and any podcast that crossed into the top 10 from outside it.
For each highlighted podcast, enrich it by calling Podchaser Get Podcast by Identifier to pull the description and recent episode titles, and use that to write a one-line 'why it matters' note. Keep the prose tight: one sentence per movement, no fluff, no filler. Group the digest by chart (e.g. 'Apple Business, US' as a section header), then list new entrants, climbers, droppers, and top-10 crossings.
Send the finished digest to a Slack channel using Slack Send a Message. The channel should be configurable; default it to a placeholder like #podcast-charts. Use Slack mrkdwn so section headers are bold and movements are easy to scan.
After posting, append today's raw rankings to the same Google Sheet using Append Values, with one row per (date, platform, country, category, rank, podcast id, podcast name). This becomes tomorrow's baseline. If the sheet has no prior data on the first run, skip the diff and just append today's snapshot with a note in Slack that the baseline has been seeded.
Inputs to expose for the user to configure: the list of (category, country) pairs, the platforms to include (Apple, Spotify, or both), the Google Sheet ID and tab name, the Slack channel, and the run time/timezone. Trigger: cron, weekdays at 08:00 America/New_York.
What it does
- Pulls fresh Apple Podcasts and Spotify chart rankings for the categories and countries you care about, like Business, Marketing, and Technology in the US and UK.
- Compares this morning's chart against yesterday's snapshot from your Google Sheet to find new entrants, the three biggest climbers, the three biggest droppers, and any podcast that just crossed into the top 10.
- Writes a tight narrative digest with a one-line 'why it matters' note for each movement, using the show's description and recent episode titles for context.
- Posts the digest to a Slack channel at 8am ET every weekday and appends today's rankings back to the sheet so tomorrow's run has a clean baseline.
What you’ll need
- A Podchaser account with API access for chart and podcast lookups.
- A Google account with a Sheet where the workflow can read yesterday's rankings and append today's snapshot.
- A Slack workspace and the channel where the digest should land.
- Your list of categories and countries to track, for example Business in the US and Technology in the UK.
How to customize it
- Change the run time or schedule, for example 7am ET or twice a day.
- Add or remove categories and countries, or focus on Apple only or Spotify only.
- Tune the digest format, like reporting top five climbers instead of three, or only flagging shows that crossed the top 25.
Use cases
- Daily Digests
- Research & Monitoring
- AI Reports
