Overview
Phinite’s Google Sheets predefined tool lets workspace assistants call Google Sheets APIs through DevStudio after you save a connection under Integrations → Predefined tools. Read, write, and append spreadsheet rows, format ranges, and automatePredefined tools require a saved connection before they appear in Graph Studio’s tool picker. See Predefined Tools in GraphStudio.
What this integration enables
- Automate workflows using this predefined tool from agent graphs
- Connect once under Integrations and reuse across assistants
- Enable individual subtools per agent in Graph Studio
Required credentials
- See integration configuration fields in Phinite
Setup steps
- Create a Google Cloud project, enable the Sheets API, and configure OAuth or a service account.
- Log into your Phinite workspace at app.phinite.ai
- Navigate to Integrations → Predefined tools
- Select Google Sheets
- Click + Add Configuration
- Enter the credential fields listed above
- Select assistants that should use this connection
- Click Save Configuration
Configure in Graph Studio
- Open an agent in Graph Studio
- Select the agent node → Tools tab → Add a new tool
- Choose GoogleSheetsTool (or search for Google Sheets)
- Select your saved connection or add a new one
- Enable the subtools your workflow needs and save
Predefined tools
Phinite provides 4 subtools for Google Sheets:- Read Sheet: Read values from a Google Sheet range
- Update Sheet: Overwrite values in a Google Sheet range
- Create Sheet: Create a new Google Spreadsheet
- Duplicate Sheet: Duplicate an existing Google Spreadsheet
Documentation & resources
- Official documentation:
https://developers.google.com/sheets/api - Phinite documentation: Google Sheets
Notes
- Store API keys and tokens securely; many providers show secrets only once
- Use separate connections for Dev, UAT, and Prod environments where possible
- Test with a minimal subtool call after saving credentials