I've just started testing this integration today and it's really promising! I did stumble across the same issue as @careful-insurance-60247 and @early-article-88153 (many thanks for the thorough feedback) related to the ingestion of sheets external urls and I've submitted a PR

do you lose lineage in that way?

AFAIK its purpose its only to be the link in the "View in Tableau" button