Here’s the scenario: you have a second gmail account that gets email infrequently, but you need to monitor it. Â For whatever reason (company policy, in my case), you can’t forward the email to your main account.
I discovered that I could log into the second Google account and attach a Google Apps Script to a spreadsheet. Â The script monitors the gmail account for unread threads. Â If it finds any, it sends a message to my main account. Â The script has a time-driven trigger that can be set to run as frequently or infrequently as desired.
To use the script, make a copy of this spreadsheet.Â Open the spreadsheet and edit the cells that contain the email message parameters. Â Then go to Tools – Script editor. Â Choose Resources – Current project’s triggers. Â Add a time-driven trigger that runs the script as often as you’d like.
I am not able to find the script. Can you please help me with it?
You can contact me on my email id:
I hope you see this – the comment system filtered out your email address.
I edited the post and put in a link to a read-only version of my spreadsheet that contains the apps script. Make a copy of the spreadsheet, and then you should be able to run it.