What and how it can be used:
The Google Sheets component connects to Google Sheets through the Composio platform using OAuth2 and exposes spreadsheet actions as tools for an Agent or as data operations in a flow. It enables reading, writing, updating, and managing spreadsheet data, creating sheets, formatting cells, performing calculations, and integrating spreadsheet operations into workflows. This component provides seamless integration with Google Sheets for data management and automation.
When/how the component should be used:
- Use when you need to read from, write to, or manipulate Google Sheets documents within a Langflow flow or when an agent needs sheet access.
- Best for syncing data between systems and spreadsheets.
- Add the Google Sheets component to the flow.
- In the Composio API Key field, enter your Composio API key or use the COMPOSIO_API_KEY global variable.
- If the key is valid, the Alert is replaced by a Success indicator, and the Actions list populates with actions available to your API key.
- In the component’s header menu, enable Tool Mode.
- In the Actions list, configure the Google Sheets actions that you want to provide to the agent. You can select the actions you want to allow, and you can edit each action’s slug (agentic label) and description, which help the agent decide which tools to use.
- Connect the Google Sheets component’s Toolset output to the Agent Core component’s Tools input.
- In the Agent Core component, enter your OpenAI API key or configure the Agent component to use a different LLM.
- Connect Chat Input component to the Agent Core component’s Input port.
- Connect the Agent Core component’s Output port to the Chat Output component, which returns the final response to the user or application.
Connections with other components:
- Chat Output
- Batch Run
- DataFrame Operations
- Parser
- Save File
- Split Text
- Type Convert
- Loop
- Notify
- ChromaDB
In tool mode:
- Agent Core
- Human-in-the-loop
Configurable settings:
- Composio API Key
- Action
Default settings:
- Composio API Key
- Action
Control Section:
- Composio API Key
- Action
- Auth Mode
- Entity ID
- Actions in tool mode
Default values:
- Entity ID = default
- Actions =GOOGLE_SHEETS_ADD_SHEET,
GOOGLE_SHEETS_AGGREGATE_COLUMN_DATA,
GOOGLE_SHEETS_APPEND_DIMENSION,
GOOGLE_SHEETS_BATCH_GET,
GOOGLE_SHEETS_BATCH_UPDATE
Desired Behaviour:
- Connect securely to a user’s Google Sheets via OAuth2 (through Composio).
- Require a valid Composio API key + an authorized account connection.
- Show only allowed actions (e.g., read, write, insert rows).