Google Sheets
What is the Google Sheets Connection?
The Google Sheets connection connects your Google account to Duvo, enabling your assignments to read, write, and manage spreadsheets on your behalf. This is a user-configured connection—you'll need to connect your Google account before your assignments can use it.
What Can It Do?
The Google Sheets connection provides actions that allow your assignments to:
Create spreadsheets: Generate new spreadsheets programmatically
Read data: Retrieve spreadsheet content by ID
Update cells: Modify individual cell values
Batch operations: Update or clear multiple cells at once for efficiency
Why This Matters
Spreadsheets are the backbone of many business operations—tracking inventory, managing orders, maintaining customer lists, logging activities, and analyzing data. The Google Sheets connection allows your assignments to interact with these critical data sources automatically, reading information to inform decisions and writing results to keep records current.
When to Use It
Use the Google Sheets connection when your assignment needs to:
Read data sources: Pull customer lists, inventory levels, pricing tables, or reference data from spreadsheets
Log activities: Record assignment actions, transactions, or process results in tracking sheets
Update records: Modify order status, inventory counts, or customer information
Generate reports: Create and populate new spreadsheets with analyzed data
Maintain databases: Use spreadsheets as simple databases for business information
How It Works
After connecting your Google account, your assignments can access your spreadsheets using your logins and permissions. When you include Google Sheets actions in your assignment's SOP, it will read and write data just as you would—pulling information to use in workflows and updating sheets with results.
Key Benefits
Central data hub: Connect your assignments to the spreadsheets your team already uses
Flexible data operations: Read individual values or batch update hundreds of cells efficiently
Real-time updates: Keep your spreadsheets current with automated data entry
Audit trails: Log every assignment action in a spreadsheet for complete transparency
No database required: Use familiar spreadsheets as your assignment's data source
The Google Sheets connection is essential for workflows involving data tracking, reference lookups, or record-keeping—transforming spreadsheets from static documents into dynamic, automated data sources.
Troubleshooting
Error: "This operation is not supported for this document"
If you encounter the error MCP error -32603: Error listing sheets: This operation is not supported for this document, this is likely because you're trying to access an imported .xlsx file rather than a native Google Sheet.
Why this happens: The Google Sheets API has a limitation where certain operations are not supported on imported Excel files (.xlsx). When you upload an Excel file to Google Drive, it remains in .xlsx format by default, even though you can view it in the Google Sheets interface. You can identify these files by the .xlsx extension in the filename or the Excel icon in Google Drive.
Solution: Convert the imported file to a native Google Sheet format:
Open the
.xlsxfile in Google SheetsGo to File → Save as Google Sheets
Use the new Google Sheet URL for your assignment
After saving as a native Google Sheet, copy the new spreadsheet URL and use that in your assignment. The Google Sheets connection will work correctly with the converted file.
Alternative solution: If you need to preserve the .xlsx format (e.g., for compatibility with other systems), you can use the Google Drive connection instead. With Google Drive, the agent can download the .xlsx file to its local workspace, read or modify it directly, and upload it back to Google Drive—all while keeping the original Excel format intact.
Last updated