Gmail delegated controlling
27 views
Skip to first unread message
Martin Ján Mašľan
Oct 17, 2025, 5:34:08 AMOct 17
to Google Apps Script Community
Hi,
I am an analyst, recently a dev too and I am looking for an optimal way in workspace(not necessarily) to go through gmail inboxes of 6 employees and check whether they replied to offer alerts coming from certain email senders(listing websites) in 24 hours period, if not, I create an entry in spreadsheet. This process is to be automized, launching the script every morning. I have already done the script, but have some uncertainties and cant seem to find something related anywhere.
Initially I used Apps script with jsut Gmail API, my understanding is i cant reach their inboxes with just Gmail API, even though i have delegation rights, so I created a DWD service account in GCP, and the code runs through service account right now.
I would like to know if I used correct/ideal/optimal dev tools, but mostly if there is someone experienced with business mail controlling automatization, also curious how did that someone set up their timers and what methods they used writing their code, assuring that the response will be matched to initial mail with correct timer, since i feel like my code logic is bit fragile.
I am an analyst, recently a dev too and I am looking for an optimal way in workspace(not necessarily) to go through gmail inboxes of 6 employees and check whether they replied to offer alerts coming from certain email senders(listing websites) in 24 hours period, if not, I create an entry in spreadsheet. This process is to be automized, launching the script every morning. I have already done the script, but have some uncertainties and cant seem to find something related anywhere.
Initially I used Apps script with jsut Gmail API, my understanding is i cant reach their inboxes with just Gmail API, even though i have delegation rights, so I created a DWD service account in GCP, and the code runs through service account right now.
I would like to know if I used correct/ideal/optimal dev tools, but mostly if there is someone experienced with business mail controlling automatization, also curious how did that someone set up their timers and what methods they used writing their code, assuring that the response will be matched to initial mail with correct timer, since i feel like my code logic is bit fragile.
SMAARTE Group
Oct 17, 2025, 9:59:52 AMOct 17
to google-apps-sc...@googlegroups.com
You can get whatever you want from every inbox, calendar, contacts, etc. in Google workspace so long as you have a service user, domain-wide delegation, disable a couple protections in GCP and link a project with the correct API settings to your Google Apps Script. I have a script that does serves up email statistics and another that deletes email from a temp account.
Please let me know if you have any questions.
Regards,
Steve Horvath
SMAARTE Group
Sent from Mobile Phone
Steve Horvath
SMAARTE Group
Sent from Mobile Phone
--
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 visit https://groups.google.com/d/msgid/google-apps-script-community/1edc85fb-d86b-47a5-915e-6b0e2db50152n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages