3fi]HdZddlmZmZmZmZmZddlmZddl m Z m Z ddl m Z ddlmZmZddlmZmZGd d e ZGd d eZGd de ZGddeZGdde ZGdde ZGdde ZGdde ZGddeZGdde Zy)z(Tools for writing data to Google Sheets.)AnyDictListOptionalType)CallbackManagerForToolRun) BaseModelField)SheetsBaseTool)InsertDataOptionValueInputOption)validate_range_namevalidate_spreadsheet_idc`eZdZUdZedZeed<eejdZ eed<y) WriteBaseSchemaz4Base schema for write operations with common fields.z-The ID of the Google Spreadsheet to write to. descriptionspreadsheet_idzkHow to interpret input values. 'RAW' stores values as-is. 'USER_ENTERED' parses values as if typed by user.defaultrvalue_input_optionN) __name__ __module__ __qualname____doc__r rstr__annotations__r USER_ENTEREDrq/var/www/auto_recruiter/arenv/lib/python3.12/site-packages/langchain_google_community/sheets/write_sheet_tools.pyrrs=>CNC,1 -- @,(r!rcVeZdZUdZedZeed<edZe e e ed<y)UpdateValuesSchemaz*Input schema for `SheetsUpdateValuesTool`.z>The A1 notation of the range to update (e.g., 'Sheet1!A1:C3').rrangezr2D array of values to write. Each inner array represents a row. Supports strings, numbers, booleans, and formulas.valuesN rrrrr r%rrr&rrr r!r"r$r$*s:4TE3$ AFDcOr!r$ceZdZUdZdZeed<dZeed<eZ e e ed<e jdfded ed eeed e d eed eeeff dZy)SheetsUpdateValuesToolaTool for updating values in a single range of Google Sheets. Inherits from [`SheetsBaseTool`][langchain_google_community.sheets.base.SheetsBaseTool]. Updates cell values in a specified range, overwriting existing data. !!! note "Authentication Required" Requires OAuth2 authentication. Use `api_resource` parameter with authenticated Google Sheets service. Tool Output: success (bool): Whether operation succeeded. spreadsheet_id (str): The spreadsheet ID. updated_range (str): The A1 notation of updated range. updated_rows (int): Number of rows updated. updated_columns (int): Number of columns updated. updated_cells (int): Total number of cells updated. ???+ example "Basic Usage" Update a range with data: ```python from langchain_google_community.sheets import SheetsUpdateValuesTool tool = SheetsUpdateValuesTool(api_resource=service) result = tool.run( { "spreadsheet_id": "1TI6vO9eGsAeXcfgEjoEYcu4RgSZCUF4vdWGLBpg9-fg", "range": "Sheet1!A1:C3", "values": [ ["Name", "Age", "City"], ["Alice", "25", "New York"], ["Bob", "30", "San Francisco"], ], } ) ``` ??? example "With Formulas" Update cells with formulas using `USER_ENTERED`: ```python result = tool.run( { "spreadsheet_id": "1TI6vO9eGsAeXcfgEjoEYcu4RgSZCUF4vdWGLBpg9-fg", "range": "Sheet1!D2:D3", "values": [["=SUM(B2:C2)"], ["=SUM(B3:C3)"]], "value_input_option": "USER_ENTERED", } ) ``` Raises: ValueError: If write permissions unavailable or validation fails. Exception: If `spreadsheet_id` is invalid, range is malformed, or API errors occur. sheets_update_valuesnameziUpdate values in a single range of a Google Spreadsheet. Overwrites existing data in the specified range.r args_schemaNrr%r&r run_managerreturnc |j t|}t|}|j}d|i}|j j j |||j|j}d||jd|jdd|jdd|jddd S#t$r} td | | d } ~ wwxYw) aUpdate values in a Google Spreadsheet range. Args: spreadsheet_id: ID of the spreadsheet to update. range: A1 notation range to update (e.g., `'Sheet1!A1:C3'`). values: 2D array of values to write. value_input_option: How to interpret input values. run_manager: Optional callback manager. Returns: success (bool): Whether operation succeeded. spreadsheet_id (str): The spreadsheet ID. updated_range (str): The A1 notation of updated range. updated_rows (int): Number of rows updated. updated_columns (int): Number of columns updated. updated_cells (int): Total number of cells updated. Raises: ValueError: If write permissions unavailable or validation fails. Exception: For API errors or connection issues. r&) spreadsheetIdr%valueInputOptionbodyT updatedRange updatedRowsrupdatedColumns updatedCells)successr updated_range updated_rowsupdated_columns updated_cellszError updating sheet data: N) _check_write_permissionsrr _get_service spreadsheetsr&updatevalueexecuteget Exception) selfrr%r&rr-servicer2resulterrors r"_runzSheetsUpdateValuesTool._runs< %%'# N4^DN'.E'')Gf%D$$&"0%7%=%=    "0!'N!; & =! <#)::.>#B!'NA!>   N9%AB M NsB:C C*C%%C*)rrrrr+rrrr$r,rr rrrrrrrrHr r!r"r)r)9s<|'D#& ; $6Ki50@/L/L;? CNCNCNT#Y CN - CN 78 CN c3hCNr!r)ceZdZUdZedZeed<edZe e e ed<ee jdZ e ed <y ) AppendValuesSchemaz*Input schema for `SheetsAppendValuesTool`.zlThe A1 notation of the table range to append to. The API will find the last row of data and append below it.rr%zs2D array of values to append. Each inner array represents a row. Supports strings, numbers, booleans, and formulas.r&znHow to handle existing data. 'OVERWRITE' overwrites data after table. 'INSERT_ROWS' inserts new rows for data.rinsert_data_optionN)rrrrr r%rrr&rrr INSERT_ROWSrKr r!r"rJrJs`4 JE3$ AFDcO,1 ,, 7,(r!rJceZdZUdZdZeed<dZeed<eZ e e ed<e jejdfded ed eeed e d ed eedeeeffdZy)SheetsAppendValuesToolaTool for appending values to a Google Spreadsheet table. Inherits from [`SheetsBaseTool`][langchain_google_community.sheets.base.SheetsBaseTool]. Appends data to the end of a table, automatically finding the last row with data. !!! note "Authentication Required" Requires OAuth2 authentication. Use `api_resource` parameter with authenticated Google Sheets service. Tool Output: success (bool): Whether operation succeeded. spreadsheet_id (str): The spreadsheet ID. table_range (str): The range of the entire table. updated_range (str): The specific range where data was appended. updated_rows (int): Number of rows appended. updated_columns (int): Number of columns appended. updated_cells (int): Total number of cells updated. ???+ example "Basic Usage" Append new records to a table: ```python from langchain_google_community.sheets import SheetsAppendValuesTool tool = SheetsAppendValuesTool(api_resource=service) result = tool.run( { "spreadsheet_id": "1TI6vO9eGsAeXcfgEjoEYcu4RgSZCUF4vdWGLBpg9-fg", "range": "Sheet1!A1:D100", "values": [ ["Eve", "27", "Seattle", "91"], ["Frank", "32", "Denver", "85"], ], } ) ``` ??? example "With Insert Rows Option" Insert rows instead of overwriting: ```python result = tool.run( { "spreadsheet_id": "1TI6vO9eGsAeXcfgEjoEYcu4RgSZCUF4vdWGLBpg9-fg", "range": "Sheet1!A1:D100", "values": [["New", "Record", "Data", "Here"]], "insert_data_option": "INSERT_ROWS", } ) ``` Raises: ValueError: If write permissions unavailable or validation fails. Exception: If `spreadsheet_id` is invalid, range is malformed, or API errors occur. sheets_append_valuesr+zmAppend values to a table in a Google Spreadsheet. Automatically finds the last row and appends data below it.rr,Nrr%r&rrKr-r.c 4|j t|}t|}|j}d|i}|j j j |||j|j|j} | jdi} d|| jd| jd| jdd| jd d| jd dd S#t$r} td | | d } ~ wwxYw)aAppend values to a Google Spreadsheet table. Args: spreadsheet_id: ID of the spreadsheet. range: A1 notation table range to append to. values: 2D array of values to append. value_input_option: How to interpret input values. insert_data_option: How to handle existing data. run_manager: Optional callback manager. Returns: success (bool): Whether operation succeeded. spreadsheet_id (str): The spreadsheet ID. table_range (str): The range of the entire table. updated_range (str): The specific range where data was appended. updated_rows (int): Number of rows appended. updated_columns (int): Number of columns appended. updated_cells (int): Total number of cells updated. Raises: ValueError: If write permissions unavailable or validation fails. Exception: For API errors or connection issues. r&)r0r%r1insertDataOptionr2updatesT tableRanger3r4rr5r6)r7r table_ranger8r9r:r;zError appending sheet data: N) r<rrr=r>r&appendr@rArBrC) rDrr%r&rrKr-rEr2rFrRrGs r"rHzSheetsAppendValuesTool._run0s$B %%'' O4^DN'.E'')Gf%D$$&"0%7%=%=%7%=%=  jjB/G "0%zz,7!(^!< ' M1 =#*;;/?#C!(^Q!?  O:5'BC N OsC'C:: DDD)rrrrr+rrrrJr,rr rrr rLrrrrrrHr r!r"rNrNs=~'D#& F $6Ki50@/L/L/?/K/K;?JOJOJOT#Y JO - JO - JO78JO c3hJOr!rNcJeZdZUdZedZeed<edZeed<y)ClearValuesSchemaz)Input schema for `SheetsClearValuesTool`.z!The ID of the Google Spreadsheet.rrzlThe A1 notation of the range to clear (e.g., 'Sheet1!A1:Z100'). Only values are cleared; formatting remains.r%N) rrrrr rrrr%r r!r"rWrWs+3,OPNCP ;E3r!rWc neZdZUdZdZeed<dZeed<eZ e e ed< d ded ed e e d eeeffd Zy)SheetsClearValuesToola[Tool for clearing values from a Google Spreadsheet range. Inherits from [`SheetsBaseTool`][langchain_google_community.sheets.base.SheetsBaseTool]. Clears cell values from a specified range while preserving formatting and structure. !!! note "Authentication Required" Requires OAuth2 authentication. Use `api_resource` parameter with authenticated Google Sheets service. !!! info "Formatting Preserved" Only values are cleared. Formatting, borders, colors, fonts, and data validation rules remain intact. Tool Output: success (bool): Whether operation succeeded. spreadsheet_id (str): The spreadsheet ID. cleared_range (str): The A1 notation of the cleared range. ???+ example "Basic Usage" Clear a range of cells: ```python from langchain_google_community.sheets import SheetsClearValuesTool tool = SheetsClearValuesTool(api_resource=service) result = tool.run( { "spreadsheet_id": "1TI6vO9eGsAeXcfgEjoEYcu4RgSZCUF4vdWGLBpg9-fg", "range": "Sheet1!A1:Z100", } ) ``` Raises: ValueError: If write permissions unavailable or validation fails. Exception: If `spreadsheet_id` is invalid, range is malformed, or API errors occur. sheets_clear_valuesr+zlClear values from a range in a Google Spreadsheet. Only values are cleared; formatting and structure remain.rr,Nrr%r-r.cV|j t|}t|}|j}|j j j ||ij}d||jddS#t$r}td||d}~wwxYw)a>Clear values from a Google Spreadsheet range. Args: spreadsheet_id: ID of the spreadsheet. range: A1 notation range to clear. run_manager: Optional callback manager. Returns: success (bool): Whether operation succeeded. spreadsheet_id (str): The spreadsheet ID. cleared_range (str): The A1 notation of the cleared range. Raises: ValueError: If write permissions unavailable or validation fails. Exception: For API errors or connection issues. )r0r%r2T clearedRange)r7r cleared_rangezError clearing sheet data: N) r<rrr=r>r&clearrArBrC)rDrr%r-rErFrGs r"rHzSheetsClearValuesTool._runs. %%' N4^DN'.E'')G$$&"0   "0!'N!;   N9%AB M NsA8B B(B##B()N)rrrrr+rrrrWr,rr rrrrrHr r!r"rYrYsz+Z&D#% D $5Ki4 <@ 4N4N4N78 4N c3h 4Nr!rYcVeZdZUdZedZeed<edZe e e ed<y)BatchUpdateDataSchemaz4Schema for a single range update in batch operation.z The A1 notation range to update.rr%zU2D array of values for this range. Supports strings, numbers, booleans, and formulas.r&Nr'r r!r"r`r`s4>#EFE3F# AFDcOr!r`c4eZdZUdZedZeeed<y)BatchUpdateValuesSchemaz/Input schema for `SheetsBatchUpdateValuesTool`.z%List of range/values pairs to update.rdataN) rrrrr rcrr`rr r!r"rbrbs9(-;)D$$ %r!rbc eZdZUdZdZeed<dZeed<eZ e e ed<e jdfded eeeefd e d eed eeeff d Zy)SheetsBatchUpdateValuesToola Tool for batch updating multiple ranges in Google Sheets efficiently. Inherits from [`SheetsBaseTool`][langchain_google_community.sheets.base.SheetsBaseTool]. Updates multiple ranges in a single API call, dramatically improving efficiency. Tool Output: success (bool): Whether operation succeeded. spreadsheet_id (str): The spreadsheet ID. total_updated_ranges (int): Number of ranges updated. total_updated_cells (int): Total cells updated across all ranges. total_updated_rows (int): Total rows updated. total_updated_columns (int): Total columns updated. responses (list): Individual results for each range with `updated_range` and `updated_cells`. ???+ example "Basic Usage" Update multiple ranges in one call: ```python from langchain_google_community.sheets import SheetsBatchUpdateValuesTool tool = SheetsBatchUpdateValuesTool(api_resource=service) result = tool.run( { "spreadsheet_id": "1TI6vO9eGsAeXcfgEjoEYcu4RgSZCUF4vdWGLBpg9-fg", "data": [ { "range": "Sheet1!G1:G3", "values": [["Status"], ["Active"], ["Active"]], }, {"range": "Sheet1!H1:H3", "values": [["Country"], ["USA"]]}, {"range": "Sheet1!I1:I3", "values": [["Dept"], ["Eng"]]}, ], } ) ``` ??? example "Update Multiple Sheets" Update ranges across different sheets: ```python result = tool.run( { "spreadsheet_id": "1TI6vO9eGsAeXcfgEjoEYcu4RgSZCUF4vdWGLBpg9-fg", "data": [ { "range": "Sheet1!A1:A5", "values": [["Data1"], ["Data2"], ["Data3"]], }, {"range": "Sheet2!B1:B3", "values": [["Value1"], ["Value2"]]}, ], "value_input_option": "USER_ENTERED", } ) ``` Raises: ValueError: If write permissions unavailable or validation fails. Exception: If `spreadsheet_id` is invalid, any range is malformed, or API errors occur. sheets_batch_update_valuesr+zoBatch update multiple ranges in a Google Spreadsheet efficiently. Updates multiple ranges in a single API call.rr,Nrrcrr-r.c"|j t|}|s td|j|}g}|D]C}|j d}|j d} t ||j || dE|j} |j|d} | jjj|| j} | j dg} td| D}td | D}td | D}d |t| |||| Dcgc]&}|j d |j d dd(c}dScc}w#t$r}td||d}~wwxYw)aBatch update multiple ranges in a Google Spreadsheet. Args: spreadsheet_id: ID of the spreadsheet. data: List of range/values pairs to update. value_input_option: How to interpret input values. run_manager: Optional callback manager. Returns: success (bool): Whether operation succeeded. spreadsheet_id (str): The spreadsheet ID. total_updated_ranges (int): Number of ranges updated. total_updated_cells (int): Total cells updated. total_updated_rows (int): Total rows updated. total_updated_columns (int): Total columns updated. responses (list): Individual results for each range. Raises: ValueError: If write permissions unavailable, validation fails, or data list is empty. Exception: For API errors or connection issues. z$At least one range must be specifiedr%r&)r%r&)r1rc)r0r2 responsesc3@K|]}|jddyw)r6rNrB.0responses r" z3SheetsBatchUpdateValuesTool._run..s &4< ^Q/&c3@K|]}|jddyw)r4rNrjrks r"rnz3SheetsBatchUpdateValuesTool._run..s %3; ]A.%roc3@K|]}|jddyw)r5rNrjrks r"rnz3SheetsBatchUpdateValuesTool._run..s!(6> -q1(roTr3r6r)r8r;)r7rtotal_updated_rangestotal_updated_cellstotal_updated_rowstotal_updated_columnsrhz!Error batch updating sheet data: N)r<r ValueError_convert_to_dict_listrBrrUr=r@r>r& batchUpdaterAsumlenrC)rDrrcrr- data_dicts value_ranges item_dict range_namer&rEr2rFrhrsrtrurrGs r"rHz SheetsBatchUpdateValuesTool._runds< %%'A T4^DN !GHH33D9JL' M &]]73 "x0$J/##jF$KL M'')G);(@(@,WD$$&>E  ;3I"%&@I&# "%%?H%" %((BK(% !  "0(+I':&8)> '  *+~)>)*~q)A  T?wGHe S Ts*D*E1<+E,'E1,E11 F:F  F)rrrrr+rrrrbr,rr rrrrrrrrHr r!r"reresAF-D#, 8 $;Ki: 0@/L/L;? aTaT4S>"aT- aT 78 aT c3h aTr!reN)rtypingrrrrrlangchain_core.callbacksrpydanticr r baser enumsr rutilsrrrr$r)rJrNrWrYr`rbrer r!r"rs.22>% 5i,  KN^KNf6SO^SOv  kNNkNf I onT.nTr!