Daily Apple and Spotify podcast chart digest in Slack

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.

Additional information

What does this prompt do?

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 do I need to use this?

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 can I 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.

Frequently asked questions

Which charts does this cover?

Apple Podcasts and Spotify chart positions for any category and country combination Podchaser supports. You pick the list, for example Business in the US, Marketing in the UK, and Technology in both.

What if my team only cares about one country or one platform?

You can scope the digest to just Apple or just Spotify, and to a single country. The categories, countries, and platforms are all configurable.

Where does yesterday's data come from?

From a Google Sheet that the workflow itself maintains. Each run appends today's rankings as a new snapshot, so the next run always has a fresh baseline to diff against.

Why is the digest so short?

It is designed for ops and PR teams who skim Slack first thing in the morning. You get one sentence per movement with just enough context to decide whether to dig in.

Can I send the digest somewhere other than Slack?

Yes. The default is a Slack channel, but you can adapt it to email or another destination by adjusting the workflow after it is created.