Notifications from Appsheet Events

AppSheet AppSheet Q&A
1

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.

2

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

3

Is your app deployed?

4

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?

Hocappsheet 5


3X_0_8_083522e22647c9238172bdfbd88fe7459425c73c.jpeg

6

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](https://community.appsheet.com/t/appsheet-events-add-on-enhancements/50196/3) 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. …

7

Yes Steve, you are correct.