I use to have an app, which will auto sending notifications and emails whenever a new record is added to my Google Sheet.
The new record is added from Google Form, and the Google Sheet is installed with AppSheet Event, whenever a new data is submitted from Google Form, it will auto trigger the bot.
The existing AppSheet Event is required to enter the API key, but I found that, the new version of AppSheet Event doesn’t required the API key from AppSheet. But the bot is not working, below as my setting:
In Google Sheet, Appsheet event is installed, and I have turned on the AppSheet event for the selected Sheet.
In AppSheet, a bot is added to handle data changed - ADDs only for the same Sheet.
Any setting I have missing?