我有以下脚本对我有用。/p>
function onFormSubmit() {
var sheet = SpreadsheetApp.openById("17KZXpWHipISZSqgD9w255VrirzITrks0fLaBpXp7Ybk")
var email = sheet.getRange("B"+sheet.getLastRow()).getValue()
var name = sheet.getRange("C"+sheet.getLastRow()).getValue()
var user = sheet.getRange("AH"+sheet.getLastRow()).getValue()
try{
AdminDirectory.Groups.insert(
{
"email": email,
"name": name,
}
)
AdminDirectory.Members.insert(
{
"email": user,
"role": "OWNER",
}
, email)
GmailApp.sendEmail("Manager@test.co.uk",email + " Group creation | Success", " address has been created for " + name)
} catch(e){}
}
有人可以帮助我完成它,因为我无法工作的其余步骤是:
将小组调节设置设置为:跳过适度队列并将消息发布给组
将发布权限设置为:public
function onFormSubmit() {
var sheet = SpreadsheetApp.openById("17KZXpWHipISZSqgD9w255VrirzITrks0fLaBpXp7Ybk")
var email = sheet.getRange("B"+sheet.getLastRow()).getValue()
var name = sheet.getRange("C"+sheet.getLastRow()).getValue()
var user = sheet.getRange("AH"+sheet.getLastRow()).getValue()
try{
AdminDirectory.Groups.insert(
{
"email": email,
"name": name,
}
)
AdminDirectory.Members.insert(
{
"email": user,
"role": "OWNER",
}
)
AdminDirectory.Groups.update(
{
"whoCanJoin": "CAN_REQUEST_TO_JOIN",
"whoCanViewMembership": "ALL_IN_DOMAIN_CAN_VIEW",
"whoCanViewGroup": "ALL_IN_DOMAIN_CAN_VIEW",
"whoCanInvite": "ALL_MANAGERS_CAN_INVITE",
"allowExternalMembers": "false",
"whoCanPostMessage": "PUBLIC",
}
)
AdminDirectory.Groups.moderation(
{
"Spammessages": "Skip_the_moderation_queue_and_post_to_the_group"
}
, email)
GmailApp.sendEmail("r.hershey@onemotion.co.uk",email + " Group creation | Success", " address has been created for " + name)
} catch(e){}
}
我尝试过,但是我很累,要么我错过了一些愚蠢的东西...?
基于此文档,whoCanPostMessage
属性的可能值为:
-
ALL_IN_DOMAIN_CAN_POST
- 帐户中的任何人都可以发布消息。 -
ALL_MANAGERS_CAN_POST
- 包括小组所有者在内的经理可以发布消息。 -
ALL_MEMBERS_CAN_POST
- 任何组成员都可以发布消息。 -
ANYONE_CAN_POST
- 帐户外的任何Google Apps用户都可以访问您的Google组服务并发布消息。
提示:将whoCanPostMessage
设置为ANYONE_CAN_POST
时,我们建议将messageModerationLevel
设置为MODERATE_NON_MEMBERS
,以保护组免受可能的垃圾邮件。 -
NONE_CAN_POST
- 该组被禁用和存档。没有人可以向该组发布消息。- 当
archiveOnly value="false"
时,将whoCanPostMessage
属性更新为NONE_CAN_POST
,导致错误。 - 如果
archiveOnly
从"true"
恢复到"false"
,则whoCanPostMessages
属性设置为ALL_MANAGERS_CAN_POST
。
- 当
另外,我看不到有关AdminDirectory.Groups.moderation
和Spammessages
的任何参考。您可能需要检查给定的文档,看看messageModerationLevel
和spamModerationLevel
是否有帮助。