⚙️ Google Cloud Setup (one-time)

1. Go to console.cloud.google.com → create a new project (or use an existing one)
2. Navigate to APIs & Services → Library → enable Google Calendar API
3. Go to APIs & Services → Credentials → Create Credentials → OAuth 2.0 Client ID
4. Set application type to Web application
5. Under Authorized JavaScript origins, add:
   https://kumarrajdevops.github.io
http://localhost:4000 (for local dev)
6. Copy the Client ID and paste it in the config below, then click Save

Configuration

OAuth Client ID

Your name(s) in roster (comma-separated, case-insensitive)

Timezone Asia/Kolkata (UTC+05:30)

Paste Roster from Excel

Select the roster table in Excel (including the header row) → Copy → click the area below → Paste (Ctrl+V / Cmd+V).

Also create all-day "Weekly Off" events for my days off

Manage Calendar Events

Fetch your existing roster events, review them, and delete any you no longer need.

From

To

Cleanup Old Events

Deletes all roster events (Shift 1, Shift 2, Weekly Off) older than 2 months from your Google Calendar.