I've had pretty good luck using Google Appscript to either access web APIs or screenscrape, then parse into a Google Sheet (which I either use as-is or as the source to populate a web app).