I think you are experiencing the following
One workaround is to delegate the responsibility to a 3rd party like Make/ Zapier another is to use the Call API column from Glide.
Alternatively, if it’s a small Userbase, you could fill in the roles manually.