# Google Sheets

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.

## Setup

Click **Enable** on the [Connections page](https://app.duvo.ai/integrations) 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.

## 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 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:

1. Open the `.xlsx` file in Google Sheets
2. Go to **File** > **Save as Google Sheets**
3. 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 (for compatibility with other systems), you can use the [Google Drive connection](https://docs.duvo.ai/connections/available-connections/google-drive) 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.