Get All Discord Members with Specific Role (Paginated)

This n8n workflow retrieves every member of a Discord server (guild) who possesses a designated role, addressing Discord API constraints that limit responses to 100 users per request. It employs Google Sheets as a persistent state manager to record the ID of the last processed member, enabling batched retrievals until all qualifying members are obtained.

The workflow begins with a trigger (manual for testing or webhook for production), reads the last member ID from Google Sheets, queries the Discord API for subsequent members after that ID, filters them by the specified role, collects the results, and updates the sheet with the new last ID. This loop continues automatically until no more members are found, ensuring complete data extraction without manual intervention.

Setup is straightforward: add Discord and Google Sheets credentials, create a sheet with an 'ID' column, configure server/guild ID and role ID in the setup node, link the Discord server, activate the workflow, and trigger the production webhook. Requires admin rights on the server and n8n version 1.28.0+.

Ideal for use cases like bulk direct messaging role-assigned members, regular user growth analytics, role distribution analysis, onboarding new members to databases, or integrating Discord data into CRM systems. Benefits include time savings on manual exports, scalable automation for large servers (thousands of members), and reliable handling of API pagination quirks.

Keywords: Discord API, get all members, Google Sheets pagination, Discord roles, server member export.