{"id":22500,"date":"2025-07-23T23:06:53","date_gmt":"2025-07-23T14:06:53","guid":{"rendered":"https:\/\/84office.jp\/?p=22500"},"modified":"2025-07-23T23:06:54","modified_gmt":"2025-07-23T14:06:54","slug":"google-calendar-to-sheet-template","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/google-calendar-to-sheet-template\/","title":{"rendered":"Ready-to-Use Google Calendar to Sheets Export Template| Google Sheets &amp; Apps Script"},"content":{"rendered":"<div class=\"codoc-evacuations\" style=\"display:none;\" data-shortcode=\"%5B%3Ca+href%3D%22https%3A%2F%2F84office.jp%2Fen%2Fcontact%2F%22+target%3D%22_blank%22+rel%3D%22noreferrer+noopener%22%3EContact+Us+Here%3C%2Fa%3E%5D\">[<a href=\"https:\/\/84office.jp\/en\/contact\/\" target=\"_blank\" rel=\"noreferrer noopener\">Contact Us Here<\/a>]<\/div>\n<p class=\"u-mb-ctrl u-mb-40 has-swl-pale-02-background-color has-background wp-block-paragraph\">The template introduced in this article is a paid product.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the previous article, \u201c<a href=\"https:\/\/84office.jp\/en\/calendar-schedule-get\/\" target=\"_blank\" rel=\"noreferrer noopener\">Export Google Calendar Events to a Spreadsheet\uff5cEasily Get Schedules for Multiple Users with Google Apps Script,<\/a>\u201d I introduced how to use Apps Script  to export events from multiple users\u2019 calendars.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This time, we\u2019re providing a ready-to-use template that requires no script setup.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Even if you\u2019re new to Apps Script, you can simply enter the calendar IDs and the desired period to easily export a list of events.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">With this template, you can manage multiple users\u2019 schedules in one place, making it much easier to coordinate team schedules and track progress.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you want to use the template right away, you can jump to the download section <a href=\"#download\">here<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Template Features<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large is-style-shadow u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"233\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-261-1024x233.png\" alt=\"\" class=\"wp-image-22532\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-261-1024x233.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-261-300x68.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-261-768x174.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-261-1536x349.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-261-2048x465.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list has-border -border02 u-mb-ctrl u-mb-40 has-swl-pale-03-background-color has-background\">\n<li><strong>Enter calendar IDs to retrieve multiple members\u2019 schedules all at once<\/strong><\/li>\n\n\n\n<li><strong>Fetch events within a specified date range<\/strong><\/li>\n\n\n\n<li><strong>Automatically list event \u201cTitle \/ Description \/ Date &amp; Time \/ Location \/ Guests\u201d<\/strong><\/li>\n\n\n\n<li><strong>Includes an execute button for easy Apps Script operation<\/strong><\/li>\n<\/ul>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60 wp-block-paragraph\">The script was published in a previous article, but with this template, it is provided in a ready-to-use format\u2014including an execute button for immediate use.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to Use the Template<\/h2>\n\n\n\n<div class=\"swell-block-step\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Copy the Spreadsheet<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image is-style-shadow u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"591\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-263-1024x591.png\" alt=\"\" class=\"wp-image-22534\" style=\"width:586px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-263-1024x591.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-263-300x173.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-263-768x443.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-263.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Copy the file from the template link <a href=\"#download\">below<\/a>.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Enter Calendar IDs<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image is-style-shadow u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"189\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-265-1024x189.png\" alt=\"\" class=\"wp-image-22536\" style=\"width:565px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-265-1024x189.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-265-300x55.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-265-768x142.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-265.png 1052w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Enter the Google Calendar IDs in cell B1 and to the right.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Enter Start and End Dates in B2 and B3<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image is-style-shadow u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"189\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-267-1024x189.png\" alt=\"\" class=\"wp-image-22538\" style=\"width:565px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-267-1024x189.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-267-300x55.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-267-768x142.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-267.png 1050w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Input the start date in B2 and the end date in B3.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Click the Execute Button<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40 is-style-shadow\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"656\" height=\"232\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-269.png\" alt=\"\" class=\"wp-image-22540\" style=\"width:353px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-269.png 656w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-269-300x106.png 300w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">Click the \u201cGet Schedules\u201d button to run the Apps Script.<br>The script will retrieve Google Calendar events for the entered calendar IDs within the specified period.<\/p>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_memo u-mb-ctrl u-mb-60\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\">If you&#8217;re running the script for the first time, you need to authorize it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Therefore, press &#8220;<strong>Review Permissions.<\/strong>&#8220;<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-50\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"882\" height=\"345\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79.png\" alt=\"\" class=\"wp-image-15938\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79.png 882w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79-300x117.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79-768x300.png 768w\" sizes=\"(max-width: 882px) 100vw, 882px\" \/><\/figure>\n<\/div>\n\n\n<div class=\"swell-block-accordion\">\n<details class=\"swell-block-accordion__item\" data-swl-acc=\"wrapper\"><summary class=\"swell-block-accordion__title\" data-swl-acc=\"header\"><span class=\"swell-block-accordion__label\">Detailed Authorization Steps<\/span><span class=\"swell-block-accordion__icon c-switchIconBtn\" data-swl-acc=\"icon\" aria-hidden=\"true\" data-opened=\"false\"><i class=\"__icon--closed icon-caret-down\"><\/i><i class=\"__icon--opened icon-caret-up\"><\/i><\/span><\/summary><div class=\"swell-block-accordion__body\" data-swl-acc=\"body\">\n<p class=\"wp-block-paragraph\"><strong>Press &#8220;Advanced.&#8221;<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full u-mb-ctrl u-mb-50\"><img decoding=\"async\" width=\"1272\" height=\"688\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d.jpg\" alt=\"\" class=\"wp-image-15939\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d.jpg 1272w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d-300x162.jpg 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d-1024x554.jpg 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d-768x415.jpg 768w\" sizes=\"(max-width: 1272px) 100vw, 1272px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Press &#8220;Go to Untitled project (Unsafe).&#8221;<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-50\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"1305\" height=\"893\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9.jpg\" alt=\"\" class=\"wp-image-15940\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9.jpg 1305w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9-300x205.jpg 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9-1024x701.jpg 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9-768x526.jpg 768w\" sizes=\"(max-width: 1305px) 100vw, 1305px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>After that, press &#8220;Allow.&#8221;<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"955\" height=\"543\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049.jpg\" alt=\"\" class=\"wp-image-15941\" style=\"width:566px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049.jpg 955w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049-300x171.jpg 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049-768x437.jpg 768w\" sizes=\"(max-width: 955px) 100vw, 955px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<\/div><\/details>\n<\/div>\n<\/div><\/div>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Display Schedules in a List<\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"233\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-261-1024x233.png\" alt=\"\" class=\"wp-image-22532\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-261-1024x233.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-261-300x68.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-261-768x174.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-261-1536x349.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-261-2048x465.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"u-mb-ctrl u-mb-20 wp-block-paragraph\">The list of schedules will appear from row 6 onward.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-0 wp-block-paragraph\">Retrieved Fields<\/p>\n\n\n\n<ul class=\"wp-block-list has-swl-pale-02-background-color has-background\">\n<li>Column A: Calendar ID<\/li>\n\n\n\n<li>Column B: Title<\/li>\n\n\n\n<li>Column C: Description<\/li>\n\n\n\n<li>Column D: Start Date<\/li>\n\n\n\n<li>Column E: Start Time<\/li>\n\n\n\n<li>Column F: End Date<\/li>\n\n\n\n<li>Column G: End Time<\/li>\n\n\n\n<li>Column H: Location<\/li>\n\n\n\n<li>Column I: Guests<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Notes<\/h2>\n\n\n\n<ul class=\"wp-block-list u-mb-ctrl u-mb-60 has-swl-pale-01-background-color has-background\">\n<li class=\"u-mb-ctrl u-mb-10\">The calendar IDs must be from shared Google Calendars.<\/li>\n\n\n\n<li>Please enter the start and end dates in the dd\/MM\/YYYY format.<\/li>\n\n\n\n<li>The output sheet name is fixed as \u201cSchedule List.\u201d<\/li>\n\n\n\n<li>(If needed, you can change the sheet name and update the script accordingly.)<\/li>\n\n\n\n<li>Event information will be written automatically starting from row 6. (Row 5 contains the headers.)<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"download\">Download the Template Here<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You can copy the completed template from the link below (Google Sheets).<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">Simply enter the calendar IDs and date range, then click the button to execute.<\/p>\n\n\n\n<div class=\"wp-block-codoc-codoc-block\"><div class=\"codoc-entries\" data-without-body=\"1\" id=\"codoc-entry-Q8bhw6vX0g\"  data-entry-button-text=\"\u8cfc\u5165\u3059\u308b\" data-support-button-text=\"\u30c1\u30c3\u30d7\u3067\u5fdc\u63f4\u3059\u308b\" data-support-message=\"\u4eca\u5f8c\u3082\u696d\u52d9\u52b9\u7387\u5316\u306b\u5f79\u7acb\u3064\u60c5\u5831\u3092\u63d0\u4f9b\u3057\u3066\u307e\u3044\u308a\u307e\u3059\u3002\u3054\u652f\u63f4\u3044\u305f\u3060\u3051\u308b\u3068\u5b09\u3057\u3044\u3067\u3059\u3002\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>[Contact Us Here] The template introduced in this article is a paid product. In the previous article, \u201cExport  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":22552,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","_locale":"en_US","_original_post":"https:\/\/84office.jp\/?p=19473","footnotes":""},"categories":[12],"tags":[],"class_list":["post-22500","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-12","en-US"],"_links":{"self":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/22500","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/comments?post=22500"}],"version-history":[{"count":4,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/22500\/revisions"}],"predecessor-version":[{"id":22554,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/22500\/revisions\/22554"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media\/22552"}],"wp:attachment":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media?parent=22500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/categories?post=22500"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/tags?post=22500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}