Use google sheets to see if channel is live

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.


1 Like

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.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.