benchmark_large_spreadsheet.rb

require "google_drive"

session = GoogleDrive.saved_session

spreadsheet = session.spreadsheet_by_url("https://docs.google.com/spreadsheets/d/1ScxgwUUrXOtvxw4eqhoR6pMkEdC4oYM3zOjq_6gZAAc/edit#gid=0")
ws = spreadsheet.worksheets[0]
start_time = Time.now
ws.cells
end_time = Time.now
puts("Took %f secs." % (end_time - start_time))

create_large_spreadsheet.rb

require "google_drive"

session = GoogleDrive.saved_session

spreadsheet = session.create_spreadsheet("Large speradsheet")
ws = spreadsheet.worksheets[0]
ws.max_cols = 50
ws.max_rows = 1000
(1..ws.max_rows).each do |r|
  (1..ws.max_cols).each do |c|
    ws[r, c] = "#{r}_#{c}"
  end
  ws.save if r % 100 == 0
end