Google Spreadsheets - Import Quest Data

[ev0]

I've gone ahead and started building a perfect scenario quest turn-in's for when WoD is released. To make life easier, i'm using google spreadsheets to organize everything.

Head to drive.google.com - create a new spreadsheet.


Now click at the top Tools -> Script Editor




Create a new script and call it w/e you want. Save it and paste the following into the editor:

//Possible types: "type","name","reqlevel","xp","share"
function wowhead(qid,type){
  var url = "http://bitchboxing.com/wowhead.php?id=" + qid + "&goal=" + type;
  var response = UrlFetchApp.fetch(url);
  return response.getContentText();
}

I'm hosting the XML parser on my own domain, if you feel weird about it i can give the PHP source for it as well.

Now save it again, and head back to the spreadsheet.

You can use the following function now as follows:

=wowhead(ID,"param")

ID = quest ID
params as follow:

type = daily or not daily
name = quest name
reqlevel = required level to accept quest
xp = amount of exp for quest
share = is the quest sharable or not

sample of function looks like this:

=wowhead("31528","name")
// output in the cell: A Worthy Challenge: Darkmaster Gandling