Run community outreach without manual exports. The flow pulls members from a Discord server, keeps only those with a chosen role, and returns a clean list you can act on. It suits teams that need to message role holders, verify access, or build segments for campaigns.

Behind the scenes, a webhook or a manual test starts the run. A setup step provides the Discord server ID, the target role ID, and a Google Sheets URL. The system reads the last processed member ID from the sheet, fetches the next 100 members from Discord, merges results, and filters by the role. It then responds with only matching members. A paging loop saves the last ID back to Google Sheets so the next run continues where it left off. This reduces rate issues and handles large communities in chunks.

You need a Google Sheet with a single column named ID and a Discord bot with the server members intent enabled. Expect faster segment building and fewer errors from copy and paste work. Use it to build DM lists, role audits, or targeted announcements. Swap the response step for your own action, like posting to a CRM or sending messages.

• Webhook entry to start runs from any app that can send an HTTP request
• Manual test trigger for safe dry runs before going live
• Google Sheets storage of the last processed member ID
• Discord fetch in batches of 100 members with after cursor
• Role based filter that returns only the members you need
• Loop control that saves progress and prevents repeated work
• Respond to Webhook node that returns the filtered list instantly

• Reduce manual member exports from hours to minutes
• Automate pagination so you can handle large servers without extra work
• Improve segment accuracy by removing copy and paste errors
• Resume from the last processed member to avoid duplicates
• Connect Discord and Google Sheets to keep a simple audit trail

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and Discord. See the Tools Required section above for links to create accounts with these services.
3. Create a Google Sheet with a single column named ID. Leave it empty at first. Copy the full spreadsheet URL.
4. In the n8n credentials manager, create a Google Sheets credential. If unsure, double click any Google Sheets node, choose Credential to connect with, click Create new credential, and follow the on screen steps.
5. Open each Google Sheets node and select your new credential. Paste the same Sheet URL in the document field so all three Sheets nodes point to the same file and tab.
6. Create a Discord bot in the Discord Developer Portal. Enable the Server Members Intent. Invite the bot to your server with permission to read members. Copy your server ID and the role ID you want to target.
7. In n8n, create the Discord credential for the Discord Bot API. If unsure, double click a Discord node, click Create new credential, and follow the on screen steps to add your bot token.
8. Open the node named Setup: Edit this to get started. Enter the Google Sheets URL, your Discord server ID, and the target role ID.
9. Click Activate to turn on the workflow. Copy the Production Webhook URL from the Webhook node panel and call it from your browser or any tool that can send HTTP requests.
10. Check the Run view. The Respond to Webhook output shows only members with the role. The Google Sheet should update with the last processed ID.
11. Troubleshoot: If no members return, confirm the role ID is correct, the bot has the server members intent, and the server ID matches. If Sheets nodes fail, ensure the file is shared with your Google account used in n8n.