Automatic Google Sheets Deadline Blocking
Every morning, WebRun opens your tracking spreadsheet in Google Sheets, reads every row with a due date in the next seven days, creates or updates a calendar block for each one on your own Google Calendar, and sends you a WhatsApp list of what is due today and anything already past due.
How do I turn a spreadsheet of due dates into calendar blocks automatically?
WebRun opens your Google Sheets tracker every morning and reads every open row due in the next seven days. It creates or updates a matching block on your own Google Calendar with no guests, then sends you a WhatsApp list of what is due today and what has already slipped.
- Every due date in the sheet has a place in your day
- Past due rows are named every morning instead of quietly ageing
- Changing a date in the sheet moves the calendar block for you
Built for small business owners · operations teams · freelancers · project coordinators
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
docs.google.com/spreadsheetsin a real browser with your saved login - no setup, no API keys. -
1
Google Sheets - read rows with due dates
docs.google.com
WebRun opens Google Sheets to read rows with due dates. - Open the tracking spreadsheet you point WebRun at
- Read every row with a due date falling in the next 7 days, plus anything already past due and not marked done
- Capture the task name, owner, due date, and status from each row
- Skip rows marked done or cancelled
Done when Every open row due in the next 7 days has been captured with its owner and date.
-
2
Google Calendar - block the work in
calendar.google.com
WebRun opens Google Calendar to block the work in. - Open your Google Calendar
- Create a time block on the due date for each task that does not already have one
- Update the time or title on existing blocks when the sheet has changed
- Create events on your own calendar with no guests. Never send an invitation to anyone else
Done when Every open task due this week has a matching block on your calendar.
-
3
WhatsApp - send today's list
whatsapp.com
WebRun opens WhatsApp to send today's list. - Send yourself a short list: due today, due this week, and already past due
- Put past due items first with how many days they have slipped
- Note anything whose calendar block moved because the sheet changed
Done when You have today's due list on WhatsApp.
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 calendar invitations to my team?
No. Every event is created on your own calendar with no guests, so nobody receives an invitation. Sharing a block with a colleague stays a manual step you take yourself.
Does it edit my spreadsheet?
No. The sheet is read-only. WebRun reads task names, owners, due dates, and status, and writes nothing back, so your formulas and formatting stay untouched.
What if I move a due date in the sheet?
The calendar block moves with it on the next run. WebRun matches blocks to rows by task name, so a changed date updates the existing event instead of creating a second one.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.