| Importing Twitter Follower Counts into Google Spreadsheet | urpushingsocial | 12/12/11 8:30 PM | I need to populate a cell with twitter follower counts.For example: Cell A1 has the usernameCell A2 would reference A1 and get the follower count from Twitter. I've tried importXML but can't reference the appropriate node via xPath.I'm new to this an |
| Re: Importing Twitter Follower Counts into Google Spreadsheet | SminxMarkus | 12/19/11 3:10 AM | I too am interested in this feature, any help again would be much appreciated! :) |
| Re: Importing Twitter Follower Counts into Google Spreadsheet | slustgarten | 12/19/11 7:13 AM | This used to work: Type the following formula: =importXML("http://twitter.com/"YOUR_USERNAME,"//span[@id='follower_count']") BUT for some reason, two weeks ago it stopped working claiming the XPATH query didn't return any data... If somebody knows h |
| Re: Importing Twitter Follower Counts into Google Spreadsheet | sfoskett | 1/22/12 12:44 PM | I figured out a way to do it. http://mobile.twitter.com is still somewhat parseable with ImportXML. I put an example on my web page:http://blog.fosketts.net/2010/07/02/cool-google-spreadsheet-importxml-xpath/ Basically, this should get you started:=importX |
| Re: Importing Twitter Follower Counts into Google Spreadsheet | kahleyavalon | 6/26/12 11:52 PM | Hello, I've researched all over and I still can't manage to populate my cells with anything but a #N/A error. Could you tell me if I'm doing something wrong? thank you so much |
| Re: Importing Twitter Follower Counts into Google Spreadsheet | Ian Lyons | 3/8/13 2:04 PM | Hey, They restructured their page a little bit, but that still works: =importXML("http://twitter.com/"&substitute(G3,"@","",1),"//a[@data-element-term='follower_stats']") |