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]
#puts ws.rows[1]
#fname = []
#lname = []
#address = []

fname = Array.new 
lname = Array.new 
address = Array.new
  formatted_rows = ws.rows.map do |row|
    
    fname[row] = ws[row, 1].downcase.strip
    "#{fname[row]}.#{lname[row]}@#{address[row]}"
  end
  puts formatted_rows