Utilizing Web Hooks to trigger automatic jobs

Unfortunately, the Web Hooks functionality is currently unavailable due to a bug in Google AppsScript. We will not be able to enable it until the following Google issue is fixed:

https://issuetracker.google.com/issues/150247026

Web Hooks provide the ability to run G-Connector operations on demand from anywhere: your custom Apps Script, your web site, your server, anywhere you can issue a POST request from.

You can now run these jobs at any time so the limit of being able to have only one scheduled run per document per hour is no more!

You will find the new Web Hooks function under the Admin Tools menu:

The function will let you generate a set of web links that you can use to trigger the corresponding G-Connector function in the Google Sheet you are generating it from:

Generate Links button will generate a separate link for every available function.
Revoke Links button will revoke links that have been previously generated.

To use any of the links, you will need to issue a POST request to that link, here’s an example of doing it from the command prompt:

curl -v -X POST “https://vt9wy02642.execute-api.us-west-2.amazonaws.com/prod/webhook?id=e2e335c2-592b-445c-93eb-4de1d6968927&action=pull”

Another useful example is calling a callback URL from Google Apps Script:

function MyFunction()
{
  var options = {
      'method' : 'post'
      };
  var result = UrlFetchApp.fetch('https://webhook_link', options);
  if (!result.success)
     Browser.msgBox(result.error);
}