seeds.rb

require 'rubygems'
require 'google_drive'

# set your username and password
login = GoogleDrive.login(GoogleDrive::USERNAME, GoogleDrive::PASSWORD)
# set your spreadsheet key
sheet = login.spreadsheet_by_key(GoogleDrive::SPREADSHEET)

sheet.worksheets.each do |ws|
  p ws.title

  model = eval(ws.title)

  columns = model.column_names
  rows = ws.rows.dup
  fields = rows.shift.map{ |k| k[/\w+/] }

  data = []
  rows.each do |val|
    ary = [fields.dup, val.dup].transpose
    ary.select!{ |a| columns.include?(a[0]) }
    data.push(Hash[*ary.flatten]) if ary
  end

  model.create!(data, { without_protection: true }) unless data.empty?
end