Apologies if this is a common question, I am new to this platform. I would also need a way to add all previous members to this spreadsheet as well.
Edit: I am struggling to get Zapier to find the user the role was added to. I need it to, when a role is added to a user, for zapier to find the user, find their row in the document (and if that row does not exist i need it to make it) and then input/update their name and roles to that row.
I have the trigger set up so that when a role is added to someone their user ID is found, however it does not show any results.