All templates

Automated Interior Design Sample Return Tracking

Every morning, WebRun checks your sample tracking Google Sheet for fabric swatches and product samples approaching their return deadline, posts a Slack alert to your team for any due within three days, and drafts a courteous return reminder email for any client who has held a sample past the agreed return date.

Runs on WebRun · Strict Lockdown policy
Every day at 8:00 AM WebRunorchestrates each step
1 Google Sheets check sample return deadlines
2 Slack alert team to approaching due dates
3 Gmail draft client return reminder emails
In short

How do I track fabric and sample return deadlines for interior design projects?

WebRun checks your sample tracking Google Sheet every morning for fabric swatches and product samples approaching or past their return deadline. It posts a Slack alert to your team for anything due within three days, and drafts a courteous return reminder email in Gmail for any client holding a sample past the agreed date, ready for your review before sending.

  • No sample return deadline slips past without your team knowing
  • Overdue samples get a courteous draft reminder within 24 hours of the deadline passing
  • Your sample library is tracked without manual spreadsheet checking every morning

Built for interior designers · interior decorators · design studios managing sample libraries · decorators loaning fabric swatches to clients

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

  2. 1
    Google Sheets - check sample return deadlines
    google.com
    WebRun in Google Sheets: check sample return deadlines
    WebRun opens Google Sheets to check sample return deadlines.
    • Open the sample tracking Google Sheet
    • Filter to samples that are currently out with a client and have a return deadline within the next three days or already past due
    • Capture the sample name, type, client name, date sent, and agreed return date for each

    Done when Every sample approaching or past its return deadline is captured with client details and due date.

  3. 2
    Slack - alert team to approaching due dates
    slack.com
    WebRun in Slack: alert team to approaching due dates
    WebRun opens Slack to alert team to approaching due dates.
    • Post a daily alert to your team Slack channel listing samples due back within three days
    • Highlight any samples already past their return date at the top of the list
    • Include the client name, sample type, and how many days until or since the return deadline

    Done when Your team has a clear internal view in Slack of all samples approaching or past their return date.

  4. 3
    Gmail - draft client return reminder emails
    gmail.com
    WebRun in Gmail: draft client return reminder emails
    WebRun opens Gmail to draft client return reminder emails.
    • Draft a courteous return reminder email for any client whose sample is past the agreed return date
    • Reference the specific sample name and the original return date in the message
    • Save the draft to Gmail Drafts for your review. Do not send without your approval.

    Done when A Gmail draft return reminder exists for every client holding a sample past the agreed deadline.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
sheets.google.com
ScheduleRuns automatically on this cadence
Every day at 8:00 AM
DeliveryHow each run's result reaches you
Sample return alert · Slack
OutputWhat each run produces - A Slack team alert listing samples due back within three days and Gmail draft return reminder emails for clients holding overdue samples.
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 return reminders to clients automatically?

No. Every reminder email is saved as a Gmail draft for your review. WebRun never sends a message to a client without your explicit approval. The Slack alert is internal only and posts automatically.

How do I add new samples to the tracking sheet?

Add a row to your Google Sheet with the client name, sample type, date sent, and agreed return date. WebRun picks it up on the next morning run without any extra setup.

What happens when a sample is returned?

Mark the sample as Returned in the Google Sheet and WebRun will skip it automatically on future runs, so you never receive an alert for a sample already back in your studio.

Put this on autopilot.

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