I've been trying my best to get something like this to work for about 10-15 hours now and I'm just stumped. I've tried to work with this thread, as well as tradeskillmaster threads and also someone elses spreadsheet they used to use. Nothing is working as needed at this point.
I'm a bit lost in all the lingo as this is all new to me so even if I say something, I might not even know what the heck it is but I'll give it a go anyways.
I have my current setup as described in the first post with google sheets. I changed the first line to the following :
Yes, my apikey var is defined above the call.
var respsone = UrlFetchApp.fetch("https://us.api.battle.net/wow/auction/data/arthas?locale=en_US&apikey="+apikey+"");
When I run it. I get a "ReferenceError:"response" is not defined" message.