Help needed with Google Apps Script

[fiza]

I need to automate the addition of email addresses from a Google Sheet into a Google group.

I have found a script which is supposed to do this. It gets as far as picking up the first email address in cell B2 but then gives an error.

I should add that the Google Sheet is populated from a Google Form so I need the script to run each time the Google form is completed and the sheet gets updated.

I am hoping someone can help me with this, never messed with Apps Script before.

 

 

ReferenceError: GroupsManager is not defined

 

 

 

[color=#185ABC][font=&amp]function[/font][/color][color=#202124][font=&amp]test[/font][/color][color=#3C4043][font=&amp](){[/font][/color][color=#3C4043][font=&amp]  [color=#185abc]var[/color] [color=#202124]emailadd[/color] = [color=#c92786]SpreadsheetApp[/color].[color=#202124]getActiveSheet[/color]().[color=#202124]getRange[/color]([color=#b31412]"B2:B99"[/color]).[color=#202124]getValues[/color]();
 [color=#185abc]var[/color] [color=#202124]usersToAdd[/color] = [];
 [color=#185abc]for[/color]([color=#185abc]var[/color] [color=#202124]n[/color]=[color=#098591]0[/color] ; [color=#202124]n[/color]<[color=#202124]emailadd[/color].[color=#202124]length[/color] ; ++[color=#202124]n[/color]){
   [color=#185abc]if[/color]([color=#202124]emailadd[/color][[color=#202124]n[/color]][[color=#098591]0[/color]]!=[color=#b31412]''[/color]){
     [color=#202124]usersToAdd[/color].[color=#202124]push[/color]([color=#202124]emailadd[/color][[color=#202124]n[/color]][[color=#098591]0[/color]]);
   }
 }
 [color=#c92786]Logger[/color].[color=#202124]log[/color]([color=#202124]usersToAdd[/color])
 [color=#185abc]var[/color] [color=#202124]group[/color] =[color=#c92786]GroupsManager[/color].[color=#202124]getGroup[/color] ([color=#b31412]"[i][email protected][/i]"[/color]);
 [color=#202124]addMembers[/color]([color=#202124]group[/color],[color=#202124]usersToAdd[/color]);
}

[color=#185abc]function[/color] [color=#202124]addMembers[/color]([color=#202124]group[/color],[color=#202124]usersToAdd[/color]){
 [color=#185abc]for[/color]([color=#202124]r[/color]=[color=#098591]0[/color];[color=#202124]r[/color]<[color=#202124]usersToAdd[/color].[color=#202124]length[/color];++[color=#202124]r[/color]){
   [color=#185abc]try[/color]{
     [color=#185abc]var[/color] [color=#202124]memberId[/color] = [color=#c92786]UserManager[/color].[color=#202124]getUser[/color]([color=#202124]usersToAdd[/color][[color=#202124]r[/color]].[color=#202124]substring[/color]([color=#098591]0[/color],[color=#202124]usersToAdd[/color][[color=#202124]r[/color]].[color=#202124]indexOf[/color]([color=#b31412]'@'[/color]))).[color=#202124]getUserLoginId[/color]();
     [color=#c92786]Logger[/color].[color=#202124]log[/color]([color=#b31412]'added '[/color]+[color=#202124]memberId[/color]);
     [color=#202124]group[/color].[color=#202124]addMember[/color]([color=#202124]memberId[/color])
   }[color=#185abc]catch[/color]([color=#202124]error[/color]){[color=#c92786]Logger[/color].[color=#202124]log[/color]([color=#202124]error[/color])}
 }
[/font][/color]
[color=#3C4043][font=&amp]}[/font][/color]

Edited February 26, 2023 by fiza

[Steve21]

Looks like you're using an ancient script

 

We're eager to maintain that momentum — focusing on new features that help you do more with Google Apps. As a result, we're deprecating two Apps Script services for which good replacements exist elsewhere: ScriptDB (a NoSQL database that has been marked as experimental since it was introduced) and the Domain service (which encapsulates the GroupsManager, NicknameManager, and UserManager global objects).

 

Both ScriptDB and the Domain service will be turned off on November 20, 2014.

 

Looks like the Admin SDK has been the replacement since 2015 https://developers-google-com.translate.goog/apps-script/migration/domain?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-US&_x_tr_pto=wapp

 

Steve

[fiza]

Hahaha - I said I wasnt good with Scripts! Google foo let me down.