Your Own Database can append your records to a Google Sheet you already share with your accountant. It works today with your own Google service account and needs nothing from MedAppz.
Appends a row for each event, with the event id in the first column.
Gives each stream, such as billing or bookings, its own cursor.
Asks for a recorded acknowledgement before a stream that carries patient data.
Marks the connection failed and holds its place if Google refuses the key, then carries on once it is fixed.
Switching it on
What it takes
1Step 1Create a Google service account and download its JSON key.
2Step 2Paste the key in API Keys, under Google Sheets & Drive.
3Step 3Share the sheet with the service account’s email address.
4Step 4Add a Google Sheets connection in Your Own Database and pick the streams.
What it does not do yet
Sheets has no way to update a row in place, so a redelivered event is written again. The event id in the first column lets you spot the duplicate and remove it.
Yes. It works on medappz.com today. Your Own Database can append your records to a Google Sheet you already share with your accountant. It works today with your own Google service account and needs nothing from MedAppz.
How do I switch on Google Sheets?
Create a Google service account and download its JSON key. Paste the key in API Keys, under Google Sheets & Drive. Share the sheet with the service account’s email address. Add a Google Sheets connection in Your Own Database and pick the streams.
What does the Google Sheets connection not do yet?
Sheets has no way to update a row in place, so a redelivered event is written again. The event id in the first column lets you spot the duplicate and remove it.