Home

Welcome to the SU Bill Manager's wiki!

If you are using this app to manage your bills then create a google sheet which would look similar to this dummy sheet, After that enter your credentials from the Settings -> Credentials.

How to get Google Client ID:

https://medium.com/@a.marenkov/how-to-get-credentials-for-google-sheets-456b7e88c430
It should look like this:

{
  "type": "service_account",
  "project_id": "",
  "private_key_id": "",
  "private_key": "",
  "client_email": "",
  "client_id": "",
  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
  "token_uri": "https://oauth2.googleapis.com/token",
  "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
  "client_x509_cert_url": ""
}

How to get Spreadsheet ID:

It can be found in the link to your spreadsheet - link looks like so https://docs.google.com/spreadsheets/d/YOUR_SPREADSHEET_ID/edit#gid=0
[YOUR_SPREADSHEET_ID] in the path is the id your need