App Icon
Connor Burke
•  35,067
Overview
Use a spreadsheet to manage your institutional schedule, and let Shift Scheduler automatically manage each user's Google Calendar!
Automatically create and maintain your organization's schedule in a single spreadsheet that automatically creates Google Calendar events for your users, as well as creates and maintains separate a separate spreadsheet view reorganizing your schedule by shift, to immediately see who's covering what responsibilities.

Designed by a family medicine Chief Resident with medical residencies in mind (but flexible enough to be used by anyone with complex scheduling needs), this shift scheduling application simplifies the process of creating and maintaining complex schedules for even large numbers of people. At the first run, an example spreadsheet is created to demonstrate how the program works. A tutorial guides you through customizing that spreadsheet to your specific users, and the program will open a sidebar in which you'll have the option of defining several attributes of commonly worked shifts (each can have a start and end time, custom location, as well as several other advanced properties). With that, setup is complete and you're ready to schedule!

Then, when you then assign shifts to your users (either by assigning a shift to their name in the "User View" tab or by assigning their name to a shift in the "Shift View" tab), the program will use the shift information you've already supplied it to create google calendar events for your users (and synchronize with the other spreadsheet view to keep everything up to date)! 

If you assign a user a shift name which doesn't match one of the specially defined shifts you've set up in the sidebar, the program will create an All Day event in the google calendar for your user instead. You can even type in a custom event with it's own times -- for example "1-4:30 Meeting" -- and it will create a calendar event based on those times. You can create multiple events in the same day by separating them with a forward slash "/" or a comma ",". 

There are lots of advanced options and features too, but if you're not interested by now I don't think they'll convince you. Check it out for yourself! You can always access a more detailed summary of information within the program by opening the help or tutorial views from the menu.

My residency program is now using this as its primary scheduling resource - I hope you find some use for it as well!
Reviews
Language:
Sort by:
Profile Picture
Alita Tripp
January 16, 2021
Does not work, at all. just tells me that it won't connect
Is this review helpful?
Yes
No
Profile Picture
Whitney Schick
January 4, 2021
Need it to not create calendars everytime we log in to edit. It is very very cumbersome to go through everytime and delete or hide those calendars. This would be a GREAT app if it could do that.
Is this review helpful?
Yes
No
Profile Picture
Joseph De Luca
December 21, 2020
Remove risky access to your data This app or service has extensive access to your personal information and its developer's information hasn't been verified by Google. You should remove its access unless you're sure you trust it
Is this review helpful?
Yes
No
Profile Picture
Michael Smith
November 29, 2020
I like it even though it doesn't work well enough to fit my needs. It has a lot of potential to being super awesome. It would be really useful to have the shift first and then who is covering it. And along the same lines, it would be useful to have a shift view where the coloring and user match up in Google Calendar. In other words, for the master calendar, to be able to look at it and see that all shifts for the day are being covered. It would also be useful to have a shift calendar where the name of the person that is covering the shift for the day appears in that calendar. This would be useful on the Google Calendar side of things because then you can change the color of each shift to quickly see who is covering what. It would also be easy to spot holes. More colors for shifts/users is needed especially since it seems you cannot use the same color twice between the two views. I am also having trouble with figuring out how to use this for PTO/time off. I am having trouble using a username to act as multiple calendars. I feel like this is the missing link to me being able to use this addon. I hope my rambling helps as far as feedback for the creator. I will report back in better detail as I play around with it a little more in hoping to make it work for me. Perhaps I can figure out some workarounds or perhaps I am simply missing something. A couple things I may try for workarounds is seeing if I can create another spreadsheet and use this to create a second "master" list. Also, thinking of trying to switch employee and shift creation. Anyways, again, I appreciate this tool despite the shortcomings for what I need for my use.
Is this review helpful?
Yes
No
Profile Picture
NESO Library
November 5, 2020
Is there an option NOT to create a google calendar for the employees every time you open the shift scheduler?
Is this review helpful?
Yes
No
Profile Pciture
Whitney Schick
January 4, 2021
Need this to be an option!
Profile Pciture
Andrew Thome
November 17, 2020
Would love to see this option. It caused an error on my form and now I've exceeded the calendar creation limit - it won't work now.
Profile Picture
Seren Peters
October 30, 2020
This add-on is amazing. Tutorial is very helpful. Wish there weren't so many error messages but they don't actually stop you from doing what you need to.
Is this review helpful?
Yes
No
Profile Picture
Belinda Nyamgero
September 3, 2020
Is there a way someone can bulk upload users especially if you are working with more than 100 users. That is the only downside for me when creating the schedule
Is this review helpful?
Yes
No
Profile Picture
Suzanne Dunsterville
August 27, 2020
Is there a way I can have in User View the Users going down the side and the dates across the top?
Is this review helpful?
Yes
No
Profile Picture
John Pinares
August 27, 2020
Something useful would be a better way to set up recurring events (i.e., days off, meetings, etc.) Or if there was a way to sync the created calendar with the spreadsheet since I can easily create a recurring event on calendar.
Is this review helpful?
Yes
No
Profile Picture
Bhairagini Maa Srirekha
August 25, 2020
Hello, how can i create multiple tabs for different time frames? I wld like a separate tab for each month. Is it possible?
Is this review helpful?
Yes
No
1-10 of 43
Additional information
Connor Burke
Terms of Service
Search
Clear search
Close search
Google apps
Main menu