Google Sheets

Lightweight, dependency-free in-memory fake of the Google Sheets API v4 for testing googleapis client code with zero cost and zero side effects.

Default port: 4613

Implemented Operations

Internal parlel Endpoints

Spreadsheets

Sheets

Values

values.update, values.append, values.batchUpdate, and values.batchUpdateByDataFilter require a valueInputOption (RAW or USER_ENTERED), exactly like the real API. A missing or unsupported value returns 400 INVALID_ARGUMENT. values.append returns tableRange as the detected table range before the append (an empty string when no table is found at the search range), matching spreadsheets.values.append. | sheets.spreadsheets.values.clear | POST /v4/spreadsheets/{spreadsheetId}/values/{range}:clear | | sheets.spreadsheets.values.batchGet | GET /v4/spreadsheets/{spreadsheetId}/values:batchGet | | sheets.spreadsheets.values.batchUpdate | POST /v4/spreadsheets/{spreadsheetId}/values:batchUpdate | | sheets.spreadsheets.values.batchClear | POST /v4/spreadsheets/{spreadsheetId}/values:batchClear | | sheets.spreadsheets.values.batchGetByDataFilter | POST /v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter | | sheets.spreadsheets.values.batchUpdateByDataFilter | POST /v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter | | sheets.spreadsheets.values.batchClearByDataFilter | POST /v4/spreadsheets/{spreadsheetId}/values:batchClearByDataFilter |

Developer Metadata

Supported spreadsheets.batchUpdate Request Types

addSheet, duplicateSheet, deleteSheet, updateSheetProperties, updateSpreadsheetProperties, updateCells, appendCells, repeatCell, copyPaste, setBasicFilter, clearBasicFilter, appendDimension, createDeveloperMetadata, updateDeveloperMetadata, and deleteDeveloperMetadata mutate in-memory state.

Formatting and UI-oriented request types such as autoResizeDimensions, mergeCells, unmergeCells, updateBorders, filter view requests, chart requests, protected range requests, slicer requests, and similar batch requests are accepted as no-ops and return an empty reply object. This keeps common application code compatible without modeling visual-only Sheets behavior.

Quick Start

Start the server from the repo:

import { GoogleSheetsServer } from "./apps/parlel-pool/services/google-sheets/src/server.js";

const server = new GoogleSheetsServer(4613);
await server.start();

Connect with the real googleapis client:

import { google } from "googleapis";

const sheets = google.sheets({
  version: "v4",
  auth: "test-token",
});

sheets.context._options.rootUrl = "http://127.0.0.1:4613/";

const created = await sheets.spreadsheets.create({
  requestBody: { properties: { title: "Local test" } },
});

await sheets.spreadsheets.values.update({
  spreadsheetId: created.data.spreadsheetId,
  range: "Sheet1!A1:B1",
  valueInputOption: "RAW",
  requestBody: { values: [["hello", "parlel"]] },
});

Reset state between tests:

curl -X POST http://127.0.0.1:4613/_parlel/reset

Surface Coverage

Legend: ✅ supported · ◐ accepted-not-enforced · ✓ by design · ⟳ roadmap.

Error Codes & Shapes

Errors use the Google Sheets API v4 envelope — the shared google.rpc.Status shape with a details array, exactly like sheets.googleapis.com returns. The emulator does not emit the legacy JSON-API error.errors[] array (the real v4 API does not return it either):

{
  "error": {
    "code": 404,
    "message": "Requested entity was not found.",
    "status": "NOT_FOUND",
    "details": [
      {
        "@type": "type.googleapis.com/google.rpc.ErrorInfo",
        "reason": "notFound",
        "domain": "googleapis.com",
        "metadata": { "service": "sheets.googleapis.com" }
      }
    ]
  }
}

The googleapis Node client surfaces error.code, error.message, and error.status, all of which match the real API.

Common returned codes:

Configuration — test.env

Copy these into your test.env (used by the bridge sidecar flow). Tokens are Parlel's seeded test credentials — any non-empty value is accepted by the emulator, so you rarely need to change them. Swap in real credentials only when pointing at the live service in prod.env.

GOOGLE_SHEETS_EMULATOR_HOST=http://parlel-bridge:4613
GOOGLE_CLOUD_PROJECT=parlel
GCLOUD_PROJECT=parlel