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.