Google

Web-scraping with Google Sheets and XPath

One of the more advanced features available to Google users, is the user’s ability to scrape data – from the web – directly into a Google spreadsheet through utilizing the ‘=IMPORTXML‘ function, combined with XPath. The script to follow outlines this functionality by scraping a simple data table from a public website and loading the results into a spreadsheet . In practice, …

9 Box Employee Performance Matrix with Google ‘=query’ (Video Series)

This is a 4 part video series on how to create a 9 Box (Employee Performance) Matrix, using Google’s ‘=query’ function in Google Sheets. For an introduction to Google’s Query function, you can jump directly to Video 3 Apologies upfront for the low volume and my weird accent. Still getting used to the new recording equipment. This is a first attempt, …