{"id":22570,"date":"2025-07-25T23:29:17","date_gmt":"2025-07-25T14:29:17","guid":{"rendered":"https:\/\/84office.jp\/?p=22570"},"modified":"2025-07-26T01:33:13","modified_gmt":"2025-07-25T16:33:13","slug":"google-calendar-free-time-template","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/google-calendar-free-time-template\/","title":{"rendered":"Google Calendar Free Time Finder Template\uff5cGoogle Sheets \u00d7 Apps Script"},"content":{"rendered":"<div class=\"codoc-evacuations\" style=\"display:none;\" data-shortcode=\"\"><\/div>\n<p class=\"wp-block-paragraph\">In a previous post titled <strong><a href=\"https:\/\/84office.jp\/en\/google-calendar-free-time-extraction\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Find Common Free Time in Google Calendar: Manage Shared Schedules with Google Apps Script<\/a><\/strong>, we explained how to automatically extract overlapping availability from multiple calendars using Google Apps Script.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This time, we\u2019re offering a ready-to-use template that makes things even easier.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Simply enter the calendar IDs, date range, preferred time of day, and time interval\u2014and the sheet will automatically list all available time slots shared across calendars.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">It\u2019s a handy tool for scheduling meetings and streamlining team coordination.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60 wp-block-paragraph\">If you\u2019d like to jump straight to the download section, <a href=\"#download\">click here<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Key Features of the Template<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large is-resized u-mb-ctrl u-mb-40 is-style-shadow\"><img decoding=\"async\" width=\"1024\" height=\"575\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-287-1024x575.png\" alt=\"\" class=\"wp-image-22572\" style=\"width:674px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-287-1024x575.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-287-300x168.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-287-768x431.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-287.png 1069w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list has-border -border02 u-mb-ctrl u-mb-60 has-swl-pale-03-background-color has-background\">\n<li><strong>Automatically detects common free time across multiple Google Calendars<\/strong><\/li>\n\n\n\n<li><strong>Customizable time range for each day (e.g., limit search to 10:00 AM\u20136:00 PM)<\/strong><\/li>\n\n\n\n<li><strong>Flexible time intervals\u2014choose from 15, 30, or 60 minutes as needed<\/strong><\/li>\n\n\n\n<li><strong>Easy to run with a built-in execution button powered by Google Apps Script<\/strong><\/li>\n\n\n\n<li><strong>Simple and clean output: results are displayed in just two columns \u2014 \u201cDate\u201d and \u201cAvailable Time Slot\u201d<\/strong><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">How to Use the Template<\/h2>\n\n\n\n<div class=\"swell-block-step u-mb-ctrl u-mb-60\" 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 Google Sheet<\/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-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"564\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-291-1024x564.png\" alt=\"\" class=\"wp-image-22576\" style=\"width:590px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-291-1024x564.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-291-300x165.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-291-768x423.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-291.png 1264w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Start by copying the template from the <a href=\"#download\" target=\"_blank\" rel=\"noreferrer noopener\">link 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 u-mb-ctrl u-mb-40 is-style-shadow\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"986\" height=\"358\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-289.png\" alt=\"\" class=\"wp-image-22574\" style=\"width:552px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-289.png 986w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-289-300x109.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-289-768x279.png 768w\" sizes=\"(max-width: 986px) 100vw, 986px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-30 wp-block-paragraph\">In cell <strong>B1<\/strong> and the columns to the right, enter the Google Calendar IDs.<br>You can input multiple calendar IDs side by side to compare availability across team members.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\"><strong>Note<\/strong>: To access someone else\u2019s calendar, make sure they\u2019ve shared it with you and granted the appropriate viewing permissions in advance.<\/p>\n\n\n\n<div class=\"swell-block-accordion u-mb-ctrl u-mb-60\">\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\">How to Set Calendar Sharing Permissions in Google Calendar<\/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=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">If you want to access someone else\u2019s Google Calendar via this template, they need to share their calendar with you. Here&#8217;s how to do it:<\/p>\n\n\n<div class=\"wp-block-image is-style-shadow u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"840\" height=\"616\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-243.png\" alt=\"\" class=\"wp-image-22510\" style=\"width:508px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-243.png 840w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-243-300x220.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-243-768x563.png 768w\" sizes=\"(max-width: 840px) 100vw, 840px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Open <strong><a href=\"https:\/\/calendar.google.com\/calendar\/u\/0\/r\">Google Calendar<\/a><\/strong> and click the <strong>gear icon<\/strong> (\u2699\ufe0f) in the top-right corner, then select <strong>Settings<\/strong>.<br><\/p>\n\n\n<div class=\"wp-block-image is-style-shadow u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"584\" height=\"578\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-245.png\" alt=\"\" class=\"wp-image-22512\" style=\"width:326px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-245.png 584w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-245-300x297.png 300w\" sizes=\"(max-width: 584px) 100vw, 584px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-50 wp-block-paragraph\">On the left menu, find <strong>Settings for My Calendars<\/strong>, and click on the calendar you want to share.<\/p>\n\n\n<div class=\"wp-block-image is-style-shadow u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"425\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-246-1024x425.png\" alt=\"\" class=\"wp-image-22513\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-246-1024x425.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-246-300x124.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-246-768x318.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-246.png 1360w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Scroll down to the section called <strong>Share with specific people or groups<\/strong>.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60 wp-block-paragraph\">Click <strong>Add people and groups<\/strong>, then enter the email address of the person you want to grant access to.<\/p>\n\n\n<div class=\"wp-block-image is-style-shadow u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"932\" height=\"522\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-247.png\" alt=\"\" class=\"wp-image-22514\" style=\"width:491px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-247.png 932w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-247-300x168.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-247-768x430.png 768w\" sizes=\"(max-width: 932px) 100vw, 932px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-60 wp-block-paragraph\">Make sure you grant at least \u201cSee all event details\u201d permission so the script can retrieve availability properly.<\/p>\n\n\n<div class=\"wp-block-image is-style-shadow u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"478\" height=\"420\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-249.png\" alt=\"\" class=\"wp-image-22516\" style=\"width:309px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-249.png 478w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-249-300x264.png 300w\" sizes=\"(max-width: 478px) 100vw, 478px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Once someone shares their calendar with you, it will appear under the <strong>\u201cOther calendars\u201d<\/strong> section in Google Calendar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If the shared calendar doesn\u2019t show up, try the following steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click the <strong>link in the email notification<\/strong> you received when the calendar was shared with you.<\/li>\n\n\n\n<li>Or manually add it by following these steps:\n<ol class=\"wp-block-list\">\n<li>Go to <strong>\u201cOther calendars\u201d<\/strong> on the left sidebar<\/li>\n\n\n\n<li>Click the <strong>\u201c+\u201d (plus) icon<\/strong><\/li>\n\n\n\n<li>Select <strong>\u201cSubscribe to calendar\u201d<\/strong><\/li>\n\n\n\n<li>Enter the <strong>Calendar ID (usually their email address)<\/strong> and click <strong>Add<\/strong><\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<\/div><\/details>\n<\/div>\n\n\n\n<div class=\"swell-block-accordion u-mb-ctrl u-mb-60\">\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\">How to Find Your Google Calendar ID<\/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\"><div class=\"wp-block-image is-style-shadow u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"840\" height=\"616\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-243.png\" alt=\"\" class=\"wp-image-22510\" style=\"width:508px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-243.png 840w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-243-300x220.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-243-768x563.png 768w\" sizes=\"(max-width: 840px) 100vw, 840px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-60 wp-block-paragraph\">Open <strong><a href=\"https:\/\/calendar.google.com\/calendar\/u\/0\/r\">Google Calendar<\/a><\/strong> and click the <strong>gear icon<\/strong> (\u2699\ufe0f) in the top-right corner, then select <strong>Settings<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image is-style-shadow u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"584\" height=\"578\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-245.png\" alt=\"\" class=\"wp-image-22512\" style=\"width:326px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-245.png 584w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-245-300x297.png 300w\" sizes=\"(max-width: 584px) 100vw, 584px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-50 wp-block-paragraph\">On the left menu, find <strong>Settings for My Calendars<\/strong>, and click on the calendar you want to share.<\/p>\n\n\n<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=\"569\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-252-1024x569.png\" alt=\"\" class=\"wp-image-22519\" style=\"width:642px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-252-1024x569.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-252-300x167.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-252-768x427.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-252.png 1274w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">On the calendar settings page, scroll down to find the Calendar ID section.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The Calendar ID is usually in the format <code>xxx@gmail.com<\/code> or <code>xxxx@group.calendar.google.com<\/code>.<\/p>\n<\/div><\/details>\n<\/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\">Enter the Date Range for Availability Search<\/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-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"380\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-293-1024x380.png\" alt=\"\" class=\"wp-image-22578\" style=\"width:514px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-293-1024x380.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-293-300x111.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-293-768x285.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-293.png 1066w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">In cells <strong>B2<\/strong> and <strong>B3<\/strong>, enter the <strong>start date<\/strong> and <strong>end date<\/strong> for the period you want to check for availability.<\/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\">Specify Daily Time Range (Optional)<\/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=\"380\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-297-1024x380.png\" alt=\"\" class=\"wp-image-22582\" style=\"width:523px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-297-1024x380.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-297-300x111.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-297-768x285.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-297.png 1066w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">In cells <strong>B4<\/strong> and <strong>B5<\/strong>, you can define the <strong>time range within a day<\/strong> you&#8217;d like to check\u2014such as limiting the search to business hours (e.g., <code>10:00<\/code> to <code>18:00<\/code>).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This step is optional. If left blank, the script will search for free time across the entire day.<\/p>\n\n\n\n<p class=\"is-style-big_icon_caution wp-block-paragraph\">Please enter the time as a <strong>text string<\/strong>, such as <code>\"10:00\"<\/code> and <code>\"18:00\"<\/code>.<br>Avoid entering just numbers or using the spreadsheet&#8217;s <strong>Time format<\/strong>, as they may not be read correctly by the script.<br>(The template is pre-configured with the correct format.)<\/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\">Set the Time Interval for Availability Slots<\/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=\"380\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-299-1024x380.png\" alt=\"\" class=\"wp-image-22584\" style=\"width:548px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-299-1024x380.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-299-300x111.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-299-768x285.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-299.png 1066w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">In cell <strong>B6<\/strong>, enter the <strong>time interval in minutes<\/strong> for splitting the availability blocks.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example:<br><code>20<\/code> \u2192 will display free time slots in <strong>20-minute intervals<\/strong><\/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 \u201cCheck Availability\u201d 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-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"380\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-301-1024x380.png\" alt=\"\" class=\"wp-image-22586\" style=\"width:549px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-301-1024x380.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-301-300x111.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-301-768x285.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-301.png 1066w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Once everything is set, click the <strong>\u201cCheck Availability\u201d<\/strong> button in the sheet.<br>This will trigger the Google Apps Script (GAS), which scans the specified calendars and retrieves all free time slots within the selected date range.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\"><\/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\">View the List of Available Time Slots<\/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-full is-resized\"><img decoding=\"async\" width=\"601\" height=\"327\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-295.png\" alt=\"\" class=\"wp-image-22580\" style=\"width:465px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-295.png 601w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-295-300x163.png 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-30 wp-block-paragraph\">The sheet will display a list of <strong>common free time slots<\/strong> across all selected calendars within the specified date range.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The output shows each date along with the corresponding available time slots, making it easy to schedule meetings or appointments.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Notes &amp; Tips<\/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-20\"><strong>Be careful with all-day events<\/strong><br>If a calendar includes events marked as <strong>\u201cAll-day\u201d<\/strong>, they may affect the availability calculation.<br>Consider switching such events to time-specific ones, or limit the calendars you include in your search.<\/li>\n\n\n\n<li><strong><strong>Time range inputs (cells B4 &amp; B5) must be in text format<\/strong><\/strong><br>When entering the daily time range in B4 and B5, use text strings like &#8220;10:00&#8221;.<br>If you enter time using Google Sheets\u2019 time format, the script may not interpret it correctly and could return inaccurate results.<br><\/li>\n\n\n\n<li class=\"u-mb-ctrl u-mb-20\"><strong>Time interval (cell B6) must be an integer (in minutes)<\/strong><br>Example: 15, 30, etc.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-40\" id=\"download\">Download the Template Here<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This Google Sheets template comes <strong>preloaded with all the necessary scripts<\/strong> \u2014 ready to use right away.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">Why not simplify your workflow and save time on scheduling tasks?<\/p>\n\n\n\n<div class=\"wp-block-codoc-codoc-block\"><div class=\"codoc-entries\" data-without-body=\"1\" id=\"codoc-entry-jCnx2WsOMg\"  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>In a previous post titled How to Find Common Free Time in Google Calendar: Manage Shared Schedules with Google [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":22589,"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=19490","footnotes":""},"categories":[12],"tags":[],"class_list":["post-22570","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\/22570","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=22570"}],"version-history":[{"count":3,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/22570\/revisions"}],"predecessor-version":[{"id":22591,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/22570\/revisions\/22591"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media\/22589"}],"wp:attachment":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media?parent=22570"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/categories?post=22570"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/tags?post=22570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}