Trigger actions with appscript in google sheets

[dpavlov]

I have a Google sheet that where I input data from emails with appscript. I have made an appsheet app using this Google sheet and have added the appsheet addon and enabled it. However when a new row is added by the appscript this is not recognyzes as an event and doesn't trigger a bot in the appsheet app.

Any idea how this can be solved?

[WillowMobileSys]

Currently, the only way automation is triggered upon addition of data in the sheet is when a user enters data directly to the sheet OR that data is inserted from a Google Form.

However, you should be able to call the AppSheet API from your appscript.  See article below to get started.  There are also some posts that show example script code.   Alternatively, I know that Integromat has AppSheet integration.  In Integromat, you can add your data to a Google sheet and then directly activate a Bot within the app.

API Article

https://help.appsheet.com/en/articles/1979966-api-the-essentials