Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] group membership .. input from google spreadsheet

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] group membership .. input from google spreadsheet

Chronological Thread 
  • From: Gail H Lift <>
  • To: "Black, Carey M." <>
  • Cc: Steven Carmody <>,
  • Subject: RE: [grouper-users] group membership .. input from google spreadsheet
  • Date: Thu, 11 Jan 2018 09:24:17 -0500
  • Ironport-phdr: 9a23:lwx4KRwmHj7V4SHXCy+O+j09IxM/srCxBDY+r6Qd2+sQIJqq85mqBkHD//Il1AaPAd2Craocw8Pt8InYEVQa5piAtH1QOLdtbDQizfssogo7HcSeAlf6JvO5JwYzHcBFSUM3tyrjaRsdF8nxfUDdrWOv5jAOBBr/KRB1JuPoEYLOksi7ze+/94HObwlSmDaxfa55IQmrownWqsQYm5ZpJLwryhvOrHtIeuBWyn1tKFmOgRvy5dq+8YB6/ShItP0v68BPUaPhf6QlVrNYFygpM3o05MLwqxbOSxaE62YGXWUXlhpIBBXF7A3/U5zsvCb2qvZx1S+HNsDtU7s6RSqt4LtqSB/wiScIKTg58H3MisdtiK5XuQ+tqwBjz4LRZoyeKfhwcb7Hfd4CR2VBUMZfWSJCDI2hcYUAE/EMMvxEo4TnvVYCsQeyCAuqCejyyjFInHj23agi3uogCw7G3QggFM8Mvn/Jqtv1NakSUfyox6TPwjXDb/dW1Czg6IjNcxAuvfGMUahufsXM1EkiDgXIhUiep4ziOjOazOUNs26D4upvUuKvjGEnqwVvrTS12sgsjYzJi4QIwV7H7SV02Jg5KsekREJnZNOoDZRduiGGO4ZzTc4uX31ktzo/x7IapZK2eC0HxZE5yxLBcPOKdZWD7Aj5W+aLOzh4gWpoeLKhiBa29kit0uj8WdO10FZOtyZEnNzMumwU2x3c9MSLVOBy8l2u2TaI0ADT5eVELl4umaXHLJ4hx6Y8lpsVsUvdAi/7gFv6g7WKekk4/+Wk9uvqb7X6qpKZOIJ4lh3yPbgrl8OjHeg1Ng0DUm2F9eiiz7Lv5Uj5T69Ljv0ynKnZqpfaJcEDq662Aw9V1p0u6wu6DzenzNsYnWMLI0xYdxKal4TpIU3BIOjkDfejhFShiDhrx+rBPr38GpXCMGLDnK78fbZm9UFc0hEzwMtb55JVEbEBPOnzVlHruNzZCB85LxK7w/zhCNpjyoMSR3iDDbGEP6PP4he04bdlCe2Fb4xR8B30MfU0r9uoxzdtk1sUdqrvhMFMQHejA7JrL1jPMlT2hdJUPm4LukIeBMjrhkHKBTFTY16vWqM35nc2BJ/wXtSLfZyknLHUhHTzJZZRfG0TTwnUSXo=

I have written Google sheets from a Linux server. If you want to try that route, let me know and I'll send sample code. 

On Jan 11, 2018 9:18 AM, "Black, Carey M." <> wrote:

I have not done this (yet) but have often wonder about such use of google spreadsheets.  ( Good luck, let us know if you get something working. And ideally... share the code. :) )

On the google spreadsheet API side...

I think v4 is the latest API version....
                or maybe

        There are Java sample code/library ( and other languages too) ).
        I don't see a "JSON output" format, but someone could walk the sheet and get the data then produce whatever JSON blob they wanted to from there. Likely there would need to be a transformation anyways, so there is some work to be done there.
        This idea feels "fragile" and easily broken by users mucking with the format/details of the sheet.

        If you really wanted to do something like this, I think there is a way to make a "form" that frontends the google sheet too. ( So you can control how the data gets into the sheet.)

I think I could even imagine a Loader Job ( Java code ) that could be scheduled to "pull" the data. ( If someone wanted to go that far with this idea.)


Carey Matthew

-----Original Message-----
From: [mailto:] On Behalf Of Hyzer, Chris
Sent: Thursday, January 11, 2018 8:38 AM
To: Steven Carmody <>; Grouper-Users <>
Subject: RE: [grouper-users] group membership .. input from google spreadsheet

Can you transform the csv to json and call addMember with "replace" and that will load into grouper?

-----Original Message-----
From: [mailto:] On Behalf Of Steven Carmody
Sent: Wednesday, January 10, 2018 11:36 AM
To: Grouper-Users <>
Subject: [grouper-users] group membership .. input from google spreadsheet


yes, I know, this is bad practice. But, I'm quite sure that Brown isn't the only campus where some depts are using spreadsheets as pseudo-databases.

Has anyone figured out a way to "regularly" provide the contents of a google spreadsheet to a process that would read and parse a CSV file and update a group's membership ?

Google Cloud Services supports cron in some form -- is there a way to export a spreadsheet to a CSV file and then mail the CSV file to a process ?

Is there a way from a linux machine to "mount" the google spreadsheet and issue commands to it ?

Is there some other way to move the contents from google to a linux machine ?

thanks for every suggestion, however crazy !

Archive powered by MHonArc 2.6.19.

Top of Page