I've a spreadsheet with a lot of contact information. In order to sort the data, I want to rank them according to the +1's given on their website.
Is it possible to get the +1 count of a website using Google Spreadsheet?
Yes that's possible !! See the below-mentioned formula to do just that.
A2 = HYPERLINK("http://www.jacobjantuinstra.nl") =IMPORTXML( "https://plusone.google.com/u/0/_/+1/fastbutton?&count=true&url=" & A2, // URL "//div[@id='aggregateCount']" // xpath_query ) copy / paste =IMPORTXML("https://plusone.google.com/u/0/_/+1/fastbutton?count=true&url="&A2,"//div[@id='aggregateCount']")
URL that is being fed as a first argument for the
IMPORTXML formula, is constructed to contain the plusone URL that Google uses to perform +1 counts. The second argument is looking for a specific div, having an id equal to aggregateCount. All is possible when a website has a button, enabled for Google+.