present_gsheet_planner

Open one saved Google Sheets inspection in the gsheet-planner app when a visual view is requested or materially useful. Use view=‘metadata’ with gsheet_result_ref from get_google_spreadsheet_metadata, or view=‘ranges’ with gsheet_result_ref from read_google_sheet_ranges. The reference resolves to the exact server-owned metadata, selected ranges, formatting presets, and capture time; it does not reread the sheet. Provides view: gsheet-planner (ui://apps/gsheet-planner) renders this tool’s result when MCP Apps are available.

Parameters

Name	Type	Required	Default	Description
view	GoogleSheetPlannerView	Yes	—
result_ref	str	Yes	—

Returns

Returns a structured object. Top-level fields:

• view (string)
• freshness (object)
• data (object)

See the response example below for the full payload shape.

Example

Tool Call

{
  "name": "present_gsheet_planner",
  "arguments": {
    "view": "ranges",
    "result_ref": "A1b2C3d4E5f6G7h8I9j0K1l2M3n4O5p6Q7r8S9t0U1v"
  }
}

Response

{
  "view": "ranges",
  "freshness": {
    "captured_at": "2026-04-28T10:00:00+00:00",
    "expires_at": "2026-04-28T10:05:00+00:00",
    "checked_at": "2026-04-28T10:00:04+00:00",
    "age_seconds": 4,
    "model_name": "forecasts",
    "spreadsheet_id": "1aBcDeFgHiJkLmNoPqRsTuVwXyZ0123456789ABCDEFG",
    "presentation_truncated": false
  },
  "data": {
    "spreadsheet_id": "1aBcDeFgHiJkLmNoPqRsTuVwXyZ0123456789ABCDEFG",
    "ranges": [
      {
        "range": "Forecast!A1:C4",
        "values": [
          [
            "Month",
            "Revenue"
          ],
          [
            "Jan",
            120
          ]
        ]
      }
    ]
  }
}

Notes

• Module: Google Sheets
• Requires an authenticated Bridge Town session (OAuth) or an API token.