trello-weekly-report.rb

require 'rest-client'
require 'json'

apikey = 'YOUR-API-KEY'
token = 'YOUR-TOKEN'

board = 'YOUR-BOARD-ID' # e.g., My Tasks
list = 'YOUR-LIST-ID' # e.g., Done

output = File.open( "./output.txt", "a")

begin

  response = RestClient.get "https://api.trello.com/1/lists/#{list}/cards/?key=#{apikey}&token=#{token}"
  cards = JSON.parse(response.body)

  expected = []
  meetings = []
  unexpected = []

  cards.each do |c|
    label = c['labels'].first
    if label then
      color = label['color']
      case color
      when 'red'
        meetings << c['name']
      when 'yellow'
        unexpected << c['name']
      else
        expected << c['name']
      end
    else
      expected << c['name']
    end
  end

  output.write("## Expected")
  output.write("\n")
  expected.each do |e|
    output.write("* #{e}")
    output.write("\n")
  end
  output.write("\n")

  output.write("## Meetings")
  output.write("\n")
  meetings.each do |m|
    output.write("* #{m}")
    output.write("\n")
  end
  output.write("\n")

  output.write("## Unexpected")
  output.write("\n")
  unexpected.each do |u|
    output.write("* #{u}")
    output.write("\n")
  end

rescue Exception => e
  p e.message
end