A Google Sheet powers a live farm stand board on the website. Scheduled reminders prompt the owner to update, and when she does, an automated email goes out to egg share subscribers. No code needed after setup.
How it works
The system reminds the owner to update, and handles everything after that.
Step 1
Two or three times a day, a scheduled ping asks the owner if the stand needs updating. Morning, midday, and after evening chores.
Step 2
Open the sheet on your phone, change a quantity, mark something sold out. Takes 30 seconds.
Step 3
The farm stand board on the site pulls from the sheet automatically. No publishing step.
Step 4
Egg share subscribers get a formatted update with what's available and what's coming.
The email
Sent automatically when the stand is updated. Clean, short, and useful.
Good morning! Here's what's on the stand today.
Egg share members: your dozen is already set aside. Message us if you need to skip this week.
Everyone else: first come, first served. Reply to claim or message us on Facebook.
Raven House Co. · Greenwood area pickup
ravenhouseco.ca · hello@ravenhouseco.ca
The backend
A plain Google Sheet. Update a cell, the website and email handle the rest.
| A · Item | B · Status | C · Notes | D · Price | E · Quantity | |
|---|---|---|---|---|---|
| 1 | Chicken Eggs (dozen) | available | Brown, cream, and blue-green | $6 | 8 dozen |
| 2 | Duck Eggs (half dozen) | available | Rich yolks, great for baking | $7 | 4 half-dozen |
| 3 | Oregano Bundle | limited | Dried, from the garden | $5 | 3 left |
| 4 | Goat's Milk Soap | coming soon | Lavender and unscented | $8 | |
| 5 | Soy Candles | coming soon | Hand-poured, seasonal scents | $14 | |
| 6 | Mixed Greens | sold out | Back Thursday | $4 | 0 |
One Google Sheet (free), one Formspree form for signups (free tier), one MailerLite automation for the email (free tier), a scheduled reminder via Zapier or Google Apps Script, and a few lines of JavaScript on the website to read the sheet. No monthly software fees. No CMS. No app. The system pings the owner two or three times a day to check if the stand needs updating. She opens the sheet on her phone, changes a number, and her customers get a clean email and a live website board.