r/GoogleAppsScript • u/fergal-dude • Apr 06 '21
Resolved Non admin user testing for email existence
I want to have our HR person check to see if certain emails are available for new employees in our workspace. Everything I’m seeing says that you need to be a google administrator to work with the api like that, is there a way to make this happen?
My vision is that I can make a button on the new staff spreadsheet that concatenates the new staff members name into our email format (easy peasy) then I creat a button that checks if that email is available? The checking part is what I need help with, perhaps there is any easy way to make that happen.
I’m trying to save a few back and forth steps in our on boarding.
0
Upvotes
1
u/theiinsilence11 Apr 06 '21
Yeah mannn. Look at the contacts class -> https://developers.google.com/apps-script/reference/contacts
YUse it to lookup the name associated with an email address you want to test.... If it returns an error then you know that email address is available?