Hi @radhkan ,
I would recommend checking out this past demo: Getting Started with Agentic AI: Quick Automate - Learn / Videos - Amazon Quick Community
It is not the exact scenario that you have described but I think it will get you most of the way there. Check it out and let me know if you have any more questions!