gistfile1.txt

require "rubygems"
require "google_spreadsheet"

  # Logs in.
  # You can also use OAuth. See document of GoogleSpreadsheet.login_with_oauth for details.
session = GoogleSpreadsheet.login(login, password)

  # First worksheet of http://spreadsheets.google.com/ccc?key=pz7XtlQC-PYx-jrVMJErTcg&hl=en
ws = session.spreadsheet_by_key(dockey).worksheets[0]

fname, lname, address = [], [], []

  for row in 2..ws.num_rows
    fname[row] = ws[row, 1].downcase.strip
    lname[row] = ws[row, 2].downcase.strip
    address[row] = ws[row, 5].sub('www.', '')

    puts "#{fname[row]}.#{lname[row]}@#{address[row]}"
    puts "#{fname[row]}@#{address[row]}"
    puts "#{lname[row]}.#{fname[row]}@#{address[row]}"
    puts "#{fname[row][0,1]}.#{lname[row]}@#{address[row]}"
    puts "#{fname[row]}.#{lname[row][0,1]}@#{address[row]}"
  end