Convert a Google Sheet into a Ruby Array of Hashes

_README_.md

Convert a Google Sheet into a Ruby Array of Hashes

Example

id	first_name	last_name
1	Trey	Anastasio
2	Mike	Gordon

becomes

[
  {
    'id': 1,
    'first_name': 'Trey',
    'last_name': 'Anastasio'
  },
  {
    'id': 2,
    'first_name': 'Mike',
    'last_name': 'Gordon'
  }
]

Authentication

Set the following environment variables:

export GOOGLE_ACCOUNT_TYPE=service_account
export GOOGLE_CLIENT_EMAIL=...
export GOOGLE_PRIVATE_KEY=...

See google-auth-library-ruby for additional detail.

gems.rb

source 'https://rubygems.org'

gem 'google-api-client'

google-sheet-to-array-of-hashes.rb

require 'google/apis/sheets_v4'
require 'googleauth'

authorization = Google::Auth::ServiceAccountCredentials.make_creds(
  scope: ['https://www.googleapis.com/auth/drive']
)

service = Google::Apis::SheetsV4::SheetsService.new.tap do |service|
  service.authorization = authorization
end

keys, *values = service.get_spreadsheet_values(
  'spreadsheet_id',
  'A:ZZ'
).values

rows = values.map { |row| Hash[keys.zip(row)] }