Automated World Cup Bracket Challenge
Use this Google Sheets based template to organize your companies office pool by automatically importing World Cup results and your colleague’s selections to a single spreadsheet which calculates a winner. Click “Use Template” below and then scroll down this page for instructions on how to configure.
How does it work?
Using Sheetgo you will consolidate the selections of your colleagues and the results of the games into your template which automatically updates the standings and calculates the winner. Follow the steps below to configure your World Cup Challenge.
Click this link (https://app.sheetgo.com/) to install Sheetgo for Google Drive (if you already have Sheetgo still follow the link to access the template). In doing so you will automatically create a World Cup Organizer spreadsheet connected to our results gallery.
Send the bracket to your colleagues
Send your colleagues an email with this URL (https://www.sheetgo.com/gallery/world-cup-challenge/player/) to make their selections. When completed they should share their World Cup Bracket Google Sheets file with you. Save all of these files in a single folder.
Consolidate your colleague’s responses
Once you have selections from at least one other player (could be your own), open the Sheetgo and click on the green “plus” icon to create a new connection. Click on “ADD SOURCE” then find the folder you created in step 2 with your colleagues selections, open the folder, and click “SELECT THIS FOLDER”.
Choose your destination spreadsheet
Click on “Data destination” section then “CHANGE DESTINATION” to find the World Cup Organizer spreadsheet that you created in step 1. Now click the green check mark to finalize the connection. This will automatically send the data from the other players selections to your World Cup Organizer spreadsheet.
Your bracket challenge is live. Tell your colleagues they can provide their picks up until kick off of the first game on June 14th. Your dashboard tab will be updated every as results come in and you refresh hour as game results come in to let you know who is leading your tournament challenge. Feel free to share your spreadsheet (view only) with your colleagues so they can follow along… or try to export the leaderboard from your sheet to their using Sheetgo.