App Icon
Connor Burke
•  30,508
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
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
A User of Shift Scheduler
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
A User of Shift Scheduler
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
A User of Shift Scheduler
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
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!
1-10 of 38
Additional information
Connor Burke
Terms of Service
Search
Clear search
Close search
Google apps
Main menu