@mcp-z/mcp-sheets
    Preparing search index...

    Function cellsMetadataGet

    • Returns {
          config: {
              annotations: { readOnlyHint: true };
              description: "Read notes, data validation rules, pivot table and data-source table definitions in required finite ranges on one sheet. Preserves sparse row/column offsets. Excludes cell values, formulas and direct formatting. DATA_SOURCE and OBJECT sheets are unsupported.";
              inputSchema: ZodObject<
                  {
                      gid: ZodPipe<
                          ZodUnion<readonly [ZodString, ZodNumber]>,
                          ZodTransform<string, string | number>,
                      >;
                      id: ZodString;
                      ranges: ZodArray<ZodString>;
                  },
                  $strict,
              >;
              outputSchema: ZodObject<
                  {
                      result: ZodDiscriminatedUnion<
                          [
                              ZodObject<
                                  {
                                      fieldMask: ZodString;
                                      gid: ZodString;
                                      id: ZodString;
                                      metadata: ZodObject<
                                          { sheets: ZodOptional<(...)>; spreadsheetId: ZodString },
                                          $loose,
                                      >;
                                      requestedRanges: ZodArray<ZodString>;
                                      type: ZodLiteral<"success">;
                                  },
                                  $strip,
                              >,
                              ZodObject<{}, $strip>,
                          ],
                          "type",
                      >;
                  },
                  $strip,
              >;
          };
          handler: (
              input: { gid: string; id: string; ranges: string[] },
              extra: EnrichedExtra,
          ) => Promise<{ [key: string]: unknown }>;
          name: string;
      }