Google Calendar · Google Sheets
Log new Google Calendar events in Google Sheets
Keep a searchable register of newly created Google Calendar events in Google Sheets. Each event adds one row with Event ID, Event title, Start, End, Status and Event URL. Prepare these exact headers in columns A-F, connect both accounts, select a calendar and worksheet, then publish. The primary calendar is preselected. Includes its own fictional English appointment example. Start and End retain the original ISO timestamps and offsets; all-day events use dates, with an exclusive end date. Values are written as plain text. The first poll establishes a baseline; create events afterwards. Existing events and later edits or cancellations are not synchronized. This is an append-only creation log, not a live calendar mirror. Follow the event link for current details.
- 1. Google Calendar · New Event
- 2. Google Sheets · Log calendar event
View template →Use templateGoogle Sheets · Google Calendar
Create Google Calendar events from new Google Sheets rows
Turn a spreadsheet schedule into Google Calendar events. Add Title, Start and End headers in row 1, then append one complete event per row. Start and End must be RFC 3339 timestamps with a time-zone offset, for example 2026-09-22T10:00:00+02:00 and 2026-09-22T11:00:00+02:00. End must be later than Start. Connect Google Sheets and Google Calendar with permission to create events, select the spreadsheet and worksheet, and choose a writable destination calendar. Includes its own fictional English planning example. Activate and let the first poll establish a baseline before adding rows. Existing rows and later edits are not imported; do not delete or reorder rows while active. Each new row creates a separate event. This is one-way event creation, not calendar synchronization or a conflict checker. It does not add attendees, send invitations or write event IDs back to the sheet. Calendar visibility and default reminders follow the destination calendar.
- 1. Google Sheets · New Row Added
- 2. Google Calendar · Create scheduled event
View template →Use templateGoogle Calendar · Google Sheets
Log Google Calendar event changes in Google Sheets
Keep a searchable change log in Google Sheets when an existing Google Calendar event is updated. Each change appends one row with Event ID, Event title, Start, End, Status, Updated and Event URL in columns A-G. Headers are optional: an empty worksheet works immediately, or add these exact labels in row 1 for a readable log. Connect Google Calendar and Google Sheets, browse to the calendar you want to watch, then browse to the destination spreadsheet and worksheet. The primary calendar is preselected and can be changed. Includes its own fictional English and German example. Start and End retain the original ISO timestamps and offsets; all-day events use dates with an exclusive end date. Values are written as plain text. The first poll establishes a baseline without adding history. Edit existing events after that baseline; recently created events within the roughly two-minute overlap window are treated as new and excluded, so allow new events to settle before editing them. New events and cancellations do not trigger this template. Rows contain the latest event snapshot, not a before-and-after comparison, and multiple changes between polls may be combined. Other Calendar changes can also produce a row even when the displayed title and times are unchanged. Earlier rows are not updated or removed, and manual reruns can append duplicates. This is an append-only change log, not a live calendar mirror; follow the event link for current details. Use a private worksheet when event details should remain restricted.
- 1. Google Calendar · Updated Event
- 2. Google Sheets · Append calendar change to the log
View template →Use template
