I’m hoping I can get some advice. I want a bot to run in my app when data is changed in my Google Sheet externally (not changed from within the app).
My understanding is that I need the Appsheet Events Addon. So I have installed the addon in my development environment and it worked, so I decided I’d try it in a second app. This time the bot didn’t trigger, but it did trigger if I made the change within the app itself (so the bot was working correctly).
So I decided to remove the addon and then re-install it. Now it works in my second app, but not my first.
So I guess my question is, how reliable is the Events Addon? Do other people have issues with it? Is there any way of knowing that it is working in any particular Google Sheet? Are there additional troubleshooting or investigations I can do?
My bots all work fine and behave as intended when the data is changed from within the apps themself, just not when changes are made directly to the sheet manually in one app.
I have read that an ‘add row’ made by a Google Form will trigger a bot (External eventing with Google Sheets | AppSheet Help Center), but then I also read in another support forum post that it does NOT work with Google Forms. I haven’t tried it yet from a Google Form, but that is my intended external data change, so I’d be keen to know definitively if it is designed to work when a Google Form adds a row.
If the Events addon is problematic, Is there an alternative method for detecting a change? I could run a daily bot to do my automation, but the bot is intended to email the person who used the Google Form a response with a code that they can use straight away.
Any suggestions or advice would be much appreciated.