将电子邮件地址添加到电子表格,将电子邮件自动添加到Google群组 [英] Add emailadress to Spreadsheet, auto add the email to a Google group
问题描述
我有一个Google表单是用户写给她/他的电子邮件地址。当他们这样做时,我希望它自动将电子邮件地址/用户添加到Google群组。
我试着用Apps Script来做这件事,但我没有得到任何好运。
$ b $ pre $
function addUserToGroup()
{
var emailadd = SpreadsheetApp.getActiveSheet()。getRange(B2 :B99\" );
var group = GroupsManager.getGroup(grouptest@mydomain.com)。addMember(emailAdd);
我想我可能会在我的脚本中丢失某些东西,但我不知道它是什么。
我是域管理配置API已启用。
像这样尝试,我分两步完成这个过程,一个是获取电子邮件(测试),另一个是添加用户到组中。
function test(){
pre>
var emailadd = SpreadsheetApp.getActiveSheet()。getRange ( B2:B99)的GetValues();
var usersToAdd = [];
for(var n = 0; nif(emailadd [n] [0]!=''){
usersToAdd.push(emailadd [N] [0]);
Logger.log(usersToAdd)
var group = GroupsManager.getGroup('testgroup@domain.com');
addMembers(group,usersToAdd);
函数addMembers(group,usersToAdd){
for(r = 0; r< usersToAdd.length; ++ r){
try {
var memberId = UserManager.getUser(usersToAdd [r] .substring(0,usersToAdd [r] .indexOf('@')))。getUserLoginId();
Logger.log('added'+ memberId);
group.addMember(memberId)
catch(error){Logger.log(error)}
}
}
I have a Google Forms were the user writes her/his emailadress. When they do so, i would like it to auto add the emailadress/user to a Google Group.
I tried to do this with Apps Script, but i do not get any luck with it.
function addUserToGroup() { var emailadd = SpreadsheetApp.getActiveSheet().getRange("B2:B99"); var group = GroupsManager.getGroup("grouptest@mydomain.com").addMember(emailAdd); }
I think i might be missing something in my script, but i don't know what it is.
I am domain admin Provisioning API is enabled.
解决方案Try it like this, I separated the process in 2 steps, one for getting the emails (test) and the other to add the users to the group.
function test(){ var emailadd = SpreadsheetApp.getActiveSheet().getRange("B2:B99").getValues(); var usersToAdd = []; for(var n=0 ; n<emailadd.length ; ++n){ if(emailadd[n][0]!=''){ usersToAdd.push(emailadd[n][0]); } } Logger.log(usersToAdd) var group = GroupsManager.getGroup('testgroup@domain.com'); addMembers(group,usersToAdd); } function addMembers(group,usersToAdd){ for(r=0;r<usersToAdd.length;++r){ try{ var memberId = UserManager.getUser(usersToAdd[r].substring(0,usersToAdd[r].indexOf('@'))).getUserLoginId(); Logger.log('added '+memberId); group.addMember(memberId) }catch(error){Logger.log(error)} } }
这篇关于将电子邮件地址添加到电子表格,将电子邮件自动添加到Google群组的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!