So i hope the question is to automatically update daily data in the looker studio chart from the google sheet. To update the daily data , you can set a trigger in google sheets so that the data gets updated daily.