Convert a Google Sheet into a Ruby Array of Hashes

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

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

# with the following environment variables set
# GOOGLE_ACCOUNT_TYPE=service_account
# GOOGLE_CLIENT_EMAIL=...
# GOOGLE_PRIVATE_KEY=...

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)] }