Google Sheet
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.
- Combine Strava read tools with Google Sheets write tools for a training log.
Required setup
Set up a Composio project API key separately in Settings / Project Settings / API Keys. 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 your workspace or organization may require administrator approval. Wait for an active connected account. Arkus then loads actions, and the selected Tool Mode actions become Agent tools.
If an action is missing, verify the project key, active connected account, scopes, and administrator approval. 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 | Identifies an editor Composio user outside deployed flows. Deployment uses the owner instead. | 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. Actions available in Arkus can vary by connected account and the Arkus toolkit version. 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.
- The Strava Running Coach starter flow connects Strava and Google Sheets to Agent Core.