---
title: "An automatic random team maker using Google Apps Script"
author: "Martin Hawksey"
date: 2022-10-08T06:51:41+00:00
canonical_url: https://pulse.appsscript.info/p/2022/10/an-automatic-random-team-maker-using-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2022/10/an-automatic-random-team-maker-using-google-apps-script.md
categories:
  - "Beginner"
  - "Sheets"
  - "Solutions"
  - "V8"
tags:
  - "@barrielroberts"
  - "bazroberts"
  - "bazroberts.com"
  - "Medium"
featured_image: https://pulse.appsscript.info/files/2022/10/0_5b_RUyhUuZTiMb8S.png
description: "Nice 'weekend project' from Baz Roberts highlighting how Google Apps Script can be used to do a weighted random shuffle of data. The post includes a line-by-line explanation of what the script is doing and a great resource if you are at the beginning of your Apps Script journey."
---

# An automatic random team maker using Google Apps Script

![An automatic random team maker using Google Apps Script](https://pulse.appsscript.info/files/2022/10/0_5b_RUyhUuZTiMb8S.png)

> [https://medium.com/@bazroberts/automatic-team-maker-apps-script-cfe32eabadf7](https://medium.com/@bazroberts/automatic-team-maker-apps-script-cfe32eabadf7)
> In this post, we’re going to look at a script to be able to make even teams from a selection of players. I play football every Sunday and every week my friends sign up to play and most weeks there are different players playing, so we end up having to make the teams, and trying to do it as fairly as we can, which inevitably takes some time.

Nice ‘weekend project’ from Baz Roberts highlighting how Google Apps Script can be used to do a weighted random shuffle of data. The post includes a line-by-line explanation of what the script is doing and a great resource if you are at the beginning of your Apps Script journey.

Source: *[Automatic Team Maker — Apps Script*](https://medium.com/@bazroberts/automatic-team-maker-apps-script-cfe32eabadf7) (also [available on bazroberts.com**](https://www.bazroberts.com/2022/09/28/automatic-team-maker-apps-script/))

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2022/10/an-automatic-random-team-maker-using-google-apps-script/](https://pulse.appsscript.info/p/2022/10/an-automatic-random-team-maker-using-google-apps-script/)*