Google Sheets
Connect Google Sheets to BotDojo so agents can read and write spreadsheet data.
Connect Google Sheets to BotDojo so agents can read and write spreadsheet data.
Before You Start
You will need:
- A Google account with access to the target spreadsheet
- Access to BotDojo's Integrations page
- Permission to approve the Google OAuth scopes during connect
Connect Google Sheets in BotDojo
- Open Integrations in BotDojo.
- Find Google Sheets in the Agent Tools section.
- Click Connect.
- Sign in with your Google account and approve the requested spreadsheet permissions.
- Wait for BotDojo to finish the OAuth flow and save the integration.
Supported Actions
Google Sheets supports these agent actions:
- Append a row
- Append or update a row
- Read a sheet
- Update a row
- Clear a sheet range
- Delete rows
- Create a sheet
- Remove a sheet
- Create a spreadsheet
- Delete a spreadsheet
Troubleshooting
- Connect fails: approve the Google OAuth prompt again and make sure the account has Sheets access.
- Read or write actions fail: confirm the sheet is shared with the connected Google account.
- Row updates do not match: verify the key column and range you pass into the tool.