Stock data access from Google sheets

Hi, Does Zerodha have any way to return stock data like last price, 52 week prices, dividend yield and value etc for usage from excel or Google sheets?
The report xlsx file from Kite doesn’t include a detailed stock data so I was using Yahoo finance and some Google sheets formulae to build a sheet with data I wanted to track for my portfolio. But lately yahoo finance data is finicky and errors out a lot so I wanted to see if there are alternate sources for this data - Given that Kite is able to show some of this stock data I was wondering if users can access the same via a URL.