To get Google Groups User details

-
Google Groups is a service from Google that provides discussion groups for people sharing common interests. The Groups service also provides a gateway to Usenet newsgroups via a shared user interface.

Google Groups became operational in February 2001, following Google's acquisition of Deja's Usenet archive. Deja News had been operational since 1995.
Google Groups allows any user to freely conduct and access threaded discussions, via either a web interface or e-mail. There are at least two kinds of discussion group. The first kind are forums specific to Google Groups, which act more like mailing lists.The second kind are Usenet groups, accessible by NNTP, for which Google Groups acts as gateway and unofficial archive. The Google Groups archive of Usenet newsgroup postings dates back to 1981. Through the Google Groups user interface, users can read and post to Usenet groups.

In addition to accessing Google and Usenet groups, registered users can also set up mailing list archives for e-mail lists that are hosted elsewhere[1]


As G Suite user/Gmail User, it is not easy to find out all group details If you are as owner, member or manager and other details.
Below Script will help to get Current user group list (Owner, Manager or Member) email & other details.

  • Requirements:
    • G Suite/G Mail Account
    • Access to GroupsApp API 
    • Current user Group member view access*
    • Google apps script execution permission 
    • Make copy My Group Member List
  • Run Script
    • Make Google sheet copy
    • Copied sheet Open Script Editor from "Tools" Menu 
    • Run OnOpen() Function 
    • First time it will ask Authorization for yor G Suite/Gmail account sources
    • Allow access 
    • After Allowing access you will find new menu "My Groups" in Google Sheet  
    • Click on My Groups menu --> Click on "Get My Google Groups"  
    • Sheet will clear and append new  header
    • It will start appending Group email Id, your role and Group members email ids & Count.-- "Be careful when you ruing script every time it will clear data from current sheet"
Happy Coding...

Comments

Post a Comment

Popular posts from this blog

Google Apps Script Exception Handling

-
Image
Errors In Computer Programming There are three types of common errors in programming: Syntax Errors Runtime Errors Logical Errors i) Syntax Errors Syntax errors, also called parsing errors , occur at compile time in traditional programming languages and at interpret time in Google Apps Script. For example, the following line causes a syntax error because we used Variable name V caps. function errorTest(){ Var num1=100; } Try to Save ( Ctrl+S ) Error log:  Missing ; before statement. (line 47, file "RegEx") When a syntax error occurs in Google Apps Script, IDE don't allow to save the last changes. ii) Runtime Errors Runtime errors, also called exceptions , occur during execution (after compilation/interpretation). For example, the following line causes a runtime error because here the syntax is correct, but at runtime, it is trying to call a function that does not exist. function errorTest2(){ var test=method(); Logger.log(t
Read more

Google Apps Script Regular Expressions

-
Image
RegEx A regular expression, also called a regex , is a method for matching text with patterns. For example, a regular expression can describe the pattern of email addresses, URLs, telephone numbers, employee identification numbers, social security numbers, or credit card numbers. What Is a Regular Expression? A sequence of symbols and characters expressing a string or pattern to be searched for within a longer piece of text. When you search for data in a text, you can use this search pattern to describe what you are searching for. A regular expression can be a single character or a more complicated pattern. Regular expressions can be used to perform all types of text search and text replace operations. Ref Google: For additional instructions and guidelines, see also Guidelines for using regular expressions and RE2 Syntax . Syntax /pattern/modifiers; var patt = /googleAppsScript/i; / googleAppsScript /i  is a regular expression. googleAppsScript   is
Read more

Responsive Web Apps using Google Apps Script

-
Image
Hi Apps Script developer's, Google apps Script allows to develop Dynamic and Static Web applications like fetch data from Google Sheet and create dynamic cards, intelligent data entry form, Workflows, Help Desk, etc. When you create Web apps using Google Apps Script, it will  not be responsive . You can make applications responsive using third party framework like Bootstrap , Material design or other HTML responsive framework. In this post I am explaining how to create responsive(Using Bootstrap 4.0) Google Apps Script Web application from scratch *Required Basic HTML & responsive framework knowledge  Go to your Google Drive Open Google Apps Script Editor   Create new blank apps script Project & save it Add 3 more Html files Index.html, JavaScript.html & Stylesheet.html with given code For any Web application it requires 4 main components(I am explaining best practise here, you can add HTML, JS & Stylesheet in to two files if you want) For code files
Read more