Get a copy of the Events registration Form template here.<\/a>\u00a0The template consists of an Events registration form and an Events management spreadsheet that will automatically accept or deny the events requested by your team members.<\/p>\nAs a result, inside the event tracking spreadsheet, your team\u2019s birthdays and planned events will automatically appear in the 2020 tab.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/02\/Event-registration-form-template.jpeg” align=”center” _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 2: Connect your Google Calendar to the template<\/h3>\n
This template automatically updates your Google Calendar directly from the Form responses in the Google Sheets. In other words, our Google Apps Script takes inputs from the spreadsheet and automatically creates Calendar events. Moreover, we configured the script to execute once a day. In other words, any changes made to the spreadsheet will be automatically reflected on the calendar within a day. Therefore, it minimizes manual work and eliminates errors. It’s a one-time setup.<\/p>\n
As you can see, this is a great productivity hack. You stop wasting time scheduling and coordinating events amongst your team. Below are the step-by-step instructions to configure the script for your company.<\/p>\n
Create a new Google Calendar<\/h4>\n
Firstly, open your Google Calendar and create a new calendar (to share with your team).<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/newCalendar.webp” align=”center” _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Copy the Calendar ID<\/h4>\n
Secondly, copy the calendar ID by selecting Settings and Sharing, scrolling down to Integrate Calendar, and copying the\u00a0calendar ID<\/strong>.<\/span><\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/calendarId.webp” align=”center” _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ make_equal=”on” _builder_version=”4.22.2″ _module_preset=”default” background_color=”#F6F8F9″ custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” locked=”off” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” text_font_size=”26px” text_line_height=”1.1em” background_color=”RGBA(255,255,255,0)” text_font_size_tablet=”17px” text_font_size_phone=”17px” text_font_size_last_edited=”on|phone” header_4_font_tablet=”” header_4_font_phone=”” header_4_font_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”center” text_orientation_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Sign up for Sheetgo and start tracking worked hours<\/span> automatically<\/strong><\/p>\n[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_button button_url=”https:\/\/app.sheetgo.com\/templates\/employee-timesheet” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.4″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Add Calendar ID to spreadsheet<\/h4>\n
Finally, in your Events management spreadsheet, go to the Parameters<\/strong> tab and fill out the following:<\/p>\n<calendar_id>: Calendar ID that you just copied in the previous step.<\/calendar_id><\/p>\nStep 3: Configure your template timezone<\/h3>\n
The next step to make the system work is to set the time zone on your spreadsheet template to the current time zone. Click on File > Spreadsheet settings > General > Timezone. By doing so, the system records your spreadsheet in the specific timezone and affects all time-related functions.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/02\/Timezone-settings-events-template.jpeg” align=”center” _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 4: Use your template<\/h3>\n
To use your system, send the form to your team. Open your Events management spreadsheet and click on Form -> Send Form. Or update the Form yourself with company events and employee birthdays.<\/p>\n
After that, click on the menu Events register > Run<\/strong>. This automatically adjusts your Calendar in the future.<\/p>\nDone \u2014 your event tracking system in G Suite is up and running!<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
That’s it!<\/h2>\n
Now you have a clear overview of all company events and birthdays in your Google Calendar. Are you interested in automating more HR processes? Please review our Holiday tracking template<\/a>. It works similarly to this template. Your employees request days off, which get approved or denied, and are automatically added to your company’s Calendar.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row make_equal=”on” _builder_version=”4.22.2″ _module_preset=”default” background_color=”#F6F8F9″ custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” locked=”off” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” text_font_size=”26px” background_color=”RGBA(255,255,255,0)” text_orientation=”center” text_font_size_tablet=”17px” text_font_size_phone=”17px” text_font_size_last_edited=”on|phone” header_4_font_tablet=”” header_4_font_phone=”” header_4_font_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”center” text_orientation_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Start tracking worked hours<\/span> automatically<\/strong><\/p>\n[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/templates\/employee-timesheet” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.27.4″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px|0px|0px|0px|false|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
As an HR manager, managing all company events and employee birthdays can be real chaos. Receiving and approving event attendance requests via email and manually entering or deleting dates from a spreadsheet is incredibly time-consuming and can lead to overlap. Looking for an automated event registration system? We\u2019ve got a free Sheetgo template and a […]<\/p>\n","protected":false},"author":40,"featured_media":23544,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"2880","footnotes":""},"categories":[42],"tags":[44],"class_list":["post-23542","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-human-resources-templates","tag-human-resources"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/23542","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=23542"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/23542\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/23544"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=23542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=23542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=23542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}