Coming from the Rails world I thought would do the right thing and DRY it up with a little script. So little it will fit right here for the world to grab:
google_user = "XXXXXXXX"
google_pw = "XXXXXX"
twitter_user = "XXXXXXX"
twitter_pw = "XXXXXXX"
session = GoogleSpreadsheet.login(google_user, google_pw)
ws = session.spreadsheet_by_key("p3LA_Q08eM-VAAyq03ZSjYQ").worksheets[0]
base = Twitter::Base.new(twitter_user, twitter_pw)
(1..1000).each do |row|
url = ws[row,2]
matched_user = url.match(/http:\/\/.*twitter.com\/(.*)/)
next unless matched_user
matched_user = matched_user[1]
puts "Attmepting to follow "
begin
base.create_friendship(matched_user)
puts "success"
rescue
puts "******* Failed "
end
end
You can grab the code from github at http://github.com/digidigo/iphone-dev-tweeters-/tree/masterYou will need to grab a few ruby gems to make this work. Check out the google spreadsheet gem at http://github.com/gimite/google-spreadsheet-ruby/tree/master . And then the twitter gem at http://twitter.rubyforge.org/rdoc/
So go out there and be crazy like me and see what all of us Iphone devs are tweeting about.
If you get an error like this:
ERROR: Error installing twitter: echoe requires RubyGems version >= 1.2
You will need to update your rubygems. gem update --system should do the trick.