Sync from Google Calendar to Google Sheets

Hi there,

I wanna creata a connection between google calendar and google sheets but whatever I do, I couldn’t do it so I need your help.

For every event created in calendar, date and summary will be added in a row in google sheets.

For every event updated in calendar, date and summary will be updated in its row.

For every event deleted in calendar, that row will be deleted as well. And also if end time is equal to today, that event will be deleted.