The Group manager will accept text for group members. You just need to make sure that the variable you are using for a comparison contains the same text.
What variable where you using to compare to?
to store the email in a session at login, edit the Security Assist Authenticate user behavior on the login page.
On the session tab, click the plus button and select the email column form your users table.
use that session for the comparison in your rule.