Home » Google » Apps » Apps Script » Group Maker: Automatically Make Groups with Google Sheets

Group Maker: Automatically Make Groups with Google Sheets

Group Maker

This template allows you to copy and paste your roster of students and have them randomly divided up into groups.

The Template


Paste Roster

After creating a copy of the template, paste your student roster into column A. Default group size is 4. Change the group size in cell B1.
Column A

Add On Menu

Use the Add-On menu to find “Group Maker.”
Group Maker

Click the button to make groups.
Click button

Each student is assigned a random number. The list is then sorted by random number and students are assigned to a group.
Make Groups

24 thoughts on “Group Maker: Automatically Make Groups with Google Sheets”

  1. Pingback: Group Maker: Automatically Make Groups with Google Sheets | Instructional Know-How

  2. Pingback: Google-länkar som bonus mitt emellan två avsnitt – Skolspanarna

  3. Pingback: Google Apps Script: Create an Add-On - Teacher Tech

  4. Cole Kleinwolterink

    Is there a way to copy and paste Group Maker Google Sheets template allowing a teacher to have 1 Google Sheet with a separate tab for each class?
    Using select all, then pasting in to new tab doesn’t seem to work. The format gets copied and pasted but when I try to run the Add-On, it doesn’t work.

  5. Pingback: The Power of Peers: Getting More Out of Group Work

  6. I am trying to use your group maker template. I input the roster names and click the make random groups button and it randomizes the order of the students, gives them a random numerical value, but it only makes 1 group. What am I doing wrong?

  7. This is an awesome tool! I have all my names in the list, have changed my group size to 3 but when I go to the add on part there is no add on option for Group Maker. Can you help?

  8. Pingback: Nov. 20 | ES Technology

  9. I have successfully used Group Maker in the past and LOVE IT! This time, however, the groups are forming, but the names are remaining in alphabetical order and this of course, eliminates the “random” factor. Please help.
    Thank you.

    1. Pingback: 10 add-ons to Google Classroom you MUST try - Ditch That Textbook

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.