How to call a local script from a Google Apps Script Trigger?

Question

I have a Google form. When submitted, the responses go to a Google sheet. I currently have a python script that polls the Google sheet looking for new submissions and doing whatever it has to do when it finds a new submission. Instead of constantly polling the sheet, I would like to call my script after a trigger like onSubmit(). Since the Google apps scripts runs on Google's servers, is there anyway to do this given my script is on my local machine?

I'm looking for something like

function onSubmit(e) {
  runMyScript("/path/to/script.py")
};

I'm not really good at API request but gess you could run your google script via an API request in the on submit trigger and execute your local script in the google script. perhaps you could try that. — JSmith

Vytautas Vytautas · Accepted Answer · 2018-09-11T04:41:31

If you are running a Google script from the spreadsheet then there is no way for you to call a local script on your computer. You would have to do an HTTP or HTTPS request to your script which would have to be accessible from an external network

How to call a local script from a Google Apps Script Trigger?

1 Answers