Get started
Your own data

Google Sheets and MedAppz

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.

LiveEverywhere MedAppz is offered
What it does

What happens through Google Sheets

  • 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

  1. Step 1Create a Google service account and download its JSON key.
  2. Step 2Paste the key in API Keys, under Google Sheets & Drive.
  3. Step 3Share the sheet with the service account’s email address.
  4. Step 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.
In the store

The apps that use Google Sheets

Each carries its status from the catalog.

Your Own Database · live in clinics
Questions

Asked about this connection

Does MedAppz connect to Google Sheets?
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.
Related

Read next