How to Trigger Notifications on Google Sheets back end row add

AppSheet AppSheet Q&A
1

I would like to trigger a notification when my Sheets data source has a new row added.

The AppSheet does not create this row, and neither does the Google Sheet. The row is added by a Wix Form automation.

2

Since Appsheet is not involved in this row addition, I believe you will need to use external services.

Within Google workspace, you could use email based notification using Google Apps script.

To send mobile notifications or SMS you may need to use some other external applications.

3

I want to use the in-app notification since there will be lots of them. The user will be in the app and not switching to emails.

4

There is no way for AppSheet itself to notice and respond to a change made to the spreadsheet by an external process, such as by a Wix Form automation. Consider instead adapting the Wix Form automation to use the AppSheet API to notify your app of the change.

5

I started going down that road. I tried using the API to update a table within AppSheet but ran into the same issue. Since the app didn’t update the table, the bot doesn’t see it.

Is there an AppSheet API to trigger an in-app notification?

6

To clarify, I’m suggesting that the process you have in Wix Form should use the AppSheet API; no bot in AppSheet is needed for this.

7

Understood. I did try this too. The API update also did not cause a notification

8

You may want to take a look at the following great tip and extension developed by senior AppSheet community member @Rifad

9

@Suvrutt_Gurjar thanks for the mention