How to trigger action in one table based on the external changes in another table's google sheet

[ashishmasih]

Hi,

I have two tables one is the table of Offers second is the table for offer Acceptance, both the tables are referenced to each other and have “Offer number” as key value, I want to get the status from Acceptance table to Offers table and when this change happens I Want to trigger an email using bot automation flow. the change on which I want to trigger action will be done externally in the google sheet not through.

Please suggest some way out…