I’ve done a decent amount of scraping with Google Sheet’s IMPORTXML function and Google Script/javascript (although I always hope for an API instead). I’ve dabbled some in Python and PHP to do it as well.
I often rely on nice little tools like the browser plugin Scraper for lightweight stuff. IMPORTHTML in Google sheets is a handy way to get tables.
I came across Spatula the other day and will likely give it a shot the next time something comes up.
Sorry for the lack of links. I can only use two as a new user.