I talked in depth here about a script I wrote in Python that pulls the play data for all of the board games that my boyfriend play together and puts it into a spreadsheet (and I talk about the actual spreadsheet here). I thought others might be interested in doing the same for their own play data, so I generalized the script and spreadsheet. You can download this new, generalized script here.
In order to use the script, you’ll need:
- A google account
- Python 2.7
- The Python modules gspread, json, oauth2client, and boardgamegeek
I’m going to assume you already have and are familiar with the programming language Python. If not, the Python documentation is a good place to start. If you are interested in using this script but are struggling with the Python aspect of it, let me know and I’ll do my best to help you get it up and running.
Before running the script, you will need to create a worksheet within Google docs (or copy the one I made here). In one of the sheets, you will need the first row (the header row) to include the columns:
The header row shouldn’t contain any spaces and should be all lowercase.
Next, you’ll need to get a .json file with your Google API credentials. This is described step-by-step here under Connecting to Sheets with Python. Follow the steps under Google Developer and Share Your Spreadsheet.
Finally, you will need to edit the script to let it know your credentials. After the imports section, the first several rows will need to be filled in:
#– Attention! Be sure to edit these values! –#
json_file = ‘API Project-12345abcd.json’ # your json file name (name.json)
worksheet = “boardgame_test” # worksheet name
spreadsheet = “Sheet1” # spreadsheet name that you want the data to go into
bgg_username = “mad4hatter” # your bgg username
username = “Allison” # your name
oldest_game = datetime(2015,12,31,0,0,0) # year, month, day of the oldest game you want to import (only valid for first time running the script)
- File name for your .json file (obtained from Google Developer). This file should be in the same directory as the python script.
- worksheet name (this is the filename of the Google Spreadsheet)
- the name of the sheet which contains, at a minimum, the headers: date, gamename, winners, duration, and comment
- username of the person whose play data you want to pull
- your name as it appears in your play data.
After that, you should be able to run the script. If you have any issues, let me know in the comments or contact me.