Read · /read/google-docs · 0 credits

Read a public Google Doc or Sheet.

Put the docs.google.com link after getjson.de/. A Doc comes back as text, a Sheet as CSV. Add a schema and the rows come back as JSON.

01

The call

curl https://getjson.de/https://docs.google.com/document/d/195j9eDD3ccgjQRttHhJPymLJUCOUjs-jmwTrekvdjFE/edit
02

The answer

{
  "source": {
    "url": "https://docs.google.com/document/d/195j9eDD3ccgjQRttHhJPymLJUCOUjs-jmwTrekvdjFE/edit",
    "finalUrl": "https://docs.google.com/document/d/195j9eDD3ccgjQRttHhJPymLJUCOUjs-jmwTrekvdjFE/edit",
    "kind": "document",
    "platform": "google",
    "provider": "google-export",
    "fetchedAt": "2026-10-27T21:23:59.723Z",
    "cached": false
  },
  "content": {
    "title": "Docs API Quickstart",
    "author": null,
    "publishedDate": null,
    "language": null,
    "engagement": {},
    "hashtags": [],
    "mentions": [],
    "linkedContent": [],
    "truncated": false,
    "text": "Sample doc",
    "wordCount": 2
  },
  "meta": null,
  "wall": null,
  "result": null
}

Recorded from https://getjson.de on 2026-10-27 with no key. Long text is cut and ends in " …".

  • The provider is google-export: the public export of the document (text for a Doc and Slides, CSV for a Sheet). Add ?gid= to the Sheet link for one tab.
  • A document that is not shared with Anyone with the link comes back with the wall login.
  • The same read of a Sheet (https://getjson.de/https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit) gives the CSV in content.text.
03

With a schema

curl -G https://getjson.de/https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit --data-urlencode 'schema={"type":"object","properties":{"students":{"type":"array","items":{"type":"object","properties":{"name":{"type":"string"},"major":{"type":"string"}},"required":["name","major"]}}},"required":["students"]}'
{
  "result": {
    "students": [
      {
        "name": "Alexandra",
        "major": "English"
      },
      {
        "name": "Andrew",
        "major": "Math"
      },
      {
        "name": "Anna",
        "major": "English"
      }
    ]
  }
}

Recorded from https://getjson.de on 2026-10-27 with no key. Long text is cut and ends in " …". Only result is shown, with 3 of its 30 students. Without a key a network has 3 schema calls a day.

04

Over MCP

The MCP tool read needs no key. Connect, then call it:

claude mcp add --transport http getjson https://getjson.de/mcp
{
  "name": "read",
  "arguments": {
    "url": "https://docs.google.com/document/d/195j9eDD3ccgjQRttHhJPymLJUCOUjs-jmwTrekvdjFE/edit"
  }
}

The tool answers with the same envelope as text.