Make a private feed link, paste the Sheets formula for a dataset into a cell, and build Looker Studio reports on a table that keeps itself up to date.
In the Tools group, click Data feed.
Type a name, such as Client dashboards, and press Make a feed link. The link is private to your account and read only. The formulas are shown only once, so copy what you need straight away. Each link in the list can be renamed or revoked.
Under Datasets, each one has a Sheets formula: Businesses, Performance by day, Map rankings, Reviews, Posts, Links and Tasks, each with its columns listed. Press Copy next to the one you want.
Open a sheet, click a cell and paste. The table fills in. Google refreshes an imported table on its own schedule, roughly every hour.
In Looker Studio, add the sheet as a data source and build your report. The Use it in Looker Studio section on the page walks through it.
Anyone holding a link can read that data, including anyone who can edit the sheet. Press revoke on the page to stop it and make a new one.