Skip to content

[upstream-adapt] Write rich hyperlinks into Sheets cells #179

Closed

Description

@itsjeremyjohnson

Outcome

Users can set single-cell and batch hyperlinks (including multi-link rich text where the API allows) without manual CellData construction.

Why

High-frequency content op; upstream sheets links set.

Context

  • Source: upstream feature review of openclaw/gogcli (2026-08-11)
  • Intake rule: adapt the outcome in our architecture — do not cherry-pick or copy upstream implementation
  • Suggested triage priority: P1
  • Area: Sheets

Non-goals for this issue

  • No prescribed flags, package layout, or upstream file ports
  • No requirement to match upstream UX naming
  • Implementation design happens during triage / agent brief

Acceptance (triage will refine)

  • Desired user/agent-visible outcome is clear and still wanted
  • Not already fully covered by current main
  • Scope is bounded enough for an agent brief (or split)
  • Priority confirmed or re-bucketed

Activity

  1. added
    enhancementNew feature or request
    needs-triageMaintainer needs to evaluate this issue
    upstream-adaptFeature adapted from upstream openclaw/gogcli (rebuild our way)
    on Aug 11, 2026
  2. itsjeremyjohnson commented on Aug 12, 2026

    @itsjeremyjohnson
    CollaboratorAuthor

    This was generated by AI during triage.

    Agent Brief

    Category: enhancement
    Summary: Write single and multiple rich-text hyperlinks into Sheets cells

    Current behavior:
    Sheets value updates can write text or formulas, and formatting can style ranges. There is no first-class way to attach a hyperlink to all or part of a cell's displayed text without constructing raw cell data.

    Desired behavior:
    Allow a caller to set one hyperlink for a cell or multiple non-overlapping hyperlinks over substrings of a cell's text. Batch input should support multiple cells. Text ranges must be validated against the final cell text using Sheets' indexing semantics, and unrelated formatting should be preserved where possible.

    Key interfaces:

    • Rich-text cell input — represent cell text and hyperlink spans with URL and start/end positions
    • Sheets cell-data mutation — update the user-entered value and link text runs coherently
    • Batch result — correlate each requested cell with success or validation/API failure

    Acceptance criteria:

    • A single-link write produces a cell whose displayed text links to the requested URL
    • Multiple non-overlapping link spans in one cell retain their distinct destinations
    • Batch mode applies links to multiple cells and preserves request/result correlation
    • Overlapping, out-of-range, or invalid spans fail before mutation
    • Unicode text uses the provider's documented index units without splitting characters incorrectly
    • Runtime read-only mode blocks writes, and JSON/plain receipts are stable

    Out of scope:

    • Fetching or validating remote URL content
    • General rich-text styling beyond what is required to preserve hyperlink runs
    • Automatically converting plain URLs already present in cells
  3. added
    ready-for-agentFully specified and ready for an agent
    and removed
    needs-triageMaintainer needs to evaluate this issue
    on Aug 12, 2026
  4. itsjeremyjohnson commented on Oct 12, 2026

    @itsjeremyjohnson
    CollaboratorAuthor

    Closing as obsolete (GitHub sweep 2026-10-12). This [upstream-adapt] request asked to port an upstream steipete/gogcli CLI feature into our gog CLI. That CLI was retired in 91336b7 (#269); main builds only gog-mcp, so the command surface this request targets no longer exists. gog-mcp's pinned API catalog (internal/googlecatalog/manifest.json) already exposes the underlying Google method(s) (sheets.spreadsheets.batchUpdate / values.update) through --discovery=compact --api-catalog, subject to grants. New needs on the MCP side are filed as MCP-scoped issues (see #271, #273, #274, #278).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requestready-for-agentFully specified and ready for an agentupstream-adaptFeature adapted from upstream openclaw/gogcli (rebuild our way)

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions