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
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: 220.127.116.11 Time: 2012-07-20T04:48:04 ZURL: http://www.google.com/search?q=hello&start=0&num=100"
18.104.22.168 is not my connection's IP. Doing a search on 22.214.171.124 I realize that this is a google owned IP
NetRange: 126.96.36.199 - 188.8.131.52 CIDR: 184.108.40.206/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 ?