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

    Function valuesBatchUpdate

    • Returns {
          config: {
              description: "Batch update multiple cell ranges. RAW=exact values, USER_ENTERED=parsed like user input. Use a1-notation prompt for range syntax.";
              inputSchema: ZodObject<
                  {
                      gid: ZodCoercedString<unknown>;
                      id: ZodString;
                      includeData: ZodBoolean;
                      requests: ZodArray<
                          ZodObject<
                              {
                                  majorDimension: ZodEnum<{ COLUMNS: "COLUMNS"; ROWS: "ROWS" }>;
                                  range: ZodString;
                                  values: ZodArray<
                                      ZodArray<
                                          ZodUnion<readonly [(...), (...), (...), (...), (...), (...)]>,
                                      >,
                                  >;
                              },
                              $strip,
                          >,
                      >;
                      valueInputOption: ZodEnum<{ RAW: "RAW"; USER_ENTERED: "USER_ENTERED" }>;
                  },
                  $strip,
              >;
              outputSchema: ZodObject<
                  {
                      result: ZodDiscriminatedUnion<
                          [
                              ZodObject<
                                  {
                                      gid: ZodString;
                                      id: ZodString;
                                      sheetTitle: ZodString;
                                      sheetUrl: ZodString;
                                      spreadsheetTitle: ZodString;
                                      spreadsheetUrl: ZodString;
                                      totalUpdatedCells: ZodNumber;
                                      totalUpdatedColumns: ZodNumber;
                                      totalUpdatedRows: ZodNumber;
                                      type: ZodLiteral<"success">;
                                      updatedData: ZodOptional<ZodArray<ZodObject<(...), (...)>>>;
                                      updatedRanges: ZodArray<ZodString>;
                                  },
                                  $strip,
                              >,
                              ZodObject<{}, $strip>,
                          ],
                          "type",
                      >;
                  },
                  $strip,
              >;
          };
          handler: (
              __namedParameters: {
                  gid: string;
                  id: string;
                  includeData: boolean;
                  requests: {
                      majorDimension: "ROWS" | "COLUMNS";
                      range: string;
                      values: (string | number | boolean)[][];
                  }[];
                  valueInputOption: "RAW"
                  | "USER_ENTERED";
              },
              extra: EnrichedExtra,
          ) => Promise<{ [key: string]: unknown }>;
          name: string;
      }