Thank you for your reply.
One way to do this is to use Integromat. There is a free plan, you get 1,000 operations. Although, you can only have two active scenarios at the same time.
Here’s the website:
Is there a unique key in Google Sheets? Or are you using Excel?
You could use the key to place all the URL’s into Airtable.
I have a similar setup and I use Integromat, so if you need help, I can give it a try.
Is this how your spreadsheet looks, except with your own links?