All templates

Automated SASSIE Client Results Report Drafts

Every Monday, WebRun opens SASSIE, pulls the past week's completed and approved shops for each client program, compiles the scores, comments, and any flagged issues into a Google Sheet, and drafts a client ready summary email in Gmail for your account manager to review and send.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
Every Monday at 7:00 AM WebRunorchestrates each step
1 SASSIE pull the week's completed and approved shops
2 Google Sheets compile scores and flagged issues by client
3 Gmail draft the client summary email
In short

How do I compile weekly mystery shop results for a client?

Every Monday, WebRun pulls the past week's approved shops for each client program from SASSIE, compiles the scores and flagged issues into a Google Sheet, and drafts a client ready summary email in Gmail. Your account manager reviews and sends it, so every client report goes out checked, on schedule, and never automatically.

  • Client reports go out on schedule every Monday, never late
  • Poorly scoring locations get flagged instead of buried in an average
  • Every summary is reviewed by a person before a client sees it

Built for mystery shopping companies · client account managers · field audit agencies · market research firms

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

  2. 1
    SASSIE - pull the week's completed and approved shops
    sassieshop.com
    WebRun in SASSIE: pull the week's completed and approved shops
    WebRun opens SASSIE to pull the week's completed and approved shops.
    • Open SASSIE and filter shops to Approved status completed in the last 7 days
    • Group results by client program
    • Capture the score, key comments, and any flagged compliance issue for each shop

    Done when Every approved shop from the past week is pulled and grouped by client.

  3. 2
    Google Sheets - compile scores and flagged issues by client
    google.com
    WebRun in Google Sheets: compile scores and flagged issues by client
    WebRun opens Google Sheets to compile scores and flagged issues by client.
    • Open the client's Weekly Results sheet
    • Add a row per shop with location, score, and flagged issues
    • Calculate the program average score and completion count for the week
    • Highlight any location that scored below the client's threshold

    Done when The results sheet reflects every completed shop and this week's program average.

  4. 3
    Gmail - draft the client summary email
    gmail.com
    WebRun in Gmail: draft the client summary email
    WebRun opens Gmail to draft the client summary email.
    • Draft a summary email to the client's account manager with the week's average score, completion count, and any flagged locations
    • Link the results sheet in the draft
    • Leave the email unsent in Gmail for your team to review and send. WebRun never emails a client directly

    Done when A results summary draft is waiting in Gmail for every active client program.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
sassieshop.com
ScheduleRuns automatically on this cadence
Every Monday at 7:00 AM
DeliveryHow each run's result reaches you
Weekly results draft · Gmail
OutputWhat each run produces - A compiled weekly results sheet per client plus a Gmail summary draft ready for review.
Drafts
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 results report straight to the client?

No. WebRun drafts the summary email in Gmail and leaves it unsent. Your account manager reviews it and sends it themselves, so nothing reaches a client unchecked.

Which shops does it include?

Only shops marked Approved in SASSIE and completed in the last 7 days. Anything still pending edit or awaiting approval is left out until it clears QA.

Does it flag locations that scored poorly?

Yes. Any location scoring below the client's threshold is highlighted in the results sheet and called out in the draft email so it does not get buried in the average.

Keep going

Related templates

Automated SASSIE Completion Rate Digest
Every night, WebRun tallies each client program's shop completion rate in SASSIE, compares it against the pace needed to hit the target date, and posts a Slack digest so management can see which programs are falling behind before the client does.
SASSIE›Slack
Automated SASSIE Geo Verification Fraud Flags
WebRun checks each submitted shop in SASSIE for GPS coordinates that do not match the shop location or a visit duration that looks implausible, logs anything suspicious to a Google Sheet, and alerts your QA team in Slack to investigate before it reaches a client.
SASSIE›Google Sheets›Slack
Automated SASSIE Late Report Editing Alerts
WebRun checks SASSIE for submitted shop reports still waiting on an editor past your turnaround window, and pings your editing lead in Slack before a client's reporting deadline slips.
SASSIE›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