GoogleDocsのスプレッドシートを利用してスコアデータを蓄積させる

desc "send score data to google spreadsheet"
require 'google_drive'

namespace :batches do

  task total_scores: :environment do |t, args|
    fail 'no username' if ENV['GOOGLE_USERNAME'].blank?
    fail 'no password' if ENV['GOOGLE_PASSWORD'].blank?

    session = GoogleDrive.login(ENV['GOOGLE_USERNAME'], ENV['GOOGLE_PASSWORD'])
    spreadsheet = session.spreadsheet_by_key("input key name")
    worksheet = spreadsheet.worksheet_by_title(Rails.env)
    analyze_data = {
      date:           Time.now.strftime("%Y-%m-%d"),
      users_num:      User.all.count,
      items_num:      Item.all.count,
      comments_num:   Comment.all.count,
      categories_num: Category.all.count
    }
    worksheet.list.push(analyze_data)
    worksheet.save()
  end

end

$ bundle exec rake batches:total_scores
WARNING: Nokogiri was built against LibXML version 2.8.0, but has dynamically loaded 2.7.8
rake aborted!
Authentication failed for hogehoge@gmail.com: Response code 403 for post https://www.google.com/accounts/ClientLogin: Error=BadAuthentication
Url=https://www.google.com/accounts/ServiceLogin?service=wise#Email=hogehoge%40gmail.com
Info=WebLoginRequired
/home/sqale/current/vendor/bundle/ruby/2.0.0/gems/google_drive-0.3.6/lib/google_drive/session.rb:93:in `rescue in login'
/home/sqale/current/vendor/bundle/ruby/2.0.0/gems/google_drive-0.3.6/lib/google_drive/session.rb:86:in `login'
/home/sqale/current/vendor/bundle/ruby/2.0.0/gems/google_drive-0.3.6/lib/google_drive/session.rb:38:in `login'
/home/sqale/current/vendor/bundle/ruby/2.0.0/gems/google_drive-0.3.6/lib/google_drive.rb:18:in `login'
/home/sqale/current/lib/tasks/scores.rake:10:in `block (2 levels) in <top (required)>'
Tasks: TOP => batches:total_scores
(See full trace by running task with --trace)