Vimeo CSV downloader

example_user_1_clips_csv_starting_id_1.csv

vimeo.rb

# frozen_string_literal: true

require 'roo'
require 'uri'
require 'open-uri'

puts
puts 'Files: '
puts Dir.glob('*.csv')
puts

DIR_NAME = 'Vimeo_downloads'
Dir.exist?(DIR_NAME) || Dir.mkdir(DIR_NAME)

picked_files = []
keep_getting_input = true
print 'File name: '

while keep_getting_input == true
  input_file = gets.chomp
  if input_file == ''
    keep_getting_input = false
    puts
  else
    print 'File name: '
    picked_files << input_file
  end
end

puts 'Downloading videos...'

picked_files.each do |picked_file|
  target = Roo::Spreadsheet.open('./' + picked_file, extension: :csv)
  amount = target.last_row

  2.upto(amount) do |row|
    name = target.cell('C', row)
    url = URI(target.cell('F', row))

    Kernel.open(url, 'r') do |chunk|
      file = File.open("./#{DIR_NAME}/#{name}.mp4", 'w')
      file.write chunk.read
      file.close
    end
  end
end

puts 'Done!'