App Icon
Connor Burke
•  12,084
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
A User of Shift Scheduler
July 23, 2020
Terrible app. Not at all user friendly, and through multiple errors it ended up deleting roughly an hour of work. Total waste
Is this review helpful?
Yes
No
Profile Picture
A User of Shift Scheduler
July 22, 2020
Love the add-on, thank you! Is there a way that the event which is created in google calendar receives the same name as the user? We are not using the shift setup, only the direct schedule (10-18) and the event has no title. Thank you again!
Is this review helpful?
Yes
No
Profile Picture
A User of Shift Scheduler
July 17, 2020
This is an awesome template that has made it MUCH easier to schedule and coordinate our ambulance service’s wild schedules and staffing. Only problem is I get a lot of issue out of Shift View not updating properly to match User View...anyone got a fix? Resynchronize Everything doesn’t seem to force it to fix. Help!!
Is this review helpful?
Yes
No
Profile Picture
A User of Shift Scheduler
June 17, 2020
So far so good as well. Since I'm the only administrator / owner, if I share the sheet with others who do not have the plugin, can they still make changes to their shifts and will this auto-sync the master? I want to make sure app keeps running while I'm logged off or out of the office.
Is this review helpful?
Yes
No
Profile Pciture
A user of Shift Scheduler
June 18, 2020
Hi, can I ask if you had an answer to your question about users who are not admin/owner making changes? I am reluctant to roll this tool out if users can't make shift changes without ownership of the calendars.
Profile Picture
A User of Shift Scheduler
June 6, 2020
So far this looks helpful. There's one feature I have been looking for specifically and it doesn't look possible but maybe I'm missing something? I would like to have private notes on each job that the employee doesn't see. Is this possible at all?
Is this review helpful?
Yes
No
Profile Picture
A User of Shift Scheduler
May 10, 2020
Brilliant add-on and helping in lots of ways but I would like to see if it is possible make an adjustment somehow? I want all the Users to go into one calendar, not lots of different ones. Is that doable? Thanks!
Is this review helpful?
Yes
No
Profile Pciture
A user of Shift Scheduler
May 19, 2020
Hi - in fact, it is! The individual calendars will continue to be made, but under Setup in the sidebar check the "Copy All Shifts to Master Calendar" option. This will do just what you're hoping - create one calendar with the user and shift name of each shift on it!
Profile Picture
Danielle Deschene
May 3, 2020
I keep getting this error when creating calendars for all my staff at once. "API call to calendar.calendars.insert failed with error: Calendar usage limits exceeded." And then I can't resync. Anyone know how to avoid this? or what to do when you get it?
Is this review helpful?
Yes
No
Profile Pciture
A user of Shift Scheduler
May 19, 2020
Hi Danielle - sorry about that! Unfortunately google calendar only allows the creation / deletion of about 5,000 calendar events per day for it's free gmail accounts. It's higher for the G Suite accounts. I'll try to update the program so it throws a more useful error when that quota is reached, but in the mean time, you can just keep syncing the next day. The program will also automatically try to resync every few hours, which should allow to catch up then too.
Profile Picture
A User of Shift Scheduler
April 24, 2020
When I share the sheet with another user in the Gsuite, they are unable open the main side bar. Is there a way for both users to manage the same sheet?
Is this review helpful?
Yes
No
Profile Pciture
A user of Shift Scheduler
May 19, 2020
Thanks for the feedback. Yes, this is a complicated issue... I've disabled the ability to open the sidebar for shared users because the way the program works is to sync the spreadsheet with individual google calendars. It can only do that when the user that is running the add-on has write access to each of those calendars, or else it doesn't sync as the user expects. For that reason, so far, I'm encouraging people to use one account to edit the sheet, and share with other users as read-only. At some point I'll create a sidebar option to share with write permissions with another user, which will automatically share all the managed calendars with that user as well, but need to be thoughtful about how the program will respond when users share the sheet manually without sharing each calendar. I'll let you know when I've come up with a solution!
Profile Picture
A User of Shift Scheduler
April 14, 2020
Does anyone know how to resend all the employees' calendars to them? I have some people that haven't been able to add the new calendar to their google calendar.
Is this review helpful?
Yes
No
Profile Pciture
A user of Shift Scheduler
May 19, 2020
Yes! You can always just delete and re-add the employee's gmail address. You can also reshare the calendar through Google Calendars (all the program does when you add an email to the Gmail Address field is share the calendar as read-only with that address).
Profile Picture
A User of Shift Scheduler
March 25, 2020
I love the idea and was happy with the features while setting it up. Unfortunately, it deleted two of my work center calendars with my entire shop's workload. Now I'm back to square 1.
Is this review helpful?
Yes
No
Profile Pciture
A user of Shift Scheduler
May 19, 2020
I've done a careful review of this, and think that you must have clicked through the warning here - it's impossible for shift scheduler to run the line of code that deletes and entire calendar without displaying a pretty large warning that you have to accept. I'm so sorry about the calendar issue, but don't think at this point that Shift Scheduler could have deleted this calendar without input.
1-10 of 35
Additional information
Connor Burke
Terms of Service
Search
Clear search
Close search
Google apps
Main menu