Ready-to-Use Google Calendar to Sheets Export Template| Google Sheets & Apps Script

The template introduced in this article is a paid product.

In the previous article, “Export Google Calendar Events to a Spreadsheet｜Easily Get Schedules for Multiple Users with Google Apps Script,” I introduced how to use Apps Script to export events from multiple users’ calendars.

This time, we’re providing a ready-to-use template that requires no script setup.

Even if you’re new to Apps Script, you can simply enter the calendar IDs and the desired period to easily export a list of events.

With this template, you can manage multiple users’ schedules in one place, making it much easier to coordinate team schedules and track progress.

If you want to use the template right away, you can jump to the download section here.

Template Features

• Enter calendar IDs to retrieve multiple members’ schedules all at once
• Fetch events within a specified date range
• Automatically list event “Title / Description / Date & Time / Location / Guests”
• Includes an execute button for easy Apps Script operation

The script was published in a previous article, but with this template, it is provided in a ready-to-use format—including an execute button for immediate use.

How to Use the Template

STEP

Copy the Spreadsheet

Copy the file from the template link below.

STEP

Enter Calendar IDs

Enter the Google Calendar IDs in cell B1 and to the right.

STEP

Enter Start and End Dates in B2 and B3

Input the start date in B2 and the end date in B3.

STEP

Click the Execute Button

Click the “Get Schedules” button to run the Apps Script.
The script will retrieve Google Calendar events for the entered calendar IDs within the specified period.

If you’re running the script for the first time, you need to authorize it.

Therefore, press “Review Permissions.“

Detailed Authorization Steps

Press “Advanced.”

Press “Go to Untitled project (Unsafe).”

After that, press “Allow.”

STEP

Display Schedules in a List

The list of schedules will appear from row 6 onward.

Retrieved Fields

• Column A: Calendar ID
• Column B: Title
• Column C: Description
• Column D: Start Date
• Column E: Start Time
• Column F: End Date
• Column G: End Time
• Column H: Location
• Column I: Guests

Notes

• The calendar IDs must be from shared Google Calendars.
• Please enter the start and end dates in the dd/MM/YYYY format.
• The output sheet name is fixed as “Schedule List.”
• (If needed, you can change the sheet name and update the script accordingly.)
• Event information will be written automatically starting from row 6. (Row 5 contains the headers.)

Download the Template Here

You can copy the completed template from the link below (Google Sheets).

Simply enter the calendar IDs and date range, then click the button to execute.