r/GoogleAppsScript

I have a great order submission, database with daily email triggers. The functionality is on point, manager facing page all formulas working perfectly, database carrying over previous day data, clear the contents, recording into data base, updating date, and auto firing the email with the proper trigger setting. All Working perfect

Well working great for me the owner, but editors cannot get past the restricted access to run the script. The submit button is a drawing linked to an app script with error prompts to avoid duplicate submission etc.

I currently have a checkbox that bypasses the editor access and runs the script under the owners permission. Just to get by, but I hate it, the user are not tech savvy whatsoever, and the check box does not notify the user the script is running and will not produce any error messages, and look unprofessional

Please advise

The Gmail plug in allows event triggers on the Chatgpt webapp but not on the desktop app... I am trying to get the desktop app to be able to get notified for every incoming email from the plugin.

Has anyone found a way around this?

So what this does, it only touches two folders, the trash and spam.

It goes thru every spam email, checks email headers to indicate if the email is fishy, it also checks if each email from address is in your contacts, and also checks if each email has a label attached.

If the email headers indicate the email itself is very fishy, highly likely spam, and its not in your contacts and its not labelled in any way than it gets permanently deleted.

If an email is from someone in your contacts list or has a label associated with it, then it gets moved to your Spam folder.

Any email in your Spam folder older than 7 days gets deleted.

Now this works for me, it may not work for you.

There may be better ideas for strategies, and I am open to hearing from anyone who has a better or different idea.