appscript.dev

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

Automation Beginner Calendar

Schedule personal habits and routines

Block recurring habits on Awadesh's calendar — gym, walks, deep-work mornings.

Updated Nov 5, 2025

Automation Beginner Calendar Sheets

Sync birthdays and anniversaries to Calendar

Populate recurring personal dates from a Sheet — the Northwind team rituals calendar.

Updated Nov 1, 2025

Automation Advanced Calendar

Generate recurring events with custom exceptions

Handle complex recurrence rules in code — every Tuesday except UK bank holidays.

Updated Oct 28, 2025

Automation Advanced Calendar

Auto-reschedule low-priority conflicts

Move flexible Northwind events around fixed ones — focus blocks bend, client calls don't.

Updated Oct 16, 2025

Automation Beginner Calendar Sheets

Build a contract-renewal calendar

Track Northwind's recurring-revenue renewal dates as calendar events for proactive sales.

Updated Oct 8, 2025

Automation Intermediate Calendar Sheets

Apply attendee rules by event type

Auto-invite the right Northwind people from a Sheet — design reviews get design, client calls get account leads.

Updated Oct 4, 2025

Automation Beginner Calendar

Auto-color-code events by keyword

Apply event colours based on title keywords — `[client]` red, `internal` blue.

Updated Sep 14, 2025

Automation Advanced Calendar

Import external iCal feeds into your calendar

Pull events from other systems into Northwind's calendar — e.g., a vendor's release calendar.

Updated Sep 10, 2025

Automation Intermediate Calendar Sheets

Build a class or course timetable generator

Lay out a Northwind training-term schedule as calendar events from a curriculum sheet.

Updated Sep 6, 2025

Automation Advanced Calendar Sheets

Build a shift-rota scheduler

Assign and rotate Northwind support shifts from a Sheet — fair distribution, week to week.

Updated Aug 29, 2025

Automation Beginner Calendar Gmail

Nudge organizers of agendaless meetings

Remind Northwind organisers to add details before their event starts.

Updated Aug 25, 2025

Automation Beginner Calendar

Enforce recurring no-meeting deep-work days

Block focus days automatically — Northwind teammates own Wednesdays.

Updated Aug 17, 2025

Automation Intermediate Calendar Forms

Create events from appointment-form submissions

Book slots from a Google Form into the Northwind appointments calendar automatically.

Updated Aug 13, 2025

Automation Intermediate Calendar Sheets

Schedule content as a publishing calendar

Drive a Northwind content plan from calendar events — title, channel, status.

Updated Aug 9, 2025

Automation Beginner Calendar Sheets

Show team PTO on a shared calendar

Sync time-off from the PTO sheet to a shared Northwind calendar — visibility for planning.

Updated Aug 5, 2025

Automation Intermediate Calendar

Add travel-time buffers before offsite events

Insert commute events before any Northwind meeting outside the studio.

Updated Aug 1, 2025

Automation Advanced Calendar Sheets Gmail

Build an interview-scheduling coordinator

Slot Northwind candidates into available interview windows from a Sheet of preferences.

Updated Jul 28, 2025

Automation Intermediate Calendar

Auto-decline meetings outside working hours

Protect Northwind schedules — decline invites that land outside 9-6 London time.

Updated Jul 20, 2025

Automation Intermediate Calendar Sheets

Build a room and resource booking system

Manage shared spaces in the Northwind studio through a Sheet — book by adding a row.

Updated Jul 12, 2025

Automation Intermediate Calendar Sheets

Mirror project deadlines as calendar events

Sync the Projects sheet due-date column to Northwind's calendar — they show up alongside meetings.

Updated Jul 4, 2025

Automation Intermediate Calendar

Auto-block focus time around meetings

Reserve prep and recovery slots automatically around every Northwind meeting.

Updated Jun 30, 2025

Automation Beginner Calendar Sheets

Bulk-create events from a Sheet

Add many Northwind calendar entries from rows in one run.

Updated Jun 22, 2025

Summaries

Email or post recaps of upcoming or past events.

13 articles

Automation Intermediate Calendar Gmail

Send a feedback survey after each event

Email attendees a survey link automatically after Northwind workshops or trainings.

Updated Oct 24, 2025

Automation Intermediate Calendar Sheets

Build a team-capacity view from calendars

Show how booked the Northwind team is this week — meeting hours per person.

Updated Oct 20, 2025

Automation Intermediate Calendar Gmail

Flag meetings that could have been emails

Detect short, agendaless, oversized meetings — the smell of bad calendar hygiene.

Updated Oct 12, 2025

Automation Intermediate Calendar Sheets Gmail

Send tiered deadline countdown reminders

Email Northwind teammates at 7, 3, and 1 days out from a Sheet of upcoming deadlines.

Updated Sep 30, 2025

Automation Beginner Calendar Sheets

Archive past events to a log sheet

Keep a searchable Northwind meeting history — every event logged with title, attendees, duration.

Updated Sep 26, 2025

Automation Beginner Calendar Gmail

Email a clean daily agenda each morning

Send Awadesh a list of today's Northwind events at 7am — no app needed.

Updated Sep 22, 2025

Automation Intermediate Calendar

Publish your free/busy availability

Share Northwind open slots without exposing meeting details — perfect for a booking page.

Updated Sep 18, 2025

Automation Intermediate Calendar Sheets

Track meeting attendance and no-shows

Log RSVPs against actual turnout for Northwind events — spot the chronic no-shows.

Updated Sep 2, 2025

Automation Intermediate Calendar Docs Drive

Export a printable monthly calendar PDF

Generate a Northwind schedule document each month — for the studio noticeboard.

Updated Aug 21, 2025

Automation Intermediate Calendar Sheets

Generate a timesheet from calendar events

Turn each week into billable hours, grouped by client tag in the event title.

Updated Jul 24, 2025

Automation Intermediate Calendar Gmail

Detect and report double-booked time

Flag overlapping events on Northwind calendars before they cause conflicts.

Updated Jul 16, 2025

Automation Intermediate Calendar Sheets

Build a meeting-time and cost auditor

Total the hours and dollars Northwind spends in meetings each week.

Updated Jul 8, 2025

Automation Beginner Calendar Gmail

Email yourself a weekly calendar summary

Send a Monday week-ahead digest of every Northwind meeting in the next seven days.

Updated Jun 26, 2025