Yes this is certainly doable, it would require some custom API integration unless you can find a plugin that can handle this (not aware of one). You would need Admin access to the workspace to setup everything correctly, it is not a simple job, but it is doable.
How may users are you looking at and how many emails approx?
You could also use the Zapier plugin (or similar automation platform) and go via their platform, this would be a bit clunkier, but easier to setup to prove the concept.
Also, there may be data security concerns to evaluate.