How are your users logging in ?
You can use a gviz query, or the Spreadsheet component, or a google apps script for the second part of your question.
Here is a CRUD example for google apps script:
and