Function columnsUpdate

Returns {
    config: {
        description: "Update spreadsheet data by column headers with intelligent upsert logic. Supports adding missing columns, flexible update behaviors, and robust error handling. Uses column names as keys for matching existing rows, enabling context-aware data synchronization workflows.";
        inputSchema: ZodObject<
            {
                behavior: ZodDefault<
                    ZodEnum<
                        {
                            "add-only": "add-only";
                            "add-or-update": "add-or-update";
                            "update-only": "update-only";
                        },
                    >,
                >;
                gid: ZodCoercedString<unknown>;
                headers: ZodArray<ZodString>;
                id: ZodString;
                rows: ZodArray<
                    ZodArray<
                        ZodUnion<
                            readonly [
                                ZodString,
                                ZodNumber,
                                ZodLiteral<number>,
                                ZodLiteral<number>,
                                ZodBoolean,
                                ZodNull,
                            ],
                        >,
                    >,
                >;
                updateBy: ZodArray<ZodString>;
                valueInputOption: ZodDefault<
                    ZodEnum<{ RAW: "RAW"; USER_ENTERED: "USER_ENTERED" }>,
                >;
            },
            $strip,
        >;
        outputSchema: ZodObject<
            {
                result: ZodDiscriminatedUnion<
                    [
                        ZodObject<
                            {
                                errors: ZodOptional<ZodArray<ZodString>>;
                                gid: ZodString;
                                headersAdded: ZodArray<ZodString>;
                                id: ZodString;
                                insertedKeys: ZodArray<ZodString>;
                                rowsSkipped: ZodNumber;
                                sheetTitle: ZodString;
                                sheetUrl: ZodString;
                                spreadsheetTitle: ZodString;
                                spreadsheetUrl: ZodString;
                                type: ZodLiteral<"success">;
                                updatedRows: ZodNumber;
                            },
                            $strip,
                        >,
                        ZodObject<{}, $strip>,
                    ],
                    "type",
                >;
            },
            $strip,
        >;
    };
    handler: (
        __namedParameters: {
            behavior: "add-or-update" | "update-only" | "add-only";
            gid: string;
            headers: string[];
            id: string;
            rows: (string | number | boolean)[][];
            updateBy: string[];
            valueInputOption: "RAW" | "USER_ENTERED";
        },
        extra: EnrichedExtra,
    ) => Promise<{ [key: string]: unknown }>;
    name: string;
}