Skip to content

[upstream-adapt] Manage Sheets basic filters #177

Closed

Description

@itsjeremyjohnson

Outcome

Users can create and replace basic sheet filters without hand-writing raw API payloads.

Why

Common Sheets power operation missing as a first-class workflow.

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: Manage a sheet's basic filter without raw API payloads

    Current behavior:
    Sheets commands cover values, formatting, tabs, metadata, and data-filter API operations, but they do not expose the sheet-level basic filter object.

    Desired behavior:
    Users should be able to inspect the current basic filter, create or replace it for a grid range, and clear it. Filter criteria must support the provider's common hidden-value, condition, and sort specifications through validated structured input. Replacing a filter should be explicit and should not alter cell values.

    Key interfaces:

    • Sheet basic-filter model — expose range, per-column criteria, and sort specifications
    • Spreadsheet batch mutation — set or clear the basic filter as one coherent operation
    • Sheet/range resolution — identify the target grid sheet and validate column references

    Acceptance criteria:

    • Get returns the current basic filter or an explicit empty result
    • Set creates a basic filter with a range and validated column criteria
    • Setting when a filter exists replaces it predictably and reports that replacement
    • Clear removes only the basic filter and leaves values unchanged
    • Invalid ranges, columns, conditions, and sort orders fail before mutation
    • JSON/plain output is deterministic, and runtime read-only mode blocks set/clear

    Out of scope:

    • Filter views
    • Sorting or rewriting cell values outside the basic-filter definition
    • Conditional formatting
  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) 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