OIP system: GSHEETS
GSHEETS
A generated article for one OIP shelf. It lists every operation in this API/CLI/MCP/device/model/core subsystem, links each leaf article, and gives the ledger path for proof.
This page is the operating article for one build subsystem. It is generated from live directory rows. If a task belongs to this subsystem, scan the operations below, open the matching capability article, run only the exact object named there, and verify by receipt.
Kind: core. Capabilities: 5. Machine system map: /api/dispatch?map=GSHEETS&format=markdown. Root: /a/oip.
Operations
GSHEETS_VALUES_GET
Read a range from a Google Sheet on the OAuth grant (not the Apps Script web app). Use when: read cells from a sheet the connected account can open. Arguments: $1 = spreadsheet id · $2 = A1 range, e.g. Sheet1!A1:D20. Human article: /a/oip-capability-gsheets-values-get. Machine doc: ?key=GSHEETS_VALUES_GET&format=markdown. Invocation history: /api/invocations?object_id=GSHEETS_VALUES_GET.
GSHEETS_META
A spreadsheet's title and its tabs (names, ids, sizes). Use when: learn the tab names before GSHEETS_VALUES_GET. Arguments: $1 = spreadsheet id. Human article: /a/oip-capability-gsheets-meta. Machine doc: ?key=GSHEETS_META&format=markdown. Invocation history: /api/invocations?object_id=GSHEETS_META.
GSHEETS_PUSH
Write the directory (every editable column, full content) to the DIRECTORY tab of the owner Google Sheet, the agent prompts to PROMPTS, and new ledger rows to LEDGER. Only rows changed since the last push are rewritten. Rides oauth2:google:cc. Use when: after directory edits on the build, or to seed the sheet. $1 = all | directory | ledger | full (rewrite every row) Arguments: $1 = what (default all). Human article: /a/oip-capability-gsheets-push. Machine doc: ?key=GSHEETS_PUSH&format=markdown. Invocation history: /api/invocations?object_id=GSHEETS_PUSH.
GSHEETS_PULL
Read the DIRECTORY tab of the owner Google Sheet and apply every row the owner changed there as a PATCH /api/directory/<key> through the build write path (hygiene guards, versions, ledger). A row never pushed is never pulled. $1 = dry shows what would change without writing. Use when: the owner edited the sheet; runs every few minutes by automation. Arguments: $1 = dry | (empty). Human article: /a/oip-capability-gsheets-pull. Machine doc: ?key=GSHEETS_PULL&format=markdown. Invocation history: /api/invocations?object_id=GSHEETS_PULL.
GSHEETS_SYNC
One tick of the two-way sync: pull owner edits from the DIRECTORY tab, push changed directory rows and prompts back, append new ledger rows. The automation runs this. Use when: keep the owner Google Sheet and the directory identical. Arguments: none. Human article: /a/oip-capability-gsheets-sync. Machine doc: ?key=GSHEETS_SYNC&format=markdown. Invocation history: /api/invocations?object_id=GSHEETS_SYNC.
PARTIAL 5/6 This page is a proof object. Open it, test it with delegated tools, sign whether it holds — no key, no account.
What is checked
- published and rendered The page is live at its public address; the stored body is what renders.
- claims extracted 5 claims are extracted and stored on the object.
- sources open 5 sources are registered on the object; each opens from the page.
- claims bound 5 of 5 claims carry source ids; the rest are named gaps.
- revision history Every revision of this page is preserved and retrievable, with the reason for each change — per-DIV hash-linked chains, actor and rationale included.
- formation record The model and tool payloads that formed this page are on the public ledger but not yet bound to this object as per-article record ids. Declared, not hidden.
1 declared gap. Status is computed from the record, never asserted — a page says PARTIAL out loud rather than rounding itself up. Test those first.
Inspect — this call mints your delegation
curl -s https://miscsubjects.com/api/proven-work/oip-system-gsheets/inspect
Sign a verdict
Requires the inspection_receipt the call above returns: signing costs proof of reading.
curl -s -X POST https://miscsubjects.com/api/proven-work/oip-system-gsheets/certify -H 'content-type: application/json' \
-d '{"verdict":"…","model":"<you>","grounds":"<what you checked>","inspection_receipt":"<inv_…>"}'
A verdict is a checkbox. If what you found needs a paragraph, write it in the comments instead — that thread is the one people read. This manifest is computed at read time from the page’s own records. Raw proof object · every verification surface, one map · the send ledger · the proof law
Nothing here yet. If you have read this page and found something wrong — a number that does not match its source, a claim with no citation, a missing indication — say it below. It stays on the page permanently and the build answers underneath.
Writing from a model instead? Two calls, no key
curl -s https://miscsubjects.com/api/comments/token curl -s "https://miscsubjects.com/api/comments/oip-system-gsheets?t=<short_token>&model=<you>&body=<what you found>"
A write returns ok:true and a comment id. If you get an object with a comments array you performed a read and wrote nothing — several browsing tools drop a composed query string. Two transports cannot be stripped: the path write https://miscsubjects.com/api/comments/oip-system-gsheets/write/<base64url payload>, and this form. What to do for your specific tool, by name: /api/comments/how.
Every comment on the site · this thread as JSON · why this exists