^(I know this isn’t a pick’ems or survivor community. I reached out the) [^(r/NFL)](https://www.reddit.com/r/NFL/) ^(mods last year and asked if I could post there, but they suggested I try a team sub instead. As a Hoosier (though a Boilermaker by college, I’m a big Colts fan and was hoping this would be a helpful or fun diversion for everyone here.) We need a distraction from the JT situation…)
**Run your own pick’ems and/or survivor pool with this script and your own Google account**
Google Script to run within Google Sheets that pulls from a template form to create a season-long NFL Pick’Ems league run through a Google Sheet with a weekly updating Google Form to receive responses from members. It also creates all the formulas and nice conditional formatting you see below.
​
[Weekly Sheet](https://preview.redd.it/npgaz0zymplb1.jpg?width=2304&format=pjpg&auto=webp&s=c4a33f72404067ef35d4be77e69cface989028d3)
​
[Survivor Sheet](https://preview.redd.it/9qjcvutzmplb1.jpg?width=1057&format=pjpg&auto=webp&s=6e8b2fbc05355711cf4105af04b3518ed0d9970e)
​
[Summary Sheet](https://preview.redd.it/rrhtfzq0nplb1.jpg?width=1889&format=pjpg&auto=webp&s=659cb7d94f2a2c2c3641a29717c997e0229d80d6)
I’ve developed a very long Google script that creates a semi-robust way of managing an NFL pick ’ems or survivor league. It creates a series of sheets in a spreadsheet for tracking all picks through the 18 regular season games of an NFL season. It also includes a Monday Night Football most correct season-long winner, a weekly most correct winner, and a season-long most correct winner. The tool will also create a simple Google Form (questionnaire) that is used to collect responses from members that can be imported to the spreadsheet easily. Lastly, another custom script will pull in match results and tiebreaker scores. The final Monday Night Football game score total each week is used as the tiebreaker for the pick ‘ems weekly competition (some weeks we do have 2 MNF games).
It’s up to the person running the league to import the picks for the week (ideally before Thursday night) and also to update the form for the coming week (usually done Tuesday or Wednesday morning to send to the members).
**Changes from the** [**previous version**](https://www.reddit.com/r/fantasyfootball/comments/x2nrwn/run_your_own_pickems_free_google_sheets_forms_nfl/)**:**
* **Creation of a Drive Folder for storing Google Forms** (as there will be multiple, see next bullet)
* **A new Form for each week is created**, rather than the same Form being cleared and re-created
* This means that all previous picks and data will be backed up, so to speak, in a previous week Form
* Be sure to get the shortened URL from the pop-up that occurs after Form creation (or find it in the CONFIG tab) to send to members
* **Survivor pool ONLY** option (I had multiple requests for this, as many of you don’t want to do a weekly pick ‘ems)
* **Survivor pool restart** feature
* Last season, my group enjoyed restarting the survivor competition after about week 7 with how quickly it ended due to the nature of the NFL
* If the entire pool is eliminated (should be auto-detected), the “Create Form” menu function script should prompt to restart the survivor pool
* **Member-specific Survivor Form questions**
* After the first week, this will create a specific follow up question to name selection in the Google Form to only allow each user to select a team from their remaining Survivor teams. This helps avoid someone accidentally submitting a team they’ve already used.
* This is likely the most complex addition to the script and does make form creation a little slower
* **New NFL Outcomes sheet** (see representation in Example Sheets section)
* If running a survivor-only group, this tab is where the weekly winners will be entered
* If running a group with pick ‘ems included, this is for reference only (as a formula for populating the cells will be present
* If the whole column of games is populated for the given week, this sheet will be what the “Create Form” function will assess in order to suggest the next week
* Tons of efficiencies, error checks, and prompts added in hopes of making it more intuitive and easier to use
**TL:DR** The script sets everything up to manage your own pick ’ems league and/or survivor pool. You need to run an import and a new form menu function each week. Tiebreakers decided by MNF total score. Use one of the links below to access the code and read instructions for setting it up.
Here’s a [**Google Document**](https://docs.google.com/document/d/1cz3314rd8fcI7bUQNx4J4f9mGLoIQArAa4n_aYDyCps/edit?usp=sharing) with all the instructions and the code pasted at the bottom.
Alternatively, here’s a [**GitHub link**](https://github.com/boilermaker-ben/Google-Sheets-NFL-Pick-Ems-and-Survivor-Pool/).
**Disclaimer:** As a father of four young boys, I can’t promise I’ll be able to help if things break for you, but let me know if you hit any issues. Hope some of you find this helpful!