ServerObserver allows you to monitor the status of a remote database on Postgres within Google Sheets in real time.
Pre-create a table and remember its id.
Example: docs.google.com/spreadsheets/d/1qJodoeJxOdVFUy8SqGApvgtAKygl2Ww4XHKMslQqO1M - id in bold.
Go to link and enable api on your account.
After setup is complete, a .json file will be downloaded with your account data.
Rename this file to credits.json
and put it in Test/Test .
In this file copy the mail (the field client_email) and give the rights to edit the table for this mail.
In the app.config
configuration file must be entered in the section Servers
data about servers, where key
- server address, value
- server size in GB.
user
, password
- PostgreSQL account data.
delaySeconds
- time between updates in seconds.
sheetId
- id of the table, which we remembered at the beginning.