Automated Ad Spot Tracking
Every morning, WebRun opens the ad spot tracker in Google Sheets and checks for sponsor reads due in the next seven days, drafts a deadline reminder email for the host for any upcoming read, and posts a Slack alert listing each read with its episode, sponsor name, and deadline so nothing slips.
How do I automatically track and get reminded about podcast ad spot deadlines?
Every morning, WebRun checks the ad spot tracker in Google Sheets for sponsor reads due within seven days, drafts a reminder email for the host in Gmail, and posts a Slack alert listing each read with its sponsor, episode, read type, and deadline. Reads due within 48 hours are flagged at the top so nothing is missed.
- No sponsor read is missed or recorded late due to a missed deadline
- Reads due within 48 hours are flagged at the top of every Slack alert
- The team tracks every active ad spot in one place without manual calendar checks
Built for podcast hosts · podcast producers · media sales teams · independent podcasters
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
docs.google.com/spreadsheetsin a real browser with your saved login - no setup, no API keys. -
1
Google Sheets - find ad reads due in the next seven days
google.com
WebRun opens Google Sheets to find ad reads due in the next seven days. - Open the ad spot tracker sheet
- Find rows where the ad read due date falls within the next seven days and the status is not marked as Recorded
- Collect the sponsor name, episode title, read type (pre-roll, mid-roll, or post-roll), and due date for each row
Done when Every upcoming ad read due within seven days is identified with its details.
-
2
Gmail - draft a reminder for each upcoming read
gmail.com
WebRun opens Gmail to draft a reminder for each upcoming read. - Draft a reminder email to the host listing each upcoming ad read with the sponsor name, episode, and deadline
- Include the read brief or script link from the tracker if one is noted
- Leave the email as a draft for the host to send to themselves or the production team if needed
Done when A draft reminder email is saved in Gmail for the host covering all upcoming reads.
-
3
Slack - post a deadline alert to the team
slack.com
WebRun opens Slack to post a deadline alert to the team. - Post a Slack alert to the podcast channel listing each ad read due this week with the sponsor name, episode title, read type, and deadline
- Flag reads due within 48 hours at the top so the team can prioritize
- If no reads are due within seven days, post a brief confirmation that the ad schedule is clear
Done when The team has a Slack alert with every upcoming ad read and its deadline.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it contact sponsors or send anything externally?
No. All alerts go internally to Slack and Gmail as a draft. WebRun never contacts a sponsor or sends anything externally. Any sponsor communication is written and sent by the host or producer.
How do I mark a read as recorded in the tracker?
Update the Status column in Google Sheets to Recorded once the read is done. WebRun checks that column each morning and automatically skips any row marked as Recorded.
What if I have a large volume of ad reads across several episodes?
WebRun lists every upcoming read in one Slack message, sorted by deadline, with reads due within 48 hours flagged at the top. You can filter or sort the Google Sheets tracker by episode or sponsor to manage a full calendar.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.