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

Digiprove sealCopyright secured by Digiprove © 2015

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. Alice, when I run the script, it starts to make groups and add the links to the group docs then fails. Can you help?

    1. Couple of reasons. If you’re on your school account it might be blocked by your apps admin. Try your @gmail.com account. Other is it times out because your internet is slow

  5. 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.

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

  7. 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?

  8. 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?

    1. It can take a couple of minutes depending on internet speed for it to load the code. In rare instances the code doesn’t get copied and you have to start with a fresh group maker.

  9. Pingback: Nov. 20 | ES Technology

  10. 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. I just tested it. Works. The sort code can be fussy so if it’s being quirky that day just use the trick of highlighting range of students and right clicking to randomize the range.

  11. 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.