I am creating one Google Chat App for my organization which basically have 3 stack holders such as EMP (Employee), RM (Reporting Manager) and FM (Finance Manager).
In this app, EMP can create a leave request and app will store the entry of this on a Google Sheet with leave request status pending.
I have tried creating a trigger that always checks the google sheet for any pending entry and accordingly sends that entry request to the corresponding Reporting Manager on google chat app.
But trigger is getting trigged but I am not able to target specific person to send this notification.
Any idea how can I do it ?
I read almost all google chat docs, but not getting this specific solution.