Ben S. did you try the built-in clay enrichment 'find redirect page'? usually works well enough and I see it returns the correct result in this example. sometimes, it does not return anything though so it makes sense to add one more step before you use its output - merge columns. so let's say your input domain in in column 1, redirect url in column 3 so in column 4 you merge columns 3 and 1 and use it in further processes
