Welcome to the community
One thing you can do is …use a record macro and perfomr the steps manually…it would give to macro on how to add…you can use that macro anduse invoke macro activity instead of using ui on excel…and in invoke macro you can pass the url dynamically as input
Cheers