Create Spreadsheet
Creates a new spreadsheet in Zoho Sheet.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.CREATE_SPREADSHEET])
Add Row
Adds a new row to a specified spreadsheet.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.ADD_ROW])
Update Cell
Updates the value of a specific cell in a spreadsheet.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.UPDATE_CELL])
Delete Row
Deletes a specified row from a spreadsheet.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.DELETE_ROW])
Add Column
Adds a new column to a specified spreadsheet.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.ADD_COLUMN])
Delete Column
Deletes a specified column from a spreadsheet.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.DELETE_COLUMN])
Copy Worksheet
Creates a copy of an existing worksheet within the same or different spreadsheet.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.COPY_WORKSHEET])
Rename Worksheet
Renames an existing worksheet in a spreadsheet.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.RENAME_WORKSHEET])
Sort Data
Sorts data in a specified range based on given criteria.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.SORT_DATA])
Filter Data
Applies filters to a specified range of data based on given conditions.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.FILTER_DATA])
Merge Cells
Merges a specified range of cells into a single cell.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MERGE_CELLS])
Insert Chart
Inserts a chart based on selected data in the spreadsheet.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.INSERT_CHART])
Share Spreadsheet
Shares the spreadsheet with specified users or groups with defined permissions.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.SHARE_SPREADSHEET])
Export Spreadsheet
Exports the spreadsheet to a specified format (e.g., PDF, CSV).
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.EXPORT_SPREADSHEET])
Import Data
Imports data from an external source into the spreadsheet.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.IMPORT_DATA])
Create Pivot Table
Creates a pivot table from specified data in the spreadsheet.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.CREATE_PIVOT_TABLE])
Protect Range
Applies protection to a specified range of cells, limiting edit access.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.PROTECT_RANGE])
New Spreadsheet Created
Triggered when a new spreadsheet is created in Zoho Sheet.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.NEW_SPREADSHEET_CREATED])
Spreadsheet Modified
Triggered when any changes are made to a specified spreadsheet.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.SPREADSHEET_MODIFIED])
Row Added
Triggered when a new row is added to a specified spreadsheet.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.ROW_ADDED])
Column Added
Triggered when a new column is added to a specified spreadsheet.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.COLUMN_ADDED])
Cell Updated
Triggered when a specific cell or range of cells is updated.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.CELL_UPDATED])
Spreadsheet Shared
Triggered when the spreadsheet is shared with a new user or group.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.SPREADSHEET_SHARED])
Data Import Completed
Triggered when a data import process is successfully completed.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.DATA_IMPORT_COMPLETED])
Spreadsheet Exported
Triggered when the spreadsheet is exported to another format.
from composio_crewai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.SPREADSHEET_EXPORTED])