Hi! I think what you have described is possible to build although not easy. Make sure that your app follows Glide’s guidelines about private user’s information handling… User Data Rules and Restrictions | Glide
On the second note, the AI assistant (the way you want it to work) most likely will require Call API function which is on a Business plan, please, take that into consideration…
Check Loqode’s newest youtube video for the tutorial: Open AI in Glide or AI assistant in GPT account - #16 by Nataliya_Kovaleva