AppSheet Events Add-on (Pabbly)

[AISt]

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

[Steve · Accepted solution]

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?

[Steve · Accepted solution]

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?

[Suvrutt_Gurjar · Accepted solution]

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

External eventing with Google Sheets - AppSheet Help

[AISt]

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

[AISt]

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 ?

[AISt]

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.