Google Sheets
On this page
Purpose
Google Sheets connects a Composio Credential and Google account to the spreadsheet actions available in Arkus. A direct flow runs one selected action and returns a DataFrame. In Tool Mode, one configured Google Sheets component can expose several selected actions as separate tools for Agent Core.
When to use it
- Read a range for filtering, summarization, or lookup.
- Append or update spreadsheet rows.
- Create a spreadsheet or sheet and return its metadata.
Required setup
Set up a Composio project API key separately in Composio Dashboard > Platform > your project > Settings > API Keys. Follow Create a Composio API Key for the required permissions. In Arkus, enter it in Google Sheets or save it as a Credential and select it from the component. Never put the key in a prompt or example. See Composio's authentication overview.
Authorize the Google account separately. The auth config controls the scheme and scopes, and that grant is what lets the actions actually run. The Composio key loads the toolkit's actions and their fields, and the selected Tool Mode actions become Agent tools.
If an action is missing, verify the project key first, then reconnect or refresh the account. The Google Sheets toolkit page shows the broader current catalog.
How to use it
Tool Mode
- Add Google Sheets, select the Composio Credential, and connect the Google account.
- Enable Tool Mode and select only the Actions the agent needs.
- Connect Toolset to Agent Core.
- Test read actions before enabling actions that change a spreadsheet.
Normal mode
- Add Google Sheets, select the Composio Credential, and connect the Google account.
- Select one Action.
- Complete the fields shown for that action.
- Connect the DataFrame result to the next component.
Configuration
| Setting | What it controls | Recommended starting point |
|---|---|---|
| Composio API Key | Authenticates this Google Sheets component with Composio. | Select a saved Credential. |
| Entity ID | Falls back to naming the Composio user when your Arkus sign-in cannot identify one. A deployed flow always uses the owner's account. | Leave default. |
| Auth Mode | Uses the authentication choice supplied by the toolkit. | Use managed OAuth when offered. |
| Connection | Selects or creates the authorized Google account. | Connect one intended account. |
| Action | Selects one provider action for direct mode and shows its fields. | Start with a read-only range action. |
| Tool Mode | Replaces direct fields with Agent tools. | Enable only when an agent should choose actions. |
| Actions | Selects the separate tools sent through Toolset to Agent Core. | Enable only the actions the agent needs. |
Expected result
Tool Mode sends each selected Google Sheets action through Toolset as a separate Agent tool. Normal mode runs one selected action and returns a DataFrame. Object and array fields use JSON text. Write actions can change spreadsheet data and may create duplicates when repeated.
Reference details
If the Credential, connection, or selected Action is invalid, repair it before running again. A deployment requires a saved owner Credential and exactly one active Google Sheets account. Reconnect the account when deployment reports no active account or more than one.
Composio's Google Sheets reference shows the broader action catalog. Use valid JSON for nested arrays such as row values.
Related components
- Agent Core can choose enabled Sheets tools.
- DataFrame Operations processes direct-action results.