Here is an example using the method of a public published to web google sheet.
The sheet should only be for public data.
See this post on how to set that up.
A sheet can be shared with people/team who are the only ones who can edit it. Don via the normal google share options.
You can see the sheet used in the example below here but I have turned editing off for obvious reasons.
cabTest.hype.zip (937.2 KB)
This is a quickly put together as I should be in bed…