Workflow automation

Hi.

I have been racking brains how to automate the creation of a row of data onto a fairly basic 'workflow/job tracking' spreadsheet, everytime I create a new event on Google Calender (We work on Google workspace).
It would also be good if it worked in reverse, so I could automate the creation of a calender event and prefill the various fields from a line of data in the same spreadsheet.

Currently I do a weekly MANUAL take off, from my employees various Google Calenders, onto a very basic MS word document table. This forms a sort of checklist for the 'after sales' stages of admin for each job and is basically just a ticklist and a bit of basic info about the the job to track that the various stages of aftersales have been completed.

It is SO arduous doing this every week!! and things get missed through human error.

I'm hoping 'Zapier' can help with this? But not being terribly IT litertate I wouldn't even know where to begin in setting it up. I am fairly good with Google Calender but I have only only experimented with creating the spreadsheet side of things on Google sheets. So I have a version of this spreadsheet, but it is only indicative at this stage with no formatting or conditions set. (Because I don't know how to!)

Can anyone help me with Google sheets and the integration of sheets & calender that Zapier can offer please?

Thanks.

Alex