Google blocks its own IP's ?

Within 2012 I have been accustomed in using google spreadsheets for lots of different tasks. In most of my spreadsheets I am using scripts that make use of importXML that are able to extract information from XML formatted webpages. The last 2 days I have noticed that all of my scripts don't bring any result back.

Investigating on the return text of the importXML statements I receive the following message

"http://www.google.com/search?q=hello&start=0&num=100
To continue, please type the characters below:

About this page.  Our systems have detected unusual traffic from your computer network. This page checks to see if it's really you sending the requests, and not a robot. Why did this happen? This page appears when Google automatically detects requests coming from your computer network which appear to be in violation of the Terms of Service. The block will expire shortly after those requests stop. In the meantime, solving the above CAPTCHA will let you continue to use our services.This traffic may have been sent by malicious software, a browser plug-in, or a script that sends automated requests. If you share your network connection, ask your administrator for help — a different computer using the same IP address may be responsible. Learn moreSometimes you may be asked to solve the CAPTCHA if you are using advanced terms that robots are known to use, or sending requests very quickly.IP address: 74.125.184.85 Time:  2012-07-20T04:48:04 ZURL: http://www.google.com/search?q=hello&start=0&num=100"

74.125.184.85 is not my connection's IP. Doing a search on 74.125.184.85 I realize that this is a google owned IP

NetRange:       74.125.0.0 - 74.125.255.255
CIDR:           74.125.0.0/16
OriginAS:       
NetName:        GOOGLE
NetHandle:      NET-74-125-0-0-1
Parent:         NET-74-0-0-0-0
NetType:        Direct Allocation
RegDate:        2007-03-13
Updated:        2012-02-24
Ref:            http://whois.arin.net/rest/net/NET-74-125-0-0-1

OrgName:        Google Inc.
OrgId:          GOGL
Address:        1600 Amphitheatre Parkway
City:           Mountain View
StateProv:      CA
PostalCode:     94043
Country:        US
RegDate:        2000-03-30
Updated:        2011-09-24
Ref:            http://whois.arin.net/rest/org/GOGL

Its understable that importXML is done like an HTTP request from the server hosting the google spreadsheet application that I am using that is why the server's IP is used.

this has become a great problem for anyone used to rely on google spreadsheets that is why I am putting it out there

does anyone have a solution ?

Category: 

2 Comments