Automated ShipHero Returns Grading Worklist
Every morning, WebRun opens ShipHero, finds all returned items that are received but not yet graded, ranks them by how many days they have been sitting ungraded, and writes a prioritized worklist to Google Sheets so the returns team works through the backlog efficiently.
How do I automatically track ungraded returns in ShipHero and prioritize them?
WebRun opens ShipHero every morning, finds all returned items that are received but not yet graded, ranks them by how long they have been waiting, and writes a prioritized list to a Google Sheet. The returns team works through the backlog oldest-first, with overdue items highlighted so nothing sits indefinitely.
- Ungraded return backlog is visible every morning before the returns shift starts
- Oldest items are worked first, preventing returns from sitting in limbo
- Overdue returns are highlighted automatically without manual sorting
Built for returns managers · warehouse operations teams · 3PL operators · ecommerce fulfillment teams
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
app.shiphero.comin a real browser with your saved login - no setup, no API keys. -
1
ShipHero - find received returns pending grading
shiphero.com
WebRun opens ShipHero to find received returns pending grading. - Open ShipHero and navigate to the Returns section
- Filter to returns with status Received but grading not yet completed
- Capture return ID, SKU, quantity, return reason, and receipt date for each item
- Sort by receipt date ascending so the oldest ungraded returns appear first
Done when All ungraded received returns are listed with their SKU, quantity, reason, and days waiting.
-
2
Google Sheets - write prioritized grading worklist
google.com
WebRun opens Google Sheets to write prioritized grading worklist. - Open the Returns Grading Worklist Google Sheet
- Clear the prior day's rows and write today's ungraded returns data
- Apply conditional formatting to highlight returns waiting more than your maximum hold days
Done when The Google Sheet shows today's grading worklist with overdue returns highlighted for immediate action.
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
Does it process refunds or restock items in ShipHero automatically?
No. Restocking and refund processing involve inventory adjustments and potential customer charges, so those actions stay with a human after the grading decision is made.
How does it determine what counts as overdue for grading?
You set the maximum hold days during setup. WebRun highlights any ungraded return older than that threshold in red so the team knows which items are past the acceptable grading window.
Can the returns team update grading status directly in the Google Sheet?
The Sheet is a daily worklist snapshot, not a live two-way sync. The team marks items as graded in ShipHero itself, and tomorrow's run will exclude anything completed.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.