GSuite App Script (script.google.com)

FormGenerator.gs

This code will generate a PickEm Google Form. Script takes about 1 minute to complete.

User will need to adjust lines 3, 7, 20, 21.

Line 3: Change number to the desired week.
Line 7: You can add a description to the form. You can remove this if not needed.
Line 20: Paste the Google Sheets ID. The spreadsheet should be in the form [Week, Day, Away, Home]
Line 21: Adjust the data range of the spreadsheet (if you make changes to the csv file).

---

nflschedule2019.csv

The dataset is the NFL schedule for 2019.
Make sure to import the CSV file to Google Sheets! You will need the Google Sheets ID for the file.