I have a excel sheet of a few thousand keywords. I need to evaluate the competition on google (google us) to see if i want to use them. What i need is a script that pulls up the results of serp and looks at the top 4 results. If all top 4 pages in the results are have a pagerank of 2 or under then the keyword passes. Also if there are pages of PR3 or PR4 i want to check if these pages have the keyword we are searching for in the title. If if doesnt have the keyword in title then it passes too. Everything else will fail. For successfull keywords i want it to dump the results back to me in a excel sheet.
I think the best way to do this is a php script? Im also aware that google could block access from my ip if there are too many requests within a certain timeframe so there needs to be some way throttle the requests.
(i forgot to mention, ideally you should be working out the pagerank within the script and not scraping it from a 3rd party site as they will obviously block me)