I was inspired by BreadStickNinja’s chart in a recent thread and wanted to do something similar to keep track of my own progress.
This is updated automatically every day at 5 am thanks to a short script that performs an API call and parses the data I want into the columns you see in the sheet. This is super easy (well slightly easier than dealing with EVE’s xml nonsense with their API) since WK’s API returns the data in JSON format.
Source code: http://paste.ee/p/2oNqz
As you can see it’s pretty simple; so if you have any experience with Google app scripts and want something like this for yourself it can be accomplished in about 10 minutes.
You can actually get a copy of this up and running for yourself with a little work:
First make a copy of my sheet:
This makes a copy of the sheet on your own Google drive; including the script to pull the API info.
Now go to Tools > Script Editor…
Replace my API key (highlighted) with your own:
To set it up to run automatically; click the clock icon:
Then click “Add a new trigger” and set it up like this:
Don’t forget to click save!
Also thanks to DeviMevi who originally posted screens in the thread on setting up the scheduler. I only made new ones since his were in polish