Export users (first name, last name, email address) from a given Slack channel

export-users-from-slack-channel.py

import requests

SLACK_API_TOKEN = "xoxo-asdfghjkl..." # get one from https://api.slack.com/docs/oauth-test-tokens
CHANNEL_NAME = "general"

channel_list = requests.get('https://slack.com/api/channels.list?token=%s' % SLACK_API_TOKEN).json()['channels']
channel = filter(lambda c: c['name'] == CHANNEL_NAME, channel_list)[0]

channel_info = requests.get('https://slack.com/api/channels.info?token=%s&channel=%s' % (SLACK_API_TOKEN, channel['id'])).json()['channel']
members = channel_info['members']

users_list = requests.get('https://slack.com/api/users.list?token=%s' % SLACK_API_TOKEN).json()['members']
users = filter(lambda u: u['id'] in members, users_list)

for user in users:
    first_name, last_name = '', ''
    
    if user['real_name']:
        first_name = user['real_name']

        if ' ' in user['real_name']:
            first_name, last_name = user['real_name'].split()
    print "%s,%s,%s" % (first_name, last_name, user['profile']['email'])

How exactly do I use this script?

Hi there,

I updated your code and made it a bit more user friendly. Check it out here: https://github.com/nickcanfield29/Download-Slack-Channel-Users/blob/master/Get_Slack_Channel_Users.py

Hey Nick,

This works well, but it seems to be having issues seeing private channels even though I'm a member. Any ideas on why that would be. I have the groups:read scope.

Hey Bahoo, Glad you're able to use it! Unfortunately, this script only grabs public channel users. To grab private ones, I'd need to update it. Let me see if I can figure that out...

…

On Mon, May 18, 2020, 12:45 PM tissue1231 ***@***.***> wrote: ***@***.**** commented on this gist. ------------------------------ Hey Nick, This works well, but it seems to be having issues seeing private channels even though I'm a member. Any ideas on why that would be. I have the groups:read scope. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <https://gist.github.com/59d81fc0f916d18658b1915ab615e116#gistcomment-3308292>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AG5VVY7FU3PGQAPBEBFVKF3RSDDOZANCNFSM4LZ7BHEA> .

I mean, *@tissue1231. *Bahoo was a weird username from the email. Weird, I know.. On Mon, May 18, 2020, 2:11 PM Nick Canfield <[email protected]> wrote:

…

Hey Bahoo, Glad you're able to use it! Unfortunately, this script only grabs public channel users. To grab private ones, I'd need to update it. Let me see if I can figure that out... On Mon, May 18, 2020, 12:45 PM tissue1231 ***@***.***> wrote: > ***@***.**** commented on this gist. > ------------------------------ > > Hey Nick, > > This works well, but it seems to be having issues seeing private channels > even though I'm a member. Any ideas on why that would be. I have the > groups:read scope. > > — > You are receiving this because you commented. > Reply to this email directly, view it on GitHub > <https://gist.github.com/59d81fc0f916d18658b1915ab615e116#gistcomment-3308292>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AG5VVY7FU3PGQAPBEBFVKF3RSDDOZANCNFSM4LZ7BHEA> > . >

Hey @nickcanfield29,

Thanks for the quick update on this. I tested it on both private and public and the export is showing up blank for both now.

Send me your terminal output (minus the API key of course) to let me see what went wrong

…

On Thu, May 21, 2020, 3:06 AM tissue1231 ***@***.***> wrote: ***@***.**** commented on this gist. ------------------------------ Hey @nickcanfield29 <https://github.com/nickcanfield29>, Thanks for the quick update on this. I tested it on both private and public and the export is showing up blank for both now. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <https://gist.github.com/59d81fc0f916d18658b1915ab615e116#gistcomment-3311879>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AG5VVY2TNBUOHQ5QAIC6C7DRSQZ47ANCNFSM4LZ7BHEA> .

In case you are looking for a no-code solution, you can use Channel Tools app for Slack. Amongst other things, it can help you export a list of users in a Slack channel.

Hey Nick,

This works well, but it seems to be having issues seeing private channels even though I'm a member. Any ideas on why that would be. I have the groups:read scope.

I just drag and copied in the windows app. worked pretty gud