Learned to webscrape using Google Sheets
Google Sheets (and I suppose Microsoft Excel) is the gift that keeps on giving.

I learned that you can webscrape in Sheets! Seriously, what can't Google Sheets do at this point.

I follow Bob from Tawcan.com for insight on dividend investments and came across his post about using google spreadsheets to track data from Google Finance or Yahoo Finance. I already know that you can use the built in `GOOGLEFINANCE` formula to do currency conversion or get stock info but I couldn't find a way to get dividend or yield data.

Bob uses `IMPORTXML` and `IMPORTHTML` to scrape data. I ended up going on a rabbit hole and tried using these formulas myself and as a result learned about XPath and XQuery.