Send every client a polished weekly status update without the admin
Each Friday, WebRun opens the campaign activity tracker in Google Sheets and the press release log in Prowly, compiles the week's wins, pitches sent, coverage placed, and pending items for each client, drafts a structured weekly status email in Gmail, and leaves it unsent for the account lead to review and personalise before sending.
- No credit card
- Under $0.01 per run
- Cancel anytime
How can my PR agency automatically draft weekly status updates for every client?
Each Friday, WebRun opens the campaign tracker in Google Sheets and the press release log in Prowly, compiles the week's coverage, pitches, and reach data per client, and drafts a structured weekly status email in Gmail. Every draft is left unsent for the account lead to review and personalise, so clients receive polished, consistent updates without the admin burden.
- Weekly client status drafts are ready every Friday without manual data gathering
- Account leads spend minutes personalising rather than hours compiling data
- Clients receive consistent, well-structured updates that reinforce the agency's value
Built for PR agencies · account leads · account managers · PR directors
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 - compile weekly campaign activity
google.com How to Automate Google Sheets
WebRun opens Google Sheets to compile weekly campaign activity. - Open the campaign activity and coverage tracker sheet
- Filter activity to the current week for each client account
- Capture pitches sent, coverage placed, reach totals, and any pending actions
Done when The week's campaign activity is compiled per client with coverage and pitch metrics.
-
2
Prowly - pull press release and pitch activity
prowly.com
WebRun opens Prowly to pull press release and pitch activity. - Open Prowly and check story and press release activity for the week
- Note any releases distributed, story pitches filed, and coverage secured via Prowly outreach
- Flag any upcoming stories or distributions scheduled for next week
Done when Press release and story activity for the week is captured and upcoming items are noted.
-
3
Gmail - draft the client status email
gmail.com How to Automate Gmail
WebRun opens Gmail to draft the client status email. - Draft a structured weekly status email per client with this week's wins, coverage highlights, pitches sent, and items pending client input
- Note next week's planned activities and any upcoming announcements or embargoes
- Save as an unsent Gmail draft for the account lead to review, personalise, and send
Done when An unsent weekly status draft is saved in Gmail per client for account lead review.
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 send the weekly update to clients automatically?
No. Every status email is saved as an unsent Gmail draft for the account lead to review and personalise before sending. No client update goes out without a human reviewing it first.
Which data sources does it pull from for the status update?
It pulls from the campaign activity and coverage log in Google Sheets and the press release and story activity in Prowly, giving a complete picture of the week's PR work across both platforms.
Can it produce status updates for all clients in one run?
Yes. Each run loops through all active client accounts and produces a separate unsent email draft per client, so account leads arrive Monday morning with a tray of ready-to-send weekly updates.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.