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.

A simple but very effective tool for companies that work in the form of “shifts” and with a lot of stakeholders (typical example: the hotel industry for example). Rather than sending everyone's schedule by SMS and wasting a lot of time doing it, here is a global solution, simple and easy to implement.

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.

However, two problems may arise:

• How to send each staff member their own schedule without sharing the entire team schedule?
• How to notify everyone at once by email as soon as the schedule is ready, without having to send a message to everyone?

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.

To do this, I have split this guide into two articles:

• Part 1: use the IMPORTRANGE function to share your schedule in a fragmented way

• Part 2: have your schedule confirmed by sending bulk emails from Google Sheets