Auto upload to Google Spreadsheet - jawslouis/Battlegrounds-Match-Data GitHub Wiki

Auto-uploading is an optional feature that is disabled by default. Setting this up will take about 20 mins.

Setting up Google API

  1. Go to Google Developers Console and create a new API project. It will take a few seconds to get ready.
  2. Go to "Credentials" on the sidebar, click “Create credentials” and select "Service Account Key". After creation, you will automatically download a credential JSON file. Copy the file to the plugins folder (or any other convenient location). Create Credentials
  3. Back at the Credentials page, select "Manage Service Account" (see below). Copy the email address for the service account and save it somewhere. Manage Account
  4. Go to Google Sheets API and enable the API.
  5. Create a blank Google Spreadsheet. Create two sheets: "MyResults" and "AllBoards".
  6. Add the service account as an editor, using the email copied in step 3. Copy the Spreadsheet ID, which is the jumble of letters in the URL. Example: docs.google.com/spreadsheets/d/16pcIzB7AsjM4KjJgHTMm3fJdo-4n2eK4PGN8qEJVZh0/edit#gid=0

Plugin Setup

  1. From the deck tracker toolbar, go to Plugins -> Battlegrounds Match Data Settings. This will open the below settings menu. Enable Google Spreadsheet Upload, and fill in the Spreadsheet ID and file location for the JSON credential.

Settings

  1. That's it. You're finally done! Restart Hearthstone Deck Tracker and make sure the plugin is enabled. Your games will now be both saved in a local CSV, and uploaded to your Google spreadsheet.