How to Automatically Add User Email to AppSheet When Manager Adds User Info to Google Sheets

[Islom]

Hello AppSheet Community,

I need help creating a function in AppSheet that will automatically add a user's email to the application when a manager adds the user's information to the AppSheet's Google Sheets database.

Specifically, I want to set up the following workflow:

1. A manager adds a new user's information (including their email address) to a specific sheet in the Google Sheets database linked to my AppSheet application.
2. Once the information is added, the user's email should automatically be added to the AppSheet application as an authorized user.

Additionally, the users' emails might not always belong to the same domain, such as @school.uz. In most cases, users' emails will be @gmail.com.

Is there any way to solve this with AppScript maybe?

Could you please guide me on how to achieve this?

Any help with the steps, formulas, or AppScript code needed would be greatly appreciated.