I want to be able to extract some data that is in a slack private channel & then put it into a google sheet or excel what ever is achievable. I’m not a developer but I am the admin of Slack, when I follow the process I think maybe its only possible with a Enterprise Slack account? There are two ways to authenticate, API Access token & Oauth2. With the API method there are no scopes to read private channels only public. I believe the Oauth2 method is not compatible with Slack Tiggers. Any advice appreciated,
Hi @dino,
I think you are right. I’ve done research on that in the past and I reached the same conclusion.
Same for exporting the data manually or on schedule. this slack article states that you need business or enterprise for that:
Anyway exporting private communication poses a huge security and privacy risk so usually you shouldn’t want to do it unless you are ‘that’ kind of business
A good alternative is to make those channels public if the information in it is not that sensitive.
This was slacks response
"The search.messages API cannot search private channels by default. Private messages will only show up in search results for users who are part of the channel associated with the user token used.
The Discovery API, available only on enterprise plans, is the way to look into private conversations without already being a part of them, as it allows searching across all messages, including private channels. You can find more information about the Discovery API here: A guide to Slack's Discovery APIs | Slack"
I will see if we can convert the channels to public but i think they are private because they contain customer data.