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'])

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