3fi$dZddlmZmZmZmZmZddlmZddl m Z m Z ddl m Z ddlmZGdd e ZGd d e Zy ) z*Tool for creating new Google Spreadsheets.)AnyDictListOptionalType)CallbackManagerForToolRun) BaseModelField)SheetsBaseTool)validate_range_nameceZdZUdZedZeed<eddZe eed<ed d Z e eed <ed d Z e eed<eddZ e e e eed<eddZe eed<y)CreateSpreadsheetSchemaz/Input schema for `SheetsCreateSpreadsheetTool`.z!The title of the new spreadsheet.) descriptiontitleen_USzrThe locale of the spreadsheet in one of the ISO 639-1 language codes (e.g. 'en_US', 'fr_FR'). Defaults to 'en_US'.)defaultrlocaleAmerica/New_YorkzThe time zone of the spreadsheet, specified as a time zone ID from the IANA Time Zone Database (e.g. 'America/New_York', 'Europe/London'). Defaults to 'America/New_York'. time_zone ON_CHANGEzThe amount of time to wait before volatile functions are recalculated. Options: 'ON_CHANGE', 'MINUTE', 'HOUR'. Defaults to 'ON_CHANGE'. auto_recalcNzOptional initial data to populate the spreadsheet. 2D array where each inner array represents a row. Supports strings, numbers, booleans, and formulas. initial_dataA1z@The range where initial data should be placed. Defaults to 'A1'. initial_range)__name__ __module__ __qualname____doc__r rstr__annotations__rrrrrrrrw/var/www/auto_recruiter/arenv/lib/python3.12/site-packages/langchain_google_community/sheets/create_spreadsheet_tool.pyrrs9#FGE3G! KFHSM %" @ Ix}"' '"K#/4 A/L(4S ?+$)V$M8C=r#rceZdZUdZdZeed<dZeed<eZ e e ed< dded e ed e ed e ed e e e ed e ede edeeeffdZy)SheetsCreateSpreadsheetToolaH Tool for creating new Google Spreadsheets. Inherits from [`SheetsBaseTool`][langchain_google_community.sheets.base.SheetsBaseTool]. Creates spreadsheets with configurable properties and optional initial 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): Unique ID of the created spreadsheet. spreadsheet_url (str): Direct URL to open the spreadsheet. title (str): The spreadsheet title. locale (str): The locale setting. time_zone (str): The timezone setting. auto_recalc (str): The recalculation setting. created (bool): Whether creation succeeded. initial_data_added (bool): Whether initial data was added (if provided). initial_data_cells_updated (int): Number of cells updated (if data added). initial_data_range (str): Range where data was placed (if data added). ???+ example "Basic Usage" Create a simple spreadsheet: ```python from langchain_google_community.sheets import SheetsCreateSpreadsheetTool tool = SheetsCreateSpreadsheetTool(api_resource=service) result = tool.run({"title": "My New Spreadsheet"}) print(f"Created: {result['spreadsheet_url']}") ``` ??? example "With Initial Data" Create spreadsheet with pre-populated data: ```python result = tool.run( { "title": "Sales Report", "initial_data": [ ["Name", "Region", "Sales"], ["Alice", "East", "95000"], ["Bob", "West", "87000"], ], "initial_range": "A1", } ) ``` ??? example "Custom Configuration" Create with locale and timezone settings: ```python result = tool.run( { "title": "European Report", "locale": "fr_FR", "time_zone": "Europe/Paris", "auto_recalc": "HOUR", } ) ``` Raises: ValueError: If write permissions unavailable or validation fails. Exception: If API call fails. sheets_create_spreadsheetnamezCreate a new Google Spreadsheet with the specified title and properties. Can optionally populate the spreadsheet with initial data.r args_schemaNrrrrrr run_managerreturnc 6|j |j}d||||di} |jj| dj } | j d} | j d} | j di} d| | | j d|| j d || j d || j d |dd }|rt t |xsd }d|i}|jjj| |d|j }d|d<|j dd|d<||d<|S|S#t$r}t||d<d|d<Yd}~|Sd}~wwxYw#t$r}td||d}~wwxYw)aCreate a new Google Spreadsheet. Args: title: Title of the new spreadsheet. locale: Locale of the spreadsheet. time_zone: Timezone of the spreadsheet. auto_recalc: Recalculation setting. initial_data: Optional 2D array of initial data to populate. initial_range: Range where initial data should be placed. run_manager: Optional callback manager. Returns: success (bool): Whether operation succeeded. spreadsheet_id (str): Unique ID of created spreadsheet. spreadsheet_url (str): Direct URL to spreadsheet. title (str): Spreadsheet title. locale (str): Locale setting. time_zone (str): Timezone setting. auto_recalc (str): Recalculation setting. created (bool): Whether creation succeeded. initial_data_added (bool): Whether initial data was added. initial_data_cells_updated (int): Number of cells updated. initial_data_range (str): Range where data was placed. Raises: ValueError: If write permissions unavailable or validation fails. Exception: If API call fails. properties)rrtimeZone autoRecalcz'spreadsheetId,spreadsheetUrl,properties)bodyfields spreadsheetIdspreadsheetUrlTrrr.r/)successspreadsheet_idspreadsheet_urlrrrrcreatedrvaluesRAW)r2rangevalueInputOptionr0initial_data_added updatedCellsrinitial_data_cells_updatedinitial_data_rangeinitial_data_errorFNzError creating spreadsheet: ) _check_write_permissions _get_service spreadsheetscreateexecutegetr r8update Exceptionr )selfrrrrrrr*servicespreadsheet_body spreadsheetr5r6r-resultvalidated_ranger0 update_resulteerrors r$_runz SheetsCreateSpreadsheetTool._runsN %%'I O'')G"$ )"-   $$&)D )___=N)oo.>?O$r:J "0#2#7$..6:'^^J B)~~lKH F9&9-:O4&PO$l3D ,,.*8"1-2!%   !"48F/0;H;L;L&<F784AF/0M6M !936q6F/038F/0M 9 O:5'BC N OsIC E;A1E E;E; E8E3-E;3E88E;; FFF)rrrNrN)rrrrr(r r!rrr)rr rrrrrrRr"r#r$r&r&>sJX,D#+ E$;Ki: !(#5%026'+;?rOrO rOC= rO c] rO tDI/ rO }rO78rO c3hrOr#r&N)rtypingrrrrrlangchain_core.callbacksrpydanticr r baser utilsr rr&r"r#r$rXs7022>% &&i&\FO.FOr#