I feel like there’s some information we’re not getting. As in, why would the URLs redirect? Why can’t you just include the URLs in their final form to begin with?
Either way, try this Workflow. It should do what you want.
It works by first making a web request and getting the final redirect, and only then opening them in the browser (makes double the web requests, but is way easier to build than the other way around). It will copy all URLs to the clipboard separated by newlines. If you want to change the URLs, open the Run Script and change the starting lines in quotes (lines 2–4). Keep the same pattern: in double quotes, and use ${1} for the place where your query will be substituted.
