class Multiwoven::Integrations::Destination::GoogleSheets::Client

def update_sheet_values(values, stream_name)
  row_count = spread_sheet_value(stream_name).count
  range = "#{stream_name}!A#{row_count + 1}"
  value_range = Google::Apis::SheetsV4::ValueRange.new(range: range, values: values)
  batch_update_request = Google::Apis::SheetsV4::BatchUpdateValuesRequest.new(
    value_input_option: "RAW",
    data: [value_range]
  )
  # TODO: Remove & this is added for the test to pass we need
  response = @client&.batch_update_values(@spreadsheet_id, batch_update_request)
  [batch_update_request, response]
end