How do I trigger an automation from a Google Sheet update?

[Gethin]

Hi There, I've seen lots of old posts on similar subject but none of the resolutions appear to be relevant to me.

I have a Google Form that stores its data in a Google Sheet. I want to create an automation so that when a new entry is submitted an email is sent. This initially appeared to be simple to do in App Sheet but it will not work for me.

I want the event to be from the Sheet, not the Form, because the sheet contains calculated data in additional columns which I need to include in the email. If I submit the data from the App Sheet app itself, then it works. But if the data is submitted from the form, the event is not getting generated.

I have seen mention in this forum of external event enabling in Google Sheets but cannot find anything in my Google Sheet that would relate to that.

What am I missing? How can I get an Automation to be triggered when a new row is added to a Google Sheet?

[Gethin · Accepted solution]

This article got me the info I needed: https://support.google.com/appsheet/answer/11520310

[Allanlin0129]

Thank you the information. 
I am designing the similar app as you, but I having trouble figuring out after the event being triggered, how do I get the updated data into the mail?