Yes, Google sheets updates automatically. If you have a Google account, go to Sheets, then you can type in functions in the cells to get the share price of stocks, e.g.:
=GOOGLEFINANCE(“AAPL”, “price”) will give you the current price of Apple and updates every time you load the sheet.
More for long term portfolio tracking as opposed to live prices as not sure how frequently prices update, maybe every 15 mins. Let me know if any questions or send me a DM.