How to scrape Google search results into a spreadsheet with XPathBuilder

Many SEOs are looking for a quick way to pull search results from Google into a spreadsheet for analysis. This is what XPathBuilder was meant to achieve.

This tool is built to utilize the importXML function available within Google spreadsheets.  Before you go any further, make sure your Google Docs account is open. (If you don’t have one, get one at docs.google.com.) Make sure you have a Google spreadsheet open so you have a place to paste your code.

XPathBuilder is really simple, or at least we hope it is.  Go to the front page of the site and enter the phrase you want to search, and select a search engine from the dropdown at the right.

Then click the Submit button at the bottom of the page. You’ll get a long string of code in the field just below the search phrase.

Select that string of code and paste it in your Google spreadsheet exactly as written. Then wait for the code to execute automatically.

(There are five separate string generators, so you can generate up to five separate strings at once.)

That’s it.  There are multiple applications for this particular approach.  And of course, it’s all free of charge.

I’m a professional SEO, so I look forward to this becoming a useful tool in the community.  If you have some suggestions for making this tool better, let me know.

Speak Your Mind

*