How can I track new users in a Discord server with Google Sheets?
Hi all! I’m trying to do what is says on the title:
New user joins the Discord server
New row is added to the sheet
The row contains the user’s username, ID (prefaced by an @ character), joined at {date}
It passes the tests, but somehow it’s not tracking EVERY user that joins the server. I wanna do this so at the start of every week I can post a message that says “this week X amount of users joined. They are @user 1, @user 2, etc”
Page 1 / 1
Hi @usiriczman
Good question.
Zaps work while turned ON for new data going forward.
All the Discord Zap triggers are scheduled meaning it can take from 1-15 minutes for those to fire depending on your Zapier plan.
Thanks Troy! That’s helpful. I had the zap on for a couple of weeks at least. But it only parsed one user every couple of days for some reason. That’s the last record, and I turned the zap off just now to make this post.
While the Members tab in the discord server shows that we had some people join just a couple of hours ago
Do you think there’s a way to fix this? Am I doing something wrong here? Thank you!
@usiriczman
It could potentially be a bug with the Zap trigger on the backend.
It could be an issue on the Discord side with making that data available.
That’s fair, I don’t have a paid plan right now but maybe it’s worth investing in one just to fix this. Thanks for the answers!
Hi there @usiriczman,
I’m jumping in to see if I can help!
I understand from the previous messages that the Zap is missing some new users, even though there have been multiple new users in the past few hours. I would like to mention that in some cases when the number of users in Discord is large (typically over 1000), there might be issues with the “New User” trigger.
This is because the Discord application has to scan through all the users to identify the new ones, and with a large number of users, the process might not be completed accurately every time, leading to missed triggers.
Could you please let me know the total number of users in your Discord server?
Yeah, this seems to be the case. My discord server has over 7000 members.
Do you think there’s any way to fix this? I’ve tried leaving the zap on and it gets around 10% of total users and thet’s it.
Thank you!
Hi @usiriczman,
I did some digging into this, and it seems that the trouble stems from certain API parameter limitations. I understand this can be quite a hassle, especially as it makes the New User Added trigger less helpful for larger servers - and unfortunately, in your situation, it renders this Zap fairly unusable. This is actually a common hiccup associated with the Find User action, and because the New User Added trigger uses the same style of GET request, it's likely to be a stumbling block for you.
I've added your vote to the open feature request for functionality for servers over 1000 users. That does a few things.
Bring this to the attention of the integration developers
Help track interest in this feature being implemented
Allows us to notify you via email if this feature becomes available in the future
While I don't have an ETA on when this feature might be implemented, we will notify you via email if it is!
I'm really sorry for the inconvenience, and we appreciate your understanding.