Green Bean Studio · Practical Tools

Family Calendar Bridge

Google Calendar helper

Keep family plans visible at work.

A small Apps Script that scans a family calendar and invites your work email to events you choose, so school nights, appointments, and pickup changes do not vanish between calendars.

Family Calendar School conference Soccer pickup Vet appointment
Invites
Work Calendar School conference Soccer pickup Vet appointment

Invite, do not copy

The bridge adds your work email as a guest to selected family events instead of storing private details in Green Bean.

Filter the noise

Use keywords, calendars, and a sync window so only the events that matter during the workday cross over.

Runs on Google

The script runs inside your Google account on a schedule you control.

Template

Copyable Script Status

The script exists as a Green Bean Apps Script project and is being packaged into a public copyable template. For now, use the setup guide below as the product spec and checklist.

Setup

First Run Checklist

  1. Copy the Apps Script template into your Google account once the template link is published.
  2. Set the source family calendar, destination work email, sync window, excluded keywords, and dry-run mode.
  3. Run the script in dry-run mode and inspect which events would receive invitations.
  4. Turn dry-run off and test with one harmless event.
  5. Add a time trigger so the bridge checks for new family events automatically.

Permissions

The script needs calendar access so it can read selected source events and invite your work email. Green Bean does not receive your calendars.

Troubleshooting

If invites do not appear, confirm the source calendar ID, destination email, sync window, and whether dry-run mode is still enabled.

Stop syncing

Delete the Apps Script trigger. Existing calendar invitations remain under your Google account’s control.