This applet enters each calendar event in a google sheet as events end (rather than begin), to avoid logging events that are deleted/modified before they conclude.
If
Any event ends
This Trigger fires within 15 minutes of the ending time of an event on your Google Calendar. Note: The time in the ingredient will be based on the timezone set in Google Calendar.
Then
Add row to spreadsheet
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Discover more time saving integrations for Google Sheets and Google Calendar