pivotal-to-trello.rb

require 'csv'
require 'pry'
require 'trello'

Trello.configure do |config|
  config.developer_public_key = 'TRELLO_PUBLIC_KEY'
  # Access https://trello.com/1/authorize?key=#{substitutewithyourapplicationkey}&name=My+Application&expiration=1day&response_type=token&scope=read,write
  config.member_token = 'ACCESS_TOKEN'
end

backlog = Trello::Board.find('LIST_ID').lists.first

csv = CSV.read('IMPORTED_CSV_FROM_PIVOTAL', headers: true)

csv.each do |record|
  next if record['Current State'] == 'accepted'
  title = record['Title']
  description = record['Description']
  Trello::Card.create(
    name: title,
    desc: description,
    list_id: backlog.id
  )
end