All templates

Automated Sponsor Follow-Ups

Every Monday, WebRun opens the sponsor tracker in Google Sheets, finds deals expiring within the next 30 days or sponsors who have gone quiet for more than two weeks, drafts a personalized renewal or check-in email for each, and posts a Slack alert so the host can review and send the drafts before the relationship cools.

Runs on WebRun · Strict Lockdown policy
Every Monday at 9:00 AM WebRunorchestrates each step
1 Google Sheets find expiring deals and quiet sponsors
2 Gmail draft a follow-up email per sponsor
3 Slack alert the host to review and send
In short

How do I automatically follow up with podcast sponsors before their deals expire?

Every Monday, WebRun scans the sponsor tracker in Google Sheets for deals expiring within 30 days or contacts gone quiet for more than two weeks, drafts a personalized renewal email in Gmail for each, and posts a prioritized Slack list. No email reaches a sponsor until the host reviews and sends the draft.

  • No sponsor deal expires without a timely renewal conversation
  • Personalized follow-up drafts are ready in Gmail every Monday without manual writing
  • The host decides what goes to sponsors, with no email sent without approval

Built for podcast hosts · podcast producers · independent podcasters · media sales teams

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens docs.google.com/spreadsheets in a real browser with your saved login - no setup, no API keys.

  2. 1
    Google Sheets - find expiring deals and quiet sponsors
    google.com
    WebRun in Google Sheets: find expiring deals and quiet sponsors
    WebRun opens Google Sheets to find expiring deals and quiet sponsors.
    • Open the sponsor tracker sheet
    • Find rows where the deal end date falls within the next 30 days
    • Find rows where the last contact date is more than 14 days ago and no renewal is confirmed
    • Collect the sponsor name, contact email, deal end date, and any notes on what was agreed

    Done when Every expiring or quiet sponsor is identified with their contact details.

  3. 2
    Gmail - draft a follow-up email per sponsor
    gmail.com
    WebRun in Gmail: draft a follow-up email per sponsor
    WebRun opens Gmail to draft a follow-up email per sponsor.
    • Draft a short, personalized renewal or check-in email for each identified sponsor
    • Reference the deal end date and include a warm note about continuing the partnership
    • Leave each email as a draft, unsent, for the host to review and adjust before sending

    Done when A draft follow-up email is ready in Gmail for each sponsor needing attention.

  4. 3
    Slack - alert the host to review and send
    slack.com
    WebRun in Slack: alert the host to review and send
    WebRun opens Slack to alert the host to review and send.
    • Post a Slack alert listing each sponsor who needs a follow-up this week with their deal end date
    • Confirm that draft emails are ready in Gmail for the host to review
    • Flag the most urgent renewals at the top of the list

    Done when The host has a prioritized Slack list of sponsor follow-ups and knows drafts are ready in Gmail.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
docs.google.com/spreadsheets
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Follow-up list · Slack
OutputWhat each run produces - A prioritized Slack list of sponsors needing follow-up and a Gmail draft renewal email per sponsor, ready for host review before sending.
Text
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it email sponsors automatically?

No. WebRun drafts the renewal email in Gmail and flags it in Slack, but the email is never sent without the host reviewing and sending it manually. Every sponsor communication stays in your hands.

How does it know which sponsors to follow up with?

It reads the deal end date and last contact date columns in your Google Sheets sponsor tracker. Deals expiring within 30 days and sponsors not contacted in more than 14 days are flagged each Monday.

What if a renewal is already confirmed?

Sponsors with a confirmed renewal status in the sheet are skipped automatically. Mark the Renewal column as confirmed after you close the deal and WebRun will leave that row alone.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.