All templates

Automated PR Client Coverage Report

Each week, WebRun opens Cision and the coverage log in Google Sheets, compiles media mentions with reach and sentiment data, drafts a structured client-ready report in Gmail, and leaves it unsent for the account lead to review and personalise before delivery.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
Every Monday at 9:00 AM WebRunorchestrates each step
1 Cision pull coverage data
2 Google Sheets compile reach and sentiment
3 Gmail draft the client report
In short

How can I automatically compile and draft client coverage reports each week?

Each week, WebRun opens Cision and your Google Sheets coverage log, compiles reach, sentiment, and top-placement data for the reporting period, and drafts a structured client coverage report in Gmail. The draft is left unsent for the account lead to review and personalise, so polished reports go out faster with no manual data gathering.

  • Weekly client reports are drafted and ready to personalise every Monday morning
  • Coverage metrics are compiled automatically with no manual data gathering
  • Clients receive consistent, polished reports without agency admin overhead

Built for PR agencies · account managers · communications teams · PR directors

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 www.cision.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Cision - pull coverage data
    cision.com
    WebRun in Cision: pull coverage data
    WebRun opens Cision to pull coverage data.
    • Open Cision and filter mentions to the current reporting period
    • Collect headline, outlet, reach, sentiment, and media type for each mention
    • Note any tier-one publications or high-reach placements to highlight

    Done when All coverage for the reporting period is collected with outlet, reach, and sentiment.

  3. 2
    Google Sheets - compile reach and sentiment
    google.com
    WebRun in Google Sheets: compile reach and sentiment
    WebRun opens Google Sheets to compile reach and sentiment.
    • Open the client coverage log and cross-reference with Cision data
    • Calculate total reach, breakdown by media type, and positive vs neutral vs negative sentiment split
    • Identify the top three placements by reach and any coverage gaps to flag

    Done when Summary metrics and top placements are compiled and ready to include in the report.

  4. 3
    Gmail - draft the client report
    gmail.com
    WebRun in Gmail: draft the client report
    WebRun opens Gmail to draft the client report.
    • Draft a structured coverage report email to the client contact with metrics summary and top-placement highlights
    • Include a coverage snapshot table and a brief commentary on key wins
    • Save as an unsent Gmail draft for the account lead to review, personalise, and send

    Done when A complete unsent coverage report draft is saved in Gmail for the account lead.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.cision.com
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Coverage report draft · Gmail
OutputWhat each run produces - An unsent Gmail draft client coverage report with total reach, sentiment split, top placements, and a commentary section ready for personalisation.
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 send the report to the client automatically?

No. Every report is saved as an unsent Gmail draft for the account lead to review, personalise, and send. No client communication goes out without a human reviewing it first.

Which coverage metrics does it include in the report?

It pulls total reach, media type breakdown, sentiment split, and top placements by reach from your Cision data and the coverage log, giving clients a clear snapshot of the period's PR performance.

Can it produce reports for multiple clients?

Yes. Each run can loop through multiple client accounts and produce a separate unsent draft per client, so the account team gets a tray of ready-to-send reports each Monday morning.

Keep going

Related templates

Automated PR Award and Speaking Deadline Tracker
Every Monday, WebRun scans your award and speaking opportunity tracker in Google Sheets for deadlines in the next two weeks, checks draft entry status for each in Prowly, and posts a prioritised Slack alert so your team submits every opportunity on time.
Google Sheets›Prowly›Slack
Automated PR Brand Sentiment Spike Alert
Every few hours, WebRun checks Cision for unusual spikes in client brand mentions, measures sentiment shift, and posts an immediate Slack alert to the account team when negative coverage or mention volume crosses your threshold.
Cision›Google Sheets›Slack
Automated PR Media Coverage Monitoring Digest
Every morning, WebRun pulls fresh media mentions for all your clients from Cision, de-duplicates them, and posts a clean organised digest to Slack so your team starts the day knowing what coverage landed overnight.
Cision›Google Sheets›Slack

Put this on autopilot.

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

Deploy this workflow Talk to us