onEdit and UrlFetchApp

[N A]

Hi guys,

I want to trigger UrlFetchApp.fetch(...) in order to ping my app every time there's an update in the Spreadsheet via onEdit(e) but unfortunately it doesn't allow me due to the restriction.

They cannot access services that require authorization. For example, a simple trigger cannot send an email because the Gmail service requires authorization, but a simple trigger can translate a phrase with the Language service, which is anonymous.

Do you have any other workarounds?

Thanks

[Goran Kukurin]

you cannot use the simple onEdit trigger for this, you must use the installable one https://developers.google.com/apps-script/guides/triggers/installable

[N A]

Yeah! You're right. That's what I did. I've used the TriggerBuilder:

ScriptApp.newTrigger(callback)

  .forSpreadsheet(SpreadsheetApp.getActive())

  .onEdit()

  .create();

Thanks

[Goran Kukurin]

Check the oauth scopes in appsscript.json. Also, you may need to check which user has created the trigger. 

Try to login with that user's account and run your onEdit method that calls UrlFetchApp.fetch. You may need to accept some permissions. After you accept them, the onEdit script will hopefully run.

[N A]

Yes, thank you! I've added the necessary authorization scopes in appsscript.json file.

{
  ...
  "addOns": {

    ...
    "common": {

      ...
      "homepageTrigger": {
        "runFunction": "onHomepage",
        "enabled": true
      }
    }
  },
  "oauthScopes": [

    ...

    "https://www.googleapis.com/auth/spreadsheets.currentonly",
    "https://www.googleapis.com/auth/script.external_request"
  ],
  "urlFetchWhitelist": [

      ...
  ]
}

References

https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app

https://developers.google.com/apps-script/reference/script/trigger-builder#forspreadsheetsheet

[N A]

However, is it possible to limit the onEdit listener (e.g., Sheet1) only trigger the listener when something has change on Sheet1. Otherwise, just ignore or won't trigger the onEdit.

[Goran Kukurin]

you cannot limit when the onEdit is triggered, but you can examine the onEdit event argument (range property) and determine if you want to take some action, or ignore it.

On Thu, Aug 4, 2022 at 3:44 AM N A <oo7...@gmail.com> wrote:

However, is it possible to limit the onEdit listener (e.g., Sheet1) only trigger the listener when something has change on Sheet1. Otherwise, just ignore or won't trigger the onEdit.

--
You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/CMwonPyUBT8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/655fdfb7-c498-4443-bd44-150c06ca22can%40googlegroups.com.

[CBMServices Web]

Goran is correct. Just add a filter at the top of the onEdit function to just return if it is not the correct sheet or correct range that you want. Check the lines of code below:

function onEdit(e) {

  const sheetName = e.range.getSheetName();

  if (sheetName != "Sheet1") {return;}

You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAAgLCKzBaxLomV1uJ3SWE9%3D7zYD0JEbDQ_cHf-arhLfASEnTFA%40mail.gmail.com.

[N A]

Thank you guys for your help. 👍