All templates
For museum shop managers, gallery store buyers & visitor attraction retail

Forecast restocks for your next exhibit tie-in

Every Monday, WebRun reads upcoming exhibit dates from Google Calendar, checks each tie-in item's stock and sell-through in GiftLogic, and writes a restock forecast to a sheet so themed merchandise is stocked before the doors open.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every Monday at 9:00 AM WebRun
1 Google Calendar read upcoming exhibit dates
2 GiftLogic check tie-in merch stock
3 Google Sheets write the restock forecast
Run a sample
In short

How do I forecast merchandise restocks for an upcoming exhibit?

Every Monday WebRun reads upcoming exhibit dates from Google Calendar, then checks each themed tie-in item's stock, sell-through, and vendor lead time in GiftLogic. It writes a per-exhibit restock forecast to a Google Sheet with a suggested order-by date, so tie-in merchandise is on the shelf before the exhibit opens.

  • Themed merchandise is stocked before opening day
  • Order-by dates beat each vendor's lead time
  • You place every order, WebRun only forecasts the need

Built for museum shop managers · gallery store buyers · visitor attraction retail · merchandise planners

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

  2. 1
    Google Calendar - read upcoming exhibit dates
    calendar.google.com How to Automate Google Calendar
    WebRun in Google Calendar: read upcoming exhibit dates
    WebRun opens Google Calendar to read upcoming exhibit dates.
    • Open the exhibitions calendar
    • List exhibits opening in the next several weeks
    • Note each opening date and its theme

    Done when Every upcoming exhibit is listed with its opening date and theme.

  3. 2
    GiftLogic - check tie-in merch stock
    giftlogic.com How to Automate GiftLogic
    WebRun in GiftLogic: check tie-in merch stock
    WebRun opens GiftLogic to check tie-in merch stock.
    • Open GiftLogic and find merchandise tied to each exhibit theme
    • Read on-hand quantity and recent sell-through per item
    • Note the lead time from each item's preferred vendor

    Done when Each tie-in item has its stock, sell-through, and lead time.

  4. 3
    Google Sheets - write the restock forecast
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: write the restock forecast
    WebRun opens Google Sheets to write the restock forecast.
    • Open the exhibit restock forecast sheet
    • For each exhibit, show items likely to run short before opening
    • Suggest an order-by date that beats the vendor lead time

    Done when The sheet forecasts restocks with an order-by date per exhibit.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
calendar.google.com
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Restock forecast · Google Sheets
OutputWhat each run produces - A per-exhibit restock forecast listing tie-in items likely to run short, with a suggested order-by date that beats vendor lead time.
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 order the merchandise for me?

No. WebRun only writes a restock forecast with suggested order-by dates. You place any purchase order in GiftLogic yourself, so nothing is committed to a vendor without your say-so.

How does it link merchandise to an exhibit?

It matches each exhibit's theme from your Google Calendar to the tie-in items tagged for it in GiftLogic, so only relevant merchandise appears in that exhibit's forecast.

How does it decide the order-by date?

It compares projected sell-through before opening against each item's on-hand count and vendor lead time in GiftLogic, then works back to a date that lands stock in time.

Put this on autopilot.

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