Migration tool Stream Classic and default destination

Connect-SPOService "<Your tenant admin URL e.g. tenant-admin.sharepoint.com>"

$inputFileContent=import-csv -Path "<Replace with your local Path>\MigrationDestinations.csv"
$outputfile = "<Replace with your local Path>\MigrationDestinations_LanguageDependent.csv"

$HeaderRow = "Name (for reference only),Source Path (for reference only),Destination Path,Migration status (for reference only),Created on (for reference only),Task ID"
Set-Content $outputfile $HeaderRow

foreach($element in $inputFileContent){

#init#
$name = $element.'Name (for reference only)'
$source = $element.'Source Path (for reference only)'
$destination = $element.'Destination Path'
$status = $element.'Migration status (for reference only)'
$created = $element.'Created on (for reference only)'
$taskId = $element.'Task ID'

<#
process transform from
English en-US 1033
to
French fr-FR 1036
German de-DE 1031
other references:
https://pkbullock.com/resources/reference-sharepoint-online-languages-ids/
#>
$URL=$element.'Destination Path'
$siteUrl=$URL.Replace("/Shared Documents","")
if($URL -like "https*"){
$site=Get-SPOSite -Identity $siteUrl
#fr-FR#
if($site.LocaleId -eq "1036"){
$NewURL=$URL.Replace("Shared Documents","Documents partages")
$destination = $NewURL
write-host "$URL --> $NewURL"
}
#de-DE#
if($site.LocaleId -eq "1031"){
$NewURL=$URL.Replace("Shared Documents","Gedeelde documenten")
$destination = $NewURL
write-host "$URL --> $NewURL"
}
}
$singleRow = "$name,$source,$destination,$status,`"$created`",$taskId"
Add-Content $outputfile $singleRow
}
Write-Host "`aDone!" -ForegroundColor Green