![]() ![]() P.P.P.S.: There are several services out there, e.g. I didn’t want to parse the page when Google Sheets provide me a simple function to do just that. Stupidly, Google Sheets functions are not available in Google Apps Scripts :( P.P.S.: Yes, I could have done all that work in a single app-script by fetching the page and then parsing it for data. P.S.: If anyone knows of a CWS/Chrome API that lets me fetch all this data without all this hassle, please (PLEASE!) do let me know. ![]() The rest of the spreadsheet is just the same, full of color-coded differentials to highlight outliers, and growth charts to inflate (or deflate) my ego. I’ve scheduled this script to run every day around noon, so by the time I check the stats at lunch, it’s already updated with latest data. Copying data: I wrote a basic app script to copy the fetched data onto a new row in the main sheet(s) where the base data is kept:.Importing data: The `importXML` function takes 2 arguments.įor the first argument, provide the URL of the extension for which I want the data, say ``.įor the 2nd argument, it takes the `XPATH` for the exact element on the page I want to fetch, in this case then clean the returned data (` 10,716 users`) to get a clean number (10716).Ī simple copy-paste-modify exercise gets me data for all my (and anyone else’s) extensions, as well as rating count and value.Last week, I finally went another step, and automated the whole thing using Google sheets’ importXML function. Now, instead of opening, and editing, a large spreadsheet, I had to fill in 7 textboxes on a webpage. Native Script Caller Featured 0. While this was relatively easy, if menial, on the desktop, it’s quite painful on the phone – copying numbers between two apps on the small screen.Īs the next step, I created a Google sheets form with the 7 fields, connected it to my CWS-data spreadsheet, and bookmarked the form on my phone homescreen. This tutorial walks you through creating your first Chrome App. Total Script Blocker is a smart extension that controls javascript, iframes, and plugins on Google Chrome. Google doesn’t provide an API to fetch extension data, so I’ve had to fill the data manually into the spreadsheet every day!įor a long time, I used to open my Chrome Web Store (CWS) developer dashboard every morning, and one-by-one fill in the numbers into the spreadsheet cells. While the analysis part, and the JSON-feed worked well, the data collection part was painful. The same spreadsheet also functions as a JSON-providing backend for data being funneled elsewhere (e.g. I use a spreadsheet (Google Sheet) to collect the data, and analyze trends, and catch (to diagnose) outliers. I have 7 Chrome extensions and apps and, as a chronic numbers addict, I like to keep track of their user numbers (WAU), and ratings. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |