Google Sheets with roo and roo-google

code.rb

require 'roo-google'

# Setup your key and credentials
key = "googleSheetsUniqueId"
user = "user@domain.com"
password = "mysupersecretpassword"

gsheet = Roo::Google.new(key, user: user, password: password)
rows = gsheet.first_row..gsheet.last_row
columns = gsheet.first_column..gsheet.last_column

# iterate over each row in the spreadsheet
rows.each do |row|
  columns.each do |column|
    puts "Value at [#{row},#{column}] is: #{gsheet.cell(row, column)}"
  end
end

Gemfile

gem 'roo', github: 'roo-rb/roo'
gem 'roo-google', github: 'roo-rb/roo-google'