Log Gcal events as they end in a Gsheet.

Connect

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.