require "rubygems"
require "google_spreadsheet"
require 'twitter'

googleSpreadsheetKey = "pyvjarV4_O3tUZZZsbqdtOQ"
googleUser = "YOUR GOOGLE EMAIL LOGIN HERE"
googlePassword   = "YOUR GOOGLE PASSWORD HERE"
twitterUserName  = "YOUR TWITTER USER NAME HERE"
twitterPassword    = "YOUR TWITTER PASSWORD HERE"

session = GoogleSpreadsheet.login(googleUser, googlePassword)

ws = session.spreadsheet_by_key(googleSpreadsheetKey).worksheets[0]

base =  Twitter::Base.new(twitterUserName, twitterPassword)

(1..1044).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 #{matched_user}"

 begin
    base.create_friendship(matched_user)
    puts "Success! Wine Tweep added!"
 rescue
    puts "******* Twitter FAIL  #{$!.message}. Excuses, excuses."
 end
end