SEO Tools check
Google has released a tool that help test whether a website is considered "mobile friendly" or not. But only for one website at a time. What if we need to bulk check lots of websites to spot the ones we need to fix?
The Google tool internally uses a JSON REST API whose result can look like this:
We're after value with the JSON path $.ruleGroups.USABILITY.pass.
To build a new scraper, create a file myscrapers.xml under /scrapers/ in your SeoTools installation path with the following contents:
I've added 1000ms interval between requests to not piss Google off (so they won't block my IP).
If you have Excel open you need to restart Excel. We now have a new scraper:
Since the Google API is quite slow you will need need to wait a while for the results. Excel might seem to freeze, but that's just SeoTools working in the background.