All templates

Automated Loop Returns Reporting

Every Monday, WebRun opens Loop Returns, pulls last week's return reasons by product and SKU, appends the counts to a trend sheet in Google Sheets, and posts your team a short Slack summary of the worst offenders and the biggest movers.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 Loop Returns read returns and reasons
2 Google Sheets tally reasons by SKU
3 Slack flag the worst offenders
In short

How do I turn return reasons into a product-quality report?

WebRun turns your returns into a weekly product-quality report. Every Monday it reads last week's return reasons in Loop Returns, tallies the top reasons by product and SKU, updates a trend sheet in Google Sheets, and posts your team the worst offenders in Slack, so recurring quality issues surface early instead of hiding in the refund total.

  • Recurring quality issues surface in days, not at quarter-end
  • Every SKU's return rate tracked week over week in one sheet
  • The team sees the top return reasons without opening Loop

Built for Shopify merchants · e-commerce ops · DTC brands · product and merchandising 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 admin.loopreturns.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Loop Returns - read returns and reasons
    loopreturns.com
    WebRun in Loop Returns: read returns and reasons
    WebRun opens Loop Returns to read the return reasons.
    • Open Loop Returns and go to Analytics, then Reports
    • Pull last week's Return Reasons by product and by SKU
    • Capture the reason, product, SKU, and count for each return. Read only, never approve or close a return

    Done when Last week's returns are captured with their reason, product, and SKU.

  3. 2
    Google Sheets - tally reasons by SKU
    google.com
    WebRun in Google Sheets: tally reasons by SKU
    WebRun opens Google Sheets to tally the reasons by SKU.
    • Open your returns trend sheet in Google Sheets
    • Append this week's counts per SKU and reason
    • Compute each SKU's return rate and the change versus prior weeks

    Done when The trend sheet holds this week's reason and SKU tallies.

  4. 3
    Slack - flag the worst offenders
    slack.com
    WebRun in Slack: flag the worst offenders
    WebRun opens Slack to flag the worst offenders.
    • Post the top return reasons and the worst-offending SKUs to your team channel
    • Show the biggest movers versus last week first
    • Leave it for the team to act on. Never message shoppers or change a return

    Done when The team has this week's return-reason summary in Slack.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
admin.loopreturns.com
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Return-reason summary · Slack
OutputWhat each run produces - A weekly summary of the top return reasons and worst SKUs, with counts and the change versus prior weeks.
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 approve returns or refund customers?

No. WebRun only reads your Loop Returns analytics and reports the patterns. It never approves a return, issues a refund, or messages a shopper, so every return decision stays with your team.

Where do the return reasons come from?

Straight from the Loop Returns Analytics reports, which break returns down by reason, product, and SKU. WebRun pulls last week's report and tallies it, so the numbers match what you see in Loop.

Can it track whether a fix worked?

Yes. It appends each week's counts to your Google Sheet, so a SKU's return rate before and after a change sits side by side and you can see if the problem is shrinking.

Put this on autopilot.

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