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.