App Icon
Use a spreadsheet to manage your institutional schedule, and let Shift Scheduler automatically manage each user's Google Calendar!
Works with:
59,083
Overview
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!
Additional information
PricingNot available
SupportNot available
Privacy policy
Terms of service
Shift Scheduler will ask for the permissions shown below. Learn more
Shift Scheduler will need access to your Google account
This will allow Shift Scheduler to :
View and manage spreadsheets that this application has been installed in
See, edit, share, and permanently delete all the calendars you can access using Google Calendar
Display and run third-party web content in prompts and sidebars inside Google applications
Allow this application to run when you are not present
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
A User of Shift Scheduler
June 24, 2018
This is incredible. Thank you so much for sharing this. We are using it at our school to replace a home-grown spreadsheet that had become difficult to update as changes were needed. This takes care of all of our needs. I would love to see the shifts be offered as a drop-down choice in the "User" view so that typo's could be at a minimum. Thank you again!!
Is this review helpful?
Yes
No
Profile Picture
A User of Shift Scheduler
June 4, 2019
Been using this for a month now and have been encountering a few bugs: According to my version history, every day at 7:19 AM and 1:19 PM an edit is made to the spreadsheet. I am not editing this spreadsheet at those times. If I go for a week without opening the spreadsheet, these "edits" still show up in my version history. The specific edit that keeps recurring is that my staff member's name in the first column gets deleted and all the subsequent staffer's names get shifted one column to the left, with the final column (furthest to the right) getting duplicated. This essentially swaps everyone's calendars and has been messing up when people show up to work and what they're assigned to do! Yipes! Every time I edit the spreadsheet to fix the problem it either reverts back automatically twice daily, or when I hit "resynchronize everything". What gives? I'd love to continue using this program but this bug is making it impossible. Help?
Is this review helpful?
Yes
No
Profile Picture
A User of Shift Scheduler
May 13, 2019
This tool is very easy to use and powerful. I noticed that if you have too many people on the team, updates can take long, specially if there are too many days in the spreadsheet. I would like to use this to manage many fewer events (days). Is there a way to customize the dates that show up? Instead of showing every single day from the start period to the end period, can we have the dates to be customized? E.g. 06/22, then 07/04, 07/21, then 08/11, 08/13, 08/22. Etc. No regular pattern at all.
Is this review helpful?
Yes
No
Profile Picture
Ada Minh
September 25, 2018
This is potentially a great add-on though I'm having a few issues with it. I don't seem to be able to import shifts from another sheet and the date formatting is acting weird since last time I created a schedule (about six weeks ago). No matter what I do, I can't select October 1st as a start date. It interprets it as January 10th regardless of whether I enter manually, use the date picker, or even try and out-smart it by entering Jan 10th (in the hope that it swaps the day and month around). The date format I use is D/M/YY (Australia) though I've tried other options as well and nothing seems to be working (worked fine last time I tried though). edit: some very buggy behaving when copy/pasting from other sheets into the user view too. A few seconds after pasting some of the shifts vanish. Their equivalents on the shift view are still there, but it would be confusing for employees looking at the user view. edit2: today when I went to look at the schedule I made last night most of it was missing and I'm pretty sure that no-one else accessed it in that time! Is that possible.
Is this review helpful?
Yes
No
Profile Picture
Jesse Ball
June 25, 2018
This add-on is a perfect solution. I work at an observatory and need to schedule night and day shifts of different types. We use google sheets to put our observatory schedule together, and with a bit of tweaking, this app allows us to integrate the spreadsheet schedule directly with our employees' calendars. Also, the developer is VERY helpful when contacted, and extremely responsive and eager to help out and solve any issues, or even just give advice. Thanks so much Connor -- this app is amazing!
Is this review helpful?
Yes
No
Profile Picture
A User of Shift Scheduler
March 14, 2019
It clashes when two users editing at the same time. And it appeared differently on each other's computer! How do we manage this? Only one user or only the creator to edit? Thank you! Love the features and the conveniences but still learning to use it!
Is this review helpful?
Yes
No
Profile Picture
A User of Shift Scheduler
February 8, 2019
This is gold, thank you so much for making this. If you want to make a schedule for volunteers etc it works beautiful! I also like the Q&A section here being attended by both developer and users. I am wondering if there is any chance to make it possible for each user to update their calendar themselves? This way we can see who is available on what dates.
Is this review helpful?
Yes
No
Profile Picture
A User of Shift Scheduler
December 19, 2018
it is great tool , but 1 customization i need i'm surgeon resident and i want to organize our patient waiting list , i would define the users as our consultant , i want small space for description that the users can modify on it like patient info and the procedure , it is more like free space to be shown in description area in calendar , and so on other people can see what is the update , i dont know if it is possible
Is this review helpful?
Yes
No
Profile Picture
A User of Shift Scheduler
April 28, 2019
I cant seem to be able to change the time zone without ruining the data range
Is this review helpful?
Yes
No
Profile Picture
A User of Shift Scheduler
February 8, 2019
Super helpful add-on! Works just like expected - just type in the shift names and the calendar events pop right up!
Is this review helpful?
Yes
No
1-10 of 44
Search
Clear search
Close search
Google apps
Main menu