I am looking for a way to make a spreadsheet in Google Sheets for my stream team to easily be able to see who is live. I am trying to use ‘Get Streams’ in Google Sheets with conditional highlighting to show who is live but I’m not having much luck.
If anyone has done something similar and has any ideas I would love to hear.
We might be able to give more specific pointers if you share the relevant piece(s) of your attempt. On a higher level, it seems like you’d want to use UrlFetchApp.fetch and set the params.headers to contain the client-id. Then get streams and see which streams are included in the response and set the corresponding cells to indicate liveness.