Automated Silo Daily Produce Price Sheet
Every morning before the sales day starts, WebRun opens Silo, pulls today's costed inventory and market pricing by commodity and pack size, builds the daily price sheet in Google Sheets, and drafts a pricing email to each regular wholesale buyer, leaving it unsent in Gmail for your sales team to review.
How do I build a daily produce price sheet and get buyer pricing emails ready to send?
Every morning before the sales day starts, WebRun opens Silo and pulls today's costed inventory and market pricing by commodity and pack size. It builds the daily price sheet in Google Sheets and drafts a pricing email to each regular wholesale buyer, leaving every draft unsent in Gmail so your sales team can review and send it.
- The price sheet is ready before the first sales call of the day
- Every regular buyer has a pricing email drafted and waiting for review
- Out-of-stock and held items never make it onto the sheet
Built for fresh-cut produce wholesalers · produce sales teams · wholesale account managers · produce packers and shippers
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
usesilo.comin a real browser with your saved login - no setup, no API keys. -
1
Silo - pull today's costed inventory and pricing
- Open Silo and pull today's on-hand inventory with current cost and market price by commodity and pack size
- Note any commodity with a notable price move from yesterday
- Flag any item that's out of stock or on quality hold so it's left off the sheet
Done when Today's costed inventory and pricing is pulled for every sellable commodity.
-
2
Google Sheets - build the daily price sheet
google.com
WebRun opens Google Sheets to build the daily price sheet. - Open the daily price sheet template
- Fill in today's price by commodity, pack size, and grade
- Highlight any commodity with a price move of 10 percent or more from yesterday
Done when Today's price sheet is complete and ready to share.
-
3
Gmail - draft pricing emails to regular buyers
gmail.com
WebRun opens Gmail to draft pricing emails to regular buyers. - Draft a pricing email to each regular wholesale buyer with their usual items and today's prices
- Leave every draft unsent in Gmail Drafts for your sales team to review before sending
- Never send pricing to a buyer without a person approving it first
Done when A reviewable pricing draft exists in Gmail for every regular buyer.
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
Will it send today's prices to buyers without review?
No. Every buyer pricing email is drafted and left unsent in Gmail Drafts. Your sales team reviews and sends each one, so no price ever reaches a customer without a person checking it first.
Where does the pricing come from?
It reads the current cost and market price already recorded in Silo for each commodity and pack size. WebRun does not set or estimate prices on its own.
What about items that are out of stock?
Anything out of stock or on quality hold in Silo is left off the price sheet and out of the buyer drafts automatically, so you never quote product you can't ship.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.