AppSheet Event Add On Help

[djnguyen]

Hello!

I am trying to use the Google Sheets AppSheet Event Add On to trigger an email to be sent out when a new row is added outside of AppSheets and I am having some difficulties.

I've created a linking from Qualtrics to send survey response data to a Google Sheet and when a new survey response is added, I'd like AppSheet to note that a new row has been added and send an email out (via an AppSheet Bot).

I've added the AppSheet Event Add On and it still does not work. The Email Bot only works when I go into my Google Sheet and manually copy/paste a record that Qualtrics sent over.

[TeeSee1]

Unfortunately...

I believe you need to create a time driven trigger, detect changes in your Apps Script, use Appsheet API to make a change that triggers a bot to send email. (you could send email directly in your Apps Script if that meets your requirement)