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:May 12, 2022
Works with:
24,339
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
PricingPaid with free features
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:
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
1-3 of 3
Search
Clear search
Close search
Google apps
Main menu