I have enabled App Sheets Events To GSheet Name Feedback and Ratings. (Response sheet of a Google Form). This particular sheet has been added as a table to the app (Named as Feedback).
2nd Table named as Orders was already created.
An Action was created which sets row values to Order tables by using select (Feedback([Ratings], [Order ID] = [_ this row].[Order id]).
I have created a event for the order table and linked it to the bot.
Whenever customer submits response (external event), this bot should be triggered and run and sets the values to order table. But this is not happening.
Will the bot be triggered by the Google sheet's Events if the data changes occurs in Feedback sheet ?And run an action to set values to another table order?
I have checked Automation Manager there was no such events present.
LinkedIn
Twitter
