i have a question about how can use web page component, details as below, anyone can give me some advise.
now i want to embed Google sheets into tableau dashboard, i use web page component and input google sheets url, but user have another question, want to have some access, means, user A just see thermself data, can not see other data,
so, i use worksheet Action control this, but action not auto, need user click and show it.
when user A login need click and show A data, user B login need click and show B data,
now, user want to not click firstly and just base on user id show that data, means not need link button, just base on different user id auto show that data.
Have you considered using the USERNAME() function in Tableau? It gets the current username, and you could insert that into your Google Sheets url (if the usernames are the same between Tableau Server and Google Sheets):