Could someone tell me a way to make a Slack channel list on spread sheet like google or excel that automatically updates every minutes or so?
In detail, I want to have a spread sheet where there is a list of every channel from my Slack (the number of channel are frequently changing as we create channel for each project we get for our work and delete on that is no longer in use).
Please let me know if you have a solution and if I was not clear enough, do ask me!
From API perspective, you can use https://api.slack.com/methods/conversations.list
This API when used with proper scopes will give you the details of all the channels belonging to a given Team/Workspace.
You can now code as per your skill set to make a call to this API periodically.