Log Google Calendar event changes in Google Sheets
Append seven values in A:G when an existing event changes, including its update time and source link. Headers are optional. New events and cancellations are excluded; earlier rows stay unchanged.
App integration
Log Google Calendar events or changes in Google Sheets, or create events from new schedule rows. Choose a workflow for the direction you need.
Ready-made workflows
Keep a register of new events, record later event snapshots in a separate change log, or turn new schedule rows into calendar events. Each template handles one direction; combining them does not maintain a shared, synchronized record.
Append seven values in A:G when an existing event changes, including its update time and source link. Headers are optional. New events and cancellations are excluded; earlier rows stay unchanged.
Create an event from each new Title, Start and End row, using timestamps with explicit timezone offsets. No attendees, conflict check or event-ID writeback are configured, and later row edits do not reschedule it.
Append each new event's ID, title, start, end, status and link to six exact worksheet headers in A:F. Preserve its initial values as a creation log, without updating the row after later edits or cancellations.
Before activation
Choose creation logging, change logging or event creation from rows. Connect Google Calendar and Google Sheets, then select the intended calendar, spreadsheet and worksheet. Review the primary calendar preselection on logging templates; event creation needs a writable calendar.
For new-event logging, create Event ID, Event title, Start, End, Status and Event URL in A:F. The change log writes A:G with Updated before Event URL; headers are optional. For event creation, use Title, Start and End headers and complete date-time values with offsets, with End later than Start. Use separate worksheets for schedule input and logs.
Activate the selected workflow and let polling establish its baseline. Then create a fictional event, edit an older event for the change log, or append one complete schedule row. Compare the result with its source. Keep active schedule rows in order and avoid deleting them; reruns can add another row or event.
Each template performs a separate one-way task. Calendar logs append rows rather than finding and replacing an earlier event row. The schedule template creates events without writing their IDs back. Later schedule-row edits do not update those events, and neither logging template removes rows after cancellations. Use separate schedule and log worksheets so generated log rows do not become event-creation input.
The new-event log requires these exact headers in A:F: Event ID, Event title, Start, End, Status and Event URL. The change log uses A:G in that order with Updated before Event URL; it can append to an empty worksheet without headers. For Sheets-to-Calendar, put Title, Start and End in row 1 and append complete schedule rows. The workflows do not create those required headers for you.
Calendar-to-Sheets logs preserve supplied timestamps and offsets as plain text. All-day events use dates, and the end date is exclusive. For event creation from rows, Start and End must be RFC 3339 date-time values with explicit offsets, such as 2026-11-20T10:00:00+02:00. End must be later than Start. The prepared mapping does not use plain all-day dates, add attendees or check availability; visibility and default reminders follow the destination calendar.
The first poll establishes a baseline without importing history. The change-log trigger watches updates to existing events, excluding cancellations and events created within a roughly two-minute overlap window. Let a new event settle before editing it for a test. Several edits between polls can appear as one latest snapshot; the log does not compare old and new field values.
No. There is no event-ID lookup or upsert in these recipes. A manual rerun can append another log row or create another calendar event. Keep source headers stable, avoid deleting or reordering active schedule rows, and use Event URL in logs to review current calendar details.