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