Google Calendar automation
Create events from Sheets, sync calendars, and email weekly meeting summaries with Apps Script.
Event creation
Bulk-create or update events from a Sheet.
22 articles
Schedule personal habits and routines
Block recurring habits on Awadesh's calendar — gym, walks, deep-work mornings.
Mis à jour le 5 nov. 2025
Sync birthdays and anniversaries to Calendar
Populate recurring personal dates from a Sheet — the Northwind team rituals calendar.
Mis à jour le 1 nov. 2025
Generate recurring events with custom exceptions
Handle complex recurrence rules in code — every Tuesday except UK bank holidays.
Mis à jour le 28 oct. 2025
Auto-reschedule low-priority conflicts
Move flexible Northwind events around fixed ones — focus blocks bend, client calls don't.
Mis à jour le 16 oct. 2025
Build a contract-renewal calendar
Track Northwind's recurring-revenue renewal dates as calendar events for proactive sales.
Mis à jour le 8 oct. 2025
Apply attendee rules by event type
Auto-invite the right Northwind people from a Sheet — design reviews get design, client calls get account leads.
Mis à jour le 4 oct. 2025
Auto-color-code events by keyword
Apply event colours based on title keywords — `[client]` red, `internal` blue.
Mis à jour le 14 sept. 2025
Import external iCal feeds into your calendar
Pull events from other systems into Northwind's calendar — e.g., a vendor's release calendar.
Mis à jour le 10 sept. 2025
Build a class or course timetable generator
Lay out a Northwind training-term schedule as calendar events from a curriculum sheet.
Mis à jour le 6 sept. 2025
Build a shift-rota scheduler
Assign and rotate Northwind support shifts from a Sheet — fair distribution, week to week.
Mis à jour le 29 août 2025
Nudge organizers of agendaless meetings
Remind Northwind organisers to add details before their event starts.
Mis à jour le 25 août 2025
Enforce recurring no-meeting deep-work days
Block focus days automatically — Northwind teammates own Wednesdays.
Mis à jour le 17 août 2025
Create events from appointment-form submissions
Book slots from a Google Form into the Northwind appointments calendar automatically.
Mis à jour le 13 août 2025
Schedule content as a publishing calendar
Drive a Northwind content plan from calendar events — title, channel, status.
Mis à jour le 9 août 2025
Show team PTO on a shared calendar
Sync time-off from the PTO sheet to a shared Northwind calendar — visibility for planning.
Mis à jour le 5 août 2025
Add travel-time buffers before offsite events
Insert commute events before any Northwind meeting outside the studio.
Mis à jour le 1 août 2025
Build an interview-scheduling coordinator
Slot Northwind candidates into available interview windows from a Sheet of preferences.
Mis à jour le 28 juil. 2025
Auto-decline meetings outside working hours
Protect Northwind schedules — decline invites that land outside 9-6 London time.
Mis à jour le 20 juil. 2025
Build a room and resource booking system
Manage shared spaces in the Northwind studio through a Sheet — book by adding a row.
Mis à jour le 12 juil. 2025
Mirror project deadlines as calendar events
Sync the Projects sheet due-date column to Northwind's calendar — they show up alongside meetings.
Mis à jour le 4 juil. 2025
Auto-block focus time around meetings
Reserve prep and recovery slots automatically around every Northwind meeting.
Mis à jour le 30 juin 2025
Bulk-create events from a Sheet
Add many Northwind calendar entries from rows in one run.
Mis à jour le 22 juin 2025
Summaries
Email or post recaps of upcoming or past events.
13 articles
Send a feedback survey after each event
Email attendees a survey link automatically after Northwind workshops or trainings.
Mis à jour le 24 oct. 2025
Build a team-capacity view from calendars
Show how booked the Northwind team is this week — meeting hours per person.
Mis à jour le 20 oct. 2025
Flag meetings that could have been emails
Detect short, agendaless, oversized meetings — the smell of bad calendar hygiene.
Mis à jour le 12 oct. 2025
Send tiered deadline countdown reminders
Email Northwind teammates at 7, 3, and 1 days out from a Sheet of upcoming deadlines.
Mis à jour le 30 sept. 2025
Archive past events to a log sheet
Keep a searchable Northwind meeting history — every event logged with title, attendees, duration.
Mis à jour le 26 sept. 2025
Email a clean daily agenda each morning
Send Awadesh a list of today's Northwind events at 7am — no app needed.
Mis à jour le 22 sept. 2025
Publish your free/busy availability
Share Northwind open slots without exposing meeting details — perfect for a booking page.
Mis à jour le 18 sept. 2025
Track meeting attendance and no-shows
Log RSVPs against actual turnout for Northwind events — spot the chronic no-shows.
Mis à jour le 2 sept. 2025
Export a printable monthly calendar PDF
Generate a Northwind schedule document each month — for the studio noticeboard.
Mis à jour le 21 août 2025
Generate a timesheet from calendar events
Turn each week into billable hours, grouped by client tag in the event title.
Mis à jour le 24 juil. 2025
Detect and report double-booked time
Flag overlapping events on Northwind calendars before they cause conflicts.
Mis à jour le 16 juil. 2025
Build a meeting-time and cost auditor
Total the hours and dollars Northwind spends in meetings each week.
Mis à jour le 8 juil. 2025
Email yourself a weekly calendar summary
Send a Monday week-ahead digest of every Northwind meeting in the next seven days.
Mis à jour le 26 juin 2025