Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Data Sync & ETL

Data Sync & ETL

List Discord Members with a Role into Google Sheets

When you run it, it pages through a Discord server and saves all members holding a chosen role into Google Sheets.

Import it free Sign in to open it

What it does

## Setup 1. Add your Google Sheets and Discord credentials. 2. Create a Google Sheets document that contains ID as a column. We're using this to remember which member we received last. 3. Edit the fields in the setup node Setup: Edit this to get started. *You can read up on how to get the Discord IDs via this link.* 4. Link to your Discord server in the Discord nodes 5. Activate the workflow 6. Call the production webhook URL in your browser

The steps

  1. When clicking "Test workflow"
  2. Delete ID
  3. SaveID
  4. Get ID
  5. Merge
  6. Check if we have more members left
  7. We're done
  8. Check if we have an ID
  9. Filter to only include members with role
  10. Get First 100 Members
  11. Get next 100 Members after last ID
  12. Setup: Edit this to get started
  13. Webhook
  14. Send Response

Similar automations

Security & ComplianceRestrict AI Agent Tools by User Role with Airtable23 stepsData Sync & ETLExport Discord Server Members to Google Sheets38 stepsAlerts & NotificationsCreate a Matrix Room and Invite Members8 stepsAlerts & NotificationsCreate a Matrix Room and Invite Members9 steps