We currently have a spreadsheet with 20 tab with various company data on it. When various tabs are updated a macro is run and this takes a screenshot of each of the tabs and uploads them to a local webserver. There are 5 TV's in the office and they all show the same website which is basically the 20 tabs uploaded via the excel spreasheet on rotaing. We use google cast to send the website to the 5 TV's in the office. Each time a new set of tabs are uploaded, the previously upload files are deleted so there is only ever 20 pages to rotate throught.
We would like to develop a Google GSheet to replace the excel spreadsheet so multiple people can access and update the data in the GSheet and since its a gsheet, there should be no need run a macro to upload the new updated screens.
We have a standalone PC which sits on the network and this PC is only used to CAST the webpage from the local webserver. So this would be changed just to cast the gsheet locally rather than using a webserver.