Use Google Sheets' ImportXML function to scrape and visualize data
Google Sheets has a built-in function called ImportXML which can be used to scrape publicly available structured data from webpages. ImportXML imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. In this post we’ll show you how to use the ImportXML function to aggregate Pinterest followers from different Pinterest accounts into a Google Sheet, and then visualize that information using Geckoboard’s Spreadsheets data source.