AppSheet Events Add-on (Pabbly)

AppSheet AppSheet Q&A
1

Hi all,

I built an application base on AppSheet and the data tables are in Google Sheet.

In Google Sheet I have AppSheet Events Add-on enabled on a particular table.

Then used Pabbly (Third party) to insert a transaction in the table.

After this I use automation to detect changes on the table and perform action.

The result is if I add a transaction via the application or in the Google Sheet directly, the bot triggered perfectly. But the transaction added via pabbly was un-detected, no action was triggered.

Is there any one can tell me why ???

Many thanks

2

The AppShee Events Ad-on runs in the Google Sheets application. When Pabbly does its thing, it’s probably using the Sheets API, which is not the Sheets application. Perhaps you can tell Pabbly to do its thing using the AppSheet API rather than or in addition to manipulating the sheet directly?

2 Likes
3

To add to Steve’s guidance, the help article clearly mentions the following about external eventing.

Suvrutt_Gurjar_0-1738766624443.png
Suvrutt_Gurjar_0-1738766624443.png1102×138 14.1 KB

External eventing with Google Sheets - AppSheet Help

2 Likes
4

Hi Suvrutt, Steve

Very much appreciated for your prompt reply.

It seems Suvrutt statement is correct, data from programatic dose not trigger the table changes.

My second question is how income SMS from Twilio can be processed immediately when received in Appsheet ? any suggestion ?

1 Like
5

Thanks guys for your reply, It seems all programmatic input is not detected which including Google script.

1 Like
6

I also use Surutt’s idea of having Pabbly to update the value via API when message received from Twilio.

Once again much appreciated for all your effort.