Complex formula needed to extract data from website!

Hello!

I'm basically looking for a formula that will allow me to automate the retrieval of data from a website.

My database looks like this

What I normally do is manually submit that site URL to a website like https://websiteseochecker.com/domain-authority-checker to extract its DA score.

But that DA score obviously does not update on my spreadsheet unless I input it and check it again.

So I'm looking to come up with some formula that can automatically get that score for me, and will update every time I open the sheet.

There are alternatives to https://websiteseochecker.com/domain-authority-checker which I can recommend, it does not have to be that site specifically.

I think this sort of task involves things like X paths and the importHTML function, neither of which I am familiar with, so any help would be massively appreciated!