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: "Black, Carey M." <>
  • To: Steven Carmody <>, Grouper-Users <>
  • Subject: RE: [grouper-users] group membership .. input from google spreadsheet
  • Date: Thu, 11 Jan 2018 14:17:46 +0000
  • Accept-language: en-US
  • Authentication-results: spf=pass (sender IP is;; dkim=none (message not signed) header.d=none;; dmarc=pass action=none;
  • Ironport-phdr: 9a23:K7CMJRbRqW2oZYjBvdmlg+7/LSx+4OfEezUN459isYplN5qZpsy5Yx7h7PlgxGXEQZ/co6odzbaO6ua4ASQp2tWoiDg6aptCVhsI2409vjcLJ4q7M3D9N+PgdCcgHc5PBxdP9nC/NlVJSo6lPwWB6nK94iQPFRrhKAF7Ovr6GpLIj8Swyuu+54Dfbx9HiTahfL9+Ngm6oRnMvcQKnIVuLbo8xAHUqXVSYeRWwm1oJVOXnxni48q74YBu/SdNtf8/7sBMSar1cbg2QrxeFzQmLns65Nb3uhnZTAuA/WUTX2MLmRdVGQfF7RX6XpDssivms+d2xSeXMdHqQb0yRD+v9LlgRgP2hygbNj456GDXhdJ2jKJHuxKquhhzz5fJbI2JKPZye6XQds4YS2VcRMZcTyxPDJ2hYYsTAeQPPuhYoIv8p1QSohWxChKhBP/0xTJMmnP6wbE23uYnHArb3AIgBdUOsHHModn7KaoSVfq6w7XLzTnbcvhbxy3y6JLWfREhvPqCWqh8fcTMwkQoDAzFik+fppDmPz+Py+gBrWaW4vFnVeK0lm4rsR9+rSWyxso1jITCm4wbylfB9SpjwYY1I8W1SEF8Yd6jH5tQsz+VO5FqTcMlRmFlvjsxxL4euZOjYiQF0ogrywPaZvCaboSE/xfuVOieLDtkmH5ofby/iAi9/EWkz+DxU8u53EpIoyZdj9XBt38A2wbO5sSbSPZx5Fmt1DmN2gzJ9O1JLkQ5mbLVK5E/wbM8ip8evEHDEyDqhEr2gqqbelsr9+Wp9uvqZ7rrq5+eOoJ6jwzxLr8hldelDuk+LwMARXKU+f6m273m5UD5QKtFjvkxkqTBqJ7XOcMVqrK3DgNM3Igt7BiyAy6h0NsDg3YLNlVFeA+bj4fyPFHOPfb4Auqlj1S0ijdrwOzGMaP9DZXRL3jDl7Hhcax6605B1Aozyddf55VXCr0bPP3zXUrxuMTZDh8/LQO03/7qBMtn2Y8CRG6CB7KVPL7PvVKN6OIiLPWAaJMQtTbzNfco6PrjgHo8lFIfYaWk34MbaHWiEfRnJ0WZb2DsgtAEEWoSpQU+SPblh0GBUTJJenq+Qawx6yo8CIK9EIfPXJ6ij6Gc3CujBJ1ZenhGCkyQEXfvb4iEVO0MaCWPIs95jDMET6GtS5I61R6wrg/60KFqLu7V+i0DqZLjz8Z56/fSlRE06Tx7Ed6d02eTQGFogG8EXSE5071ioR819lDW6rR1nfFeXfda/fZOXhZyYYXAwvJ3Def5UxjEeduYYFy8RcqgRzw9U4R1i/AUZFtlFs/nswvOxTHiV7APkKGTCYZx77nRxWPZJsBhxmzA2bV7yVQqX50cG3ehg/s13QzaDI2N226Qjau7PYFalmaZ/mOKxmnI5RsDeAlrTOPIUW1JNRielsjw+k6XF+zmMr8gKAYUjJfacqY=
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99


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


Carey Matthew

-----Original Message-----

On Behalf Of Hyzer, Chris
Sent: Thursday, January 11, 2018 8:38 AM
To: Steven Carmody
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-----

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