Notifications from Appsheet Events

[Andrew3]

Hi everyone.
I’m trying to get push notifications when a new entry is added on Google Sheet. I’ve followed the steps of turning on Appsheet Events Add-on from my Google Sheet, and then adding a Bot that run the task when an event is made. Everything seems fine, but still cannot get notifications. The test shows everything correctly. Any idea of what can be? Cheers.

[John_Geffel]

I’m having the same issue and am awaiting a response from the Google help desk.

[Lucinda_Mason]

Is your app deployed?

[Andrew3]

Yes it’s deployed. Seems to be that Google Sheets does not recognise an external entry. My data is added into Google Sheet from an external software. If I add manually it’s all fine. If the entry comes automatically from an external software, Google Sheet does not detect it as an entry. Not sure what I can do about this?

[Steve]

Andrew3:

Seems to be that Google Sheets does not recognise an external entry. My data is added into Google Sheet from an external software. If I add manually it’s all fine. If the entry comes automatically from an external software, Google Sheet does not detect it as an entry.

I’m pretty sure the external-eventing add-on only detects changes made manually to the worksheet (i.e., by a person editing the spreadsheet); I believe it does not respond to changes made by other (non-AppSheet) automated processes.

@Dan_Bahir, can you confirm? And perhaps point to the help doc that clarifies this?

EDIT: My impression was correct:

AppSheet Events Add-On Enhancements AppSheet Automation

Currently bots in a given AppSheet app can trigger based on the following conditions: Manual data entry on a Sheet that is referenced as a table in that app (requires the events add-on as mentioned above) Data changes made in the same AppSheet App (eg: edit a record in the table connected to the Sheet) Invoke the AppSheet API - this can be done by invoking the API in the other AppSheet app using the webhook task or any other non-AppSheet app can also invoke the AppSheet API. Hope this helps. …

[Dan_Bahir]

Yes Steve, you are correct.

[Hocappsheet]