Function validationSet

Returns {
    config: {
        description: "Add data validation rules including dropdowns, numeric constraints, text patterns, date ranges, custom formulas. Supports batch operations for efficiency. Use discriminated conditionType to specify rule type. Best for enforcing data integrity and providing user-friendly input controls.";
        inputSchema: ZodObject<
            {
                gid: ZodCoercedString<unknown>;
                id: ZodString;
                requests: ZodArray<
                    ZodObject<
                        {
                            inputMessage: ZodOptional<ZodString>;
                            range: ZodString;
                            rule: ZodDiscriminatedUnion<
                                [
                                    ZodObject<
                                        {
                                            conditionType: ...;
                                            showDropdown: ...;
                                            strict: ...;
                                            values: ...;
                                        },
                                        $strip,
                                    >,
                                    ZodObject<
                                        {
                                            conditionType: ...;
                                            showDropdown: ...;
                                            sourceRange: ...;
                                            strict: ...;
                                        },
                                        $strip,
                                    >,
                                    ZodObject<{ conditionType: ...; strict: ...; values: ... }, $strip>,
                                ],
                                "conditionType",
                            >;
                        },
                        $strip,
                    >,
                >;
            },
            $strip,
        >;
        outputSchema: ZodObject<
            {
                result: ZodDiscriminatedUnion<
                    [
                        ZodObject<
                            {
                                failedRanges: ZodOptional<ZodArray<ZodObject<(...), (...)>>>;
                                gid: ZodString;
                                id: ZodString;
                                sheetTitle: ZodString;
                                sheetUrl: ZodString;
                                successCount: ZodNumber;
                                type: ZodLiteral<"success">;
                            },
                            $strip,
                        >,
                        ZodObject<{}, $strip>,
                    ],
                    "type",
                >;
            },
            $strip,
        >;
    };
    handler: (
        __namedParameters: {
            gid: string;
            id: string;
            requests: {
                inputMessage?: string;
                range: string;
                rule?:
                    | {
                        conditionType: "ONE_OF_LIST";
                        showDropdown: boolean;
                        strict: boolean;
                        values: string[];
                    }
                    | {
                        conditionType: "ONE_OF_RANGE";
                        showDropdown: boolean;
                        sourceRange: string;
                        strict: boolean;
                    }
                    | {
                        conditionType: "NUMBER_GREATER"
                        | "NUMBER_LESS"
                        | "NUMBER_BETWEEN";
                        strict: boolean;
                        values: number[];
                    }
                    | {
                        conditionType: "TEXT_CONTAINS"
                        | "TEXT_IS_EMAIL"
                        | "TEXT_IS_URL";
                        strict: boolean;
                        values?: string[];
                    }
                    | {
                        conditionType: "DATE_AFTER"
                        | "DATE_BEFORE"
                        | "DATE_BETWEEN";
                        strict: boolean;
                        values: string[];
                    }
                    | { conditionType: "CUSTOM_FORMULA"; formula: string; strict: boolean };
            }[];
        },
        extra: EnrichedExtra,
    ) => Promise<{ [key: string]: unknown }>;
    name: string;
}