将电子表格的电子邮件添加到Google组（常规Gmail帐户）
我基本上是从Google表单中收集回复，并将其放入Google电子表格中。它具有时间戳，名称和电子邮件列。我想将所有这些电子邮件（它们都是Google帐户电子邮件）添加到我的Google组中（我是所有者，请注意我有一个普通的Gmail帐户）。人们不能直接加入我的小组，他们只能参加邀请。
我想编写一个Google App脚本代码，以将成员从电子表格中添加到我的Google组中。使用普通的Gmail帐户是强制性的。
我试图使用Google App脚本的Admin SDK目录API进行操作，但它不起作用。我认为，这仅适用于Google Workspace帐户。
任何帮助将不胜感激
I basically collect responses from a Google Form and put them into a Google Spreadsheet . It has timestamp , name and email column . I would like to add all these emails(they all are google account emails) into my Google Group(where I am the owner, note that I have a normal Gmail account). People cannot directly join my group , they can only join on invite .
I want to write a Google App Script code for adding members into my Google Group from the Spreadsheet. It is compulsory to use a normal Gmail account.
I tried to do it with the Admin SDK directory API for Google App Script , but it was not working. As I think , it is only for Google Workspace accounts.
Any help will be appreciated
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
Admin SDK Directory API如有记录为在这里不包含终点以完成此操作。使用gmail.com帐户。另一方面，高级管理员SDK目录服务具有终点，并描述了在这里，但是如页面顶部所述，需要Google Workspace帐户/域：
考虑到上述内容，可以证实，截至此响应之日起，不可能使用Google Apps脚本将成员添加到Google组，而Gmail.com帐户是不可能的。
作为选项，您可能需要提交功能请求在这里
Admin SDK Directory API as documented here does not contain an endpoint to have this done using a Gmail.com account. On the other hand, the Advanced Admin SDK Directory Service has an endpoint to do it and is described here but as mentioned at the top of the page a Google Workspace account/domain is required:
Taking the above into consideration it can be confirmed that as of the date of this response adding members to a Google Group using Google Apps Script and a Gmail.com account is NOT possible.
As an option, you may want to submit a Feature Request here