rb.rb

# batch clear method
# [array of ranges], spreadsheet_id, Google::Apis::SheetsV4::SheetsService
def batch_clear_ranges(arr, spr_id, srvc)
  clear_request = Google::Apis::SheetsV4::BatchClearValuesRequest.new
  clear_request.ranges = arr
  puts "Clearing Range(s): #{arr}"
  resp = srvc.batch_clear_values(spr_id, clear_request)
  puts "Cleared: #{resp.to_h[:cleared_ranges]}"
end