Google Hacks

Scraping Google Groups

Pulling results from Google Groups searches into a comma-delimited file.

It’s easy to look at the Internet and say it’s web pages, or it’s computers, or it’s networks. But look a little deeper and you’ll see that the core of the Internet is discussions: mailing lists, online forums, and even web sites, where people hold forth in glorious HTML, waiting for people to drop by, consider their philosophies, make contact, or buy their products and services.

Nowhere is the Internet-as-conversation idea more prevalent than in Usenet newsgroups. Google Groups has an archive of over 700 million messages from years of Usenet traffic. If you’re doing timely research, searching and saving Google Groups message pointers comes in really handy.

Because Google Groups is not searchable by the current version of the Google API, you can’t build an automated Google Groups query tool without violating Google’s TOS. However, you can scrape the HTML of a page you visit personally and save to your hard drive.

Saving Pages

The first thing you need to do is run a Google Groups search. See the Google Groups [Hack #30] discussion for some hints on best practices for searching this message archive.

It’s best to put pages you’re going to scrape in order of date; that way if you’re going to scrape more pages later, it’s easy to look at them and check the last date the search results changed. Let’s say you’re trying to keep up with uses of Perl in programming the Google API; your query might ...