Hello ScienceMan, Your question is very generalized. It is also not clear. Please lay down clearly what do you want to do with the Groups API.
Do you want: 1) To retrieve members of each group and add them to a spreadsheet. Or 2) Given members in the spreadsheet, add members to the given group. (Sophisticated) In case of member deletion from the spreadsheet, remove the member from the group as well. You can use the Spreadsheets API<http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html> to read or update the data in spreadsheet. -- For the first case, retrieve members from a group using the retrieveAllMembers method of the Groups Provisioning API<http://code.google.com/googleapps/domain/provisioning_API_v2_developers_guide.html#Retrieve_Member_Example> and populate the spreadsheet using the Spreadsheets API. -- For the second case, read the spreadsheet and add each user account to the given group using addMemberToGroup method in the* *Groups Provisioning API<http://code.google.com/googleapps/domain/provisioning_API_v2_developers_guide.html#Retrieve_Member_Example> . In case you do not need GAE app specifically, it is easier to work on spreadsheets with AppsScript. AppsScript<http://code.google.com/googleapps/appsscript/guide.html>also gives the capability of event handling, such as trigger the script for any edit in the spreadsheet. It would be better to help you, if you can break down the problem and specify what you want to do. Thanks, Shraddha Gupta Developer Programs Engineer Hyderabad, Google India. On Sat, Dec 31, 2011 at 11:19 PM, ScienceMan <[email protected]>wrote: > I have a large number of related (preferably hierarchical) groups to > provision for our Google Apps domain, and the new Groups API seems a > good way to go about this. > > Ideally I'd like to write a small GAE application driven by a Google > spreadsheet or script that could run in the context of a private > Google Apps site driven by a list that would populate members of each > group, the rest of the parameters of which I would control through the > API by pre-setting them in the GAE app or site script. > > Taking the Sites script as an example, one can imagine having a list > in a web page for a site to which we control access that is driven by > using a page of "list" type. The entries on the list might be > > Unit Manager Assistant Webmaster > > (Our list of columns would be different but I give this as an > example.) Each Unit would have an associated list, of which each of > the people listed (using their Google Apps accounts in our domain) > would be members. Additionally, each unit would have a web site in > our domain, but one step at a time -- I would be happy with simply > having the ability to populate the list (either as rows in a > spreadsheet or lines in the list-type web page) and push a button to > create the list with the indicated people as members. An option at > some future point would be to clear the contents of the group and > replace them with any updated entries, or (even more sophisticated) > update in place by being able to remove people not in the current list > and add new ones. > > The idea is to be able to handle multiple such groups at one time in a > simple combined interface. > > Any ideas how to go about the above, either with a stand-aline app, a > GAE app or a Sites script running off of a list-type page in a Google > Apps site? Samples or starting points (or better yet, a full > solution) would be appreciated! > > -- > You received this message because you are subscribed to the Google Groups > "Google Apps Domain Information and Management APIs" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-apps-mgmt-apis?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google Apps Domain Information and Management APIs" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-apps-mgmt-apis?hl=en.
