How to trigger a Google Apps Script once an email get in the inbox?

by

After some research and some help from other google-apps-script developers, the best solution is to use a combination of Gmail filtering system in addition to a time-driven-trigger.

So basically for a normal Gmail account there is a 1 hour/day computing time as mentioned in the documentation.

So what I did is set up a filter that adds a Label and a star to the incoming emails that need to be processed.

In my script I add the Labels in an array, I loop over the array of labels so that I process only the desired emails and not the whole inbox.

Once processed, the script removes the star from the processed email.

This way you don’t lose your precious compute time, and you don’t reach the daily limit.

I then set a time driven trigger that runs every 10 minutes.

You can also set up the time driven trigger to send you a daily “Summary of failures ” so that you can see what went wrong with your script and fix what has to be fixed.

More Related Contents:

  1. Moving google apps script to v8 file upload stopped working from sidebar
  2. Google Spreadsheet SCRIPT Check if edited cell is in a specific range
  3. No permission to call msgBox in Google Apps Scripting
  4. Custom functions intermittently hang with “Error – Loading Data”
  5. How to define global variable in Google Apps Script
  6. Periodically refresh IMPORTXML() spreadsheet function
  7. Export (or print) with a google script new version of google spreadsheets to pdf file, using pdf options
  8. Transfer ownership of a file to another user in Google Apps Script
  9. Format a Google Sheets cell in plaintext via Apps Script
  10. UiApp has been deprecated. Please use HtmlService instead
  11. How to get form values in the submit event handler?
  12. Dynamically edit multiple choice options in live Google Form using Apps Script
  13. Google app scripts: email a spreadsheet as excel
  14. Is there a way to keep two sheets synchronized?
  15. Selecting the last value of a column
  16. Run javascript as the form is being filled by users
  17. A Script to Simplify Creating a SO Table
  18. How to use the Gmail API, OAuth2 for Apps Script, and Domain-Wide Delegation to set email signatures for users in a G Suite domain
  19. How to get filtered values from Filter after using setColumnFilterCriteria?
  20. GAS “On edit” trigger not running when edited from API
  21. Difference between getValue() and getDisplayValue() on google app script
  22. How to allow onEdit function to affect protected cell in a Google Sheet?
  23. Call a function from external URL
  24. Custom Functions with add-ons?
  25. How to prefill Google form checkboxes?
  26. MailApp.sendEmail() in Google Apps Script not sending email
  27. Shuffle answer properties
  28. Stopping the error “Authorisation is required to perform that action” in Google Apps Script
  29. We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED
  30. e.range.getA1Notation() unable to track changes caused by formula update

Leave a Comment