wow spreadsheet

spreadsheet setup

blizzard api access

Heads up: it can take up to 10 minutes for your new API credentials to start working (and sometimes longer, thanks blizz!)

Steps

  1. Obtain the template

    Click the link and go to the file menu of Google Sheets and click USE TEMPLATE in the upper right hand corner.

    Go to Template

    The spreadsheet template

  2. Sign up for the Blizzard Dev portal

    Go to https://develop.battle.net/ and click on Get Started Now.

    Blizzard developer portal

  3. Create a client

    Just click the button!

    Create client button

  4. Fill out the form

    Name your client, doesn't really matter what you choose.

    Leave the next box blank, you do not need any redirects.

    Check the box next to I do not have a service URL for this client.

    Type in your intended use for your key, which is a google spreadsheet.

    The create client form

  5. Reveal your secret

    Click on SHOW SECRET.

    Show secret button

    You'll now see your secret.

    The revealed client secret

  6. Enter your API info

    Put your API Client ID into the settings sheet cell E18.

    Put your API Client Secret into the settings sheet cell E19.

    You can change any of the other settings you want in Section (B) as well.

    The settings sheet

  7. Save your values

    Once you have entered your Client ID/Secret, type into cell E1 to save the settings to the script.

    Cell E1 on the settings sheet

  8. Super important.. DELETE!

    You will then need to delete your ID/secret from section (B)'s "New Values" column, to keep things secret!

    Clearing the New Values column