update_pixela.rb

require 'date'
require 'google_drive'
require 'pixela'

CREDENTIAL_PATH = File.join(__dir__, 'secret', 'credential.json')
SPREADSHEET_KEY = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
PIXELA_USERNAME = 'xxxxxxxxx'
PIXELA_TOKEN = 'xxxxxxxxx'
PIXELA_GRAPH_ID = 'xxxxxxxxxx'

session = GoogleDrive::Session.from_config(CREDENTIAL_PATH)
spreadsheet = session.spreadsheet_by_key(SPREADSHEET_KEY)

genre_worksheet = spreadsheet.worksheet_by_title('問題')
num_questions = genre_worksheet[1, 1].to_i # ここに問題数が入っているとする

tmp_worksheet = spreadsheet.worksheet_by_title('tmp') # 作業用のワークシート
date = Date.today - 1
if tmp_worksheet[1, 1] == date.to_s
  # skip
  return
end
prev_num_questions = tmp_worksheet[2, 1].to_i
delta = num_questions - prev_num_questions

if delta > 0
  client = Pixela::Client.new(username: PIXELA_USERNAME, token: PIXELA_TOKEN)
  client.create_pixel(graph_id: PIXELA_GRAPH_ID, date: date, quantity: delta)
end

tmp_worksheet[1, 1] = date.to_s
tmp_worksheet[1, 2] = num_questions
tmp_worksheet.save