Google made changes to their results page. ImportXML doesn’t work anymore. So here’s a function you can use to get SERP results from Google.
http://go.girilaya.com/yc2oqw


Google Docs: https://docs.google.com/spreadsheet/ccc?key=0Apam75iNJI9idHkteFpGYjNhcjRBeUxsRWI0VER6ZWc

Source code: https://github.com/chrisle/seer.js-public

Latest Update: v1.2 Adds the ability to get page 2, 3, 4… etc using an offset (thanks @johnsee)

How to use it:

1. Click on File > Make a copy. Name it whatever you want.

2. In your spreadsheet, use this formula: =googleScraper("my keyword here")

That will default to 10 results.

To get more results:

Add a second parameter like this: =googleScraper("my keyword here", 30)

To add the formula to a different spreadsheet:

1. Go to the source code for google_scraper.js

2. Copy all that code to your clipboard

3. Create your new spreadsheet

4. Click on Tools > Script Editor

5. Paste all the code into the editor and save.

Updates

* 1.2.0 – Added ability to offset results (thanks @johnsee)
* 1.1.0 – Added ability to change the TLD
* 1.0.1 – Fixed Non-URL universal searches getting returned (Thanks Gareth Brown)
* 1.0.0 – Initial release
Sumber : http://go.girilaya.com/yc2oqw