Spreadsheet Import API

Use this surface for Google Sheets, CSV-style migration workbooks, patient rosters, payer cleanup sheets, and billing work queues.

Native Google Sheets

EMRDesk also has a direct Google Sheets connector in Settings > API: connect with Google OAuth, list spreadsheets, load tabs, preview an A1 range, then import rows into the reconciliation queue.

googleSheetsOAuthStart
googleSheetsOAuthCallback
googleSheetsListSpreadsheets
googleSheetsGetSpreadsheet
googleSheetsPreview
googleSheetsImport

Partner Endpoint

POST /receiveSpreadsheetImport

Scope

interop:ingest:spreadsheet

Example

{
  "payload": {
    "sourceSystemId": "google-sheets",
    "spreadsheetId": "1abc...",
    "sheetName": "Patient roster",
    "importJobId": "migration-2026-05",
    "headers": ["externalPatientId", "firstName", "lastName", "dob", "email"],
    "rows": [
      {
        "externalPatientId": "LEG-1001",
        "firstName": "Ari",
        "lastName": "Santos",
        "dob": "1984-01-20",
        "email": "ari@example.com"
      }
    ]
  }
}

Routing

Include patientId for direct routing. For migrations, omit patientId and let EMRDesk queue rows for duplicate review and patient matching.