How to make an html element src dynamic?

Aha - now I understand.

Your problem is really very simple. I think you just have to get the googlesheets field from the returned item.

Something like this:

let item = $w("#dynamicDataset").getCurrentItem();
let url = item.googlesheets;
$w("#myhtml").src = url; 

I hope this helps.