Sync your events from Google calendar to Google Sheets automatically using G Sheets Sync even when you are not around. Once you set it up, your spreadsheet will automatically update the data at your desired cadence.

Here’s how to do it:

1. Click the “Workflows” section from the menu.

2. Now you can see all the existing workflows here. To create a new workflow, select "+ Create new workflow".

3. Add a name to your workflow and press enter. Now, select “At a scheduled time” trigger.

4. Choose the repeat schedule, day, and time for when you want to receive the emails.

5. Select “Sync with Google Sheets” from the trigger.

6. Choose the "Events" page that you want to automate export.

7. Insert the period and duration of the data that you need.

8. You can choose if you want to create a new file on every sync or you want to overwrite the existing google sheet.

9. Done. Now go ahead and select “Create” here.