App Icon
Schedule session rosters from the registration information from a Google Form™. Automatically schedule sessions rosters choosing from multiple available activities. Checks room capacity.
Listing updated:July 30, 2022
Works with:
37,140
Overview
Planning a fun day or event with multiple activity options over multiple sessions? For example a school having a fun day with a rotation of activities. This Add-on collects NO user data. NO PII. Take the registration information from a Google Form™ and automatically generate session rosters. 

This Google Sheets™ Add-on is for the Form Responses from a Google Form™ with exactly one Multiple Choice Grid type question. Activity options are provided in the rows of the Multiple Choice Grid question. Column options allow the participant to rank their activity choices. For example, 1st choice, 2nd, 3rd.

In the Google Sheet™ with the Form Responses as the first tab, use the Extensions menu to select Scheduler by Alice Keeler. Setup the schedule. This will add a sheet with a grid of the activity choices and number of sessions. Fill in the room capacity for each activity and session. 

After participants have completed the registration/interest form, run sessions using Scheduler by Alice Keeler to automatically assign participants to an activity based on the availability of room in the session activity and preferred choice of the participant. 

Scheduler by Alice Keeler cycles through the activity list looking for participants 1st choice and if there is room in that activity assigns them to the session roster. It then cycles through looking for 2nd choice, then 3rd, etc.. until the participants are assigned a session activity. 

Due to room availability and participant choice selections some sessions slots are not assigned to a participant. Scheduler by Alice Keeler allows you to easily review which sessions still have room and assign to individuals. Option for mass assigning remaining participant slots to sessions that have room.

Create a schedule per participant in a Google Doc™ and email them their schedule of activities. 

Create a spreadsheet. per activity with a tab for each session and the list of participants in that session. 

BONUS FEATURE: for ANY Google Form™ get a list of who did NOT fill out the Google Form. Add a sheet to your Form responses spreadsheet that contains the email addresses of who you expect to fill out the Form. 
Additional information
PricingFree of charge with paid features
Developer
Privacy policy
Terms of service
Scheduler by Alice Keeler will ask for the permissions shown below. Learn more
Scheduler by Alice Keeler will need access to your Google account
This will allow Scheduler by Alice Keeler to :
See, edit, create, and delete all your Google Docs documents
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
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:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Vicky Rankin
June 2, 2022
Awesome job! but the bonus part of this (who did not fill out the form) saves so much time searching!
Is this review helpful?
Yes
No
Profile Picture
Bob Smith
April 23, 2022
This made our activity day so much better! Everyone should be using this to keep track of where kids are suppose to be without having to chase them!
Is this review helpful?
Yes
No
Profile Picture
Kristen Longstaff
April 23, 2022
Wow this is Awesome. Thank you so much Alice really will work well for me.
Is this review helpful?
Yes
No
Profile Picture
Beata Mcanally
April 23, 2022
HOLY COW this is amazing! It would be impossible to do this by hand. This makes creating an event so easy!
Is this review helpful?
Yes
No
Profile Picture
Ruben van Heerden
August 31, 2022
Great tool for assigning students to courses according to their preferences! Saved us a lot of time! Tip for users: Make sure the sheet has English set as the standard language for functions, otherwise the plugin won't work.
Is this review helpful?
Yes
No
1-5 of 5
Search
Clear search
Close search
Google apps
Main menu