When an event in Google Calendar finishes, the event title, description, start and end time is saved in a spreadsheet for you to further process
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