How can I trigger a Google Spreadsheet when a JotFrom arrives?

What I want to do:

  1. Webform collects information and sends it to a Google spreadsheet. 

  2. When the form updates, it triggers a custom script that sends the data to an email address.  

I can do this using Google Forms, but when I use a Jot Form, the trigger is not pulled.  How can I set up a trigger in the spreadsheet that will be activated by the JotForm?

Hi,

I would suggest taking a look at the installable Google Apps triggers in Google Spreadsheet.

You can see more about this here:

https://developers.google.com/apps-script/guides/triggers/installable

and I believe that you should use them with onPOST. You can see more about that here:

https://developers.google.com/apps-script/guides/triggers/#getting_started

Do let us know how it goes and if you have any further questions.

Best Regards,
Ben