Google Sheets is a cloud-based spreadsheet platform used across teams for tracking data, managing records, and collaborating on reports. Connecting it to Duvo lets your assignments read, write, and manage spreadsheet data on your behalf, turning static sheets into dynamic data sources for automated workflows.Documentation Index
Fetch the complete documentation index at: https://docs.duvo.ai/llms.txt
Use this file to discover all available pages before exploring further.
Setup
Click Enable on the Connections page and authorize with your Google account.Capabilities
- Create spreadsheets — Generate new spreadsheets and add sheets to existing ones to organize data for your workflows.
- Read spreadsheet data — Pull values from any sheet you have access to, including cell ranges, full sheets, and multi-tab workbooks.
- Update individual cells — Modify specific cell values to keep records current as your assignment processes information.
- Batch update and append rows — Write or append large volumes of data efficiently, including CSV imports, without manual entry.
- Clear data ranges — Remove values from specific cell ranges to reset sheets or prepare them for fresh data.
- Format cells — Apply formatting such as number formats, text styles, and colors to keep spreadsheets readable and professional.
- Rename and organize sheets — Rename tabs within a spreadsheet to reflect their contents or workflow stage.
Key Benefits
- Central data hub — Connect your assignments to the spreadsheets your team already uses, with no migration required.
- Bulk operations — Read or write hundreds of rows at once, including direct CSV imports, saving hours of manual data entry.
- Real-time record keeping — Keep spreadsheets current with automated updates as your assignments complete their work.
- Audit trails — Log every assignment action in a spreadsheet for complete transparency and easy review.
- No database required — Use familiar spreadsheets as a lightweight data layer without standing up infrastructure.
Workflow Examples
See Google Sheets Workflows for step-by-step tutorials covering the three most common patterns: logging data to a live tracker, driving bulk actions from a spreadsheet list, and enriching rows with information from external sources.Works Well With
- Gmail — Pull data from incoming emails and log it in a tracking spreadsheet, or use spreadsheet data to personalize outgoing messages.
- Google Drive — Store exported spreadsheets or source files in Drive, and use Sheets for structured data processing alongside unstructured documents.
- Browser — Scrape data from web pages and write the results directly into a spreadsheet for analysis or reporting.
Troubleshooting
Error: “This operation is not supported for this document”
If you encounter the errorMCP 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.
.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.
- Open the
.xlsxfile in Google Sheets - Go to File > Save as Google Sheets
- Use the new Google Sheet URL for your assignment
.xlsx format (for compatibility with other systems), you can use the Google Drive connection instead. With Google Drive, the assignment can download the .xlsx file to its local workspace, read or modify it directly, and upload it back to Google Drive while keeping the original Excel format intact.