{"id":1079,"date":"2016-01-05T18:22:44","date_gmt":"2016-01-05T16:22:44","guid":{"rendered":"https:\/\/tulipemedia.com\/?p=1079"},"modified":"2016-01-05T18:22:44","modified_gmt":"2016-01-05T16:22:44","slug":"make-a-shared-schedule-using-google-sheets","status":"publish","type":"post","link":"https:\/\/tulipemedia.com\/en\/faire-un-planning-partage-grace-a-google-sheets\/","title":{"rendered":"Productivity: make a shared weekly or monthly schedule using Google Sheets"},"content":{"rendered":"<p>Here is a tutorial that will allow you to create, manage and update a shared schedule using Google Sheets. The idea is to create an extremely simple schedule for the week on Google Sheets, then submit this schedule to your team and be notified of their confirmation at the scheduled times.<\/p>\n<p>A simple but very effective tool for companies that work in the form of \u201cshifts\u201d and with a lot of stakeholders (typical example: the hotel industry for example). Rather than sending everyone&#039;s schedule by SMS and wasting a lot of time doing it, here is a global solution, simple and easy to implement.<\/p>\n<p>The first step is to create the schedule for the week. The simplest schedule consists of listing the days in the left column, then the names of those who make up the staff in the first row at the top. From there, the manager makes crosses or time slots for each team member.<\/p>\n<p>However, two problems may arise:<\/p>\n<ul>\n<li>How to send each staff member their own schedule without sharing the entire team schedule?<\/li>\n<li>How to notify everyone at once by email as soon as the schedule is ready, without having to send a message to everyone?<\/li>\n<\/ul>\n<p>Thanks to Google Sheets, you will be able to calmly respond to these two issues, on the one hand by segmenting the sharing of your schedule with your different collaborators, and on the other hand by notifying everyone via Google Sheets when the schedule is ready, and by being notified yourself when each of your employees confirms that the schedule suits them.<\/p>\n<p>To do this, I have split this guide into two articles:<\/p>\n<ul>\n<li>\n<h3><a href=\"https:\/\/tulipemedia.com\/en\/google-sheets-importrange-function-sharing-file-planning\/\" target=\"_blank\" rel=\"noopener\">Part 1: use the IMPORTRANGE function to share your schedule in a fragmented way<\/a><\/h3>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/tulipemedia.com\/en\/send-emails-from-google-sheets-planning-code-script\/\" target=\"_blank\" rel=\"noopener\">Part 2: have your schedule confirmed by sending bulk emails from Google Sheets<\/a><\/h3>\n<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Voici un tutoriel qui va vous permettre de cr\u00e9er, g\u00e9rer et mettre \u00e0 jour un planning partag\u00e9 gr\u00e2ce \u00e0 Google Sheets. L&rsquo;id\u00e9e consiste \u00e0 cr\u00e9er un planning de la semaine extr\u00eamement simple sur Google Sheets, puis \u00e0 soumettre ce planning \u00e0 votre \u00e9quipe et \u00eatre notifi\u00e9 de leur confirmation aux heures pr\u00e9vues. Un outil simple [&hellip;]<\/p>\n","protected":false},"author":17,"featured_media":1080,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,28],"tags":[],"class_list":["post-1079","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-rh","category-vie-pro"],"_links":{"self":[{"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/posts\/1079","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/comments?post=1079"}],"version-history":[{"count":0,"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/posts\/1079\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/media\/1080"}],"wp:attachment":[{"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/media?parent=1079"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/categories?post=1079"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/tags?post=1079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}