I have two apps that need to "communicate" with each other. Both edit the same spreadsheet, but only one adds new rows, the other only updates a particular column of existing rows. I need a bot/automation to be triggered in the "update"-only app when the other app adds a new row. Currently, the automation won't fire because the other app is adding the rows, it is not happening "natively" within the app. How can I trigger this bot from rows added by the other app? Surely this is possible. Thanks!
User | Count |
---|---|
15 | |
10 | |
10 | |
8 | |
3 |