GDrive to YAML

gdrive_to_yml.rb

#!/usr/bin/env ruby
require 'pry'
require 'yaml'
require 'google_drive'

GDRIVE_USER = ENV['GDRIVE_USER'] || raise('Please set the GDRIVE_USER environment variable')
GDRIVE_PASS = ENV['GDRIVE_PASS'] || raise('Please set the GDRIVE_USER environment variable')
YML_FILE    = 'apple_app_info.yml'

data      = {}
session   = GoogleDrive.login(GDRIVE_USER, GDRIVE_PASS)
worksheet = session.spreadsheet_by_key('1ZFVvuAgsjU8Nu-sQ2IzgTriHJU8LwKNRaddczrz4IHA').worksheets[0]

binding.pry

worksheet.rows.each do |item|
  data[item[1]] = {
    'apple_id'  => item[2].to_s,
    'sku'       => item[3].to_s,
    'shortname' => item[4].to_s
  }
end

file = File.open(YML_FILE, 'w')
file.puts(data.to_yaml)
file.close