> ## Documentation Index
> Fetch the complete documentation index at: https://docs.spinnable.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets

> Create spreadsheets, analyze data, and generate reports

# Google Sheets

**Creates spreadsheets, updates data, analyzes information, and generates reports.**

***

## What Your Workers Can Do

Workers can create new spreadsheets, update existing data, analyze information, perform calculations, and generate reports—perfect for tracking metrics, managing lists, or analyzing business data.

**Popular use cases:**

* Create expense trackers or budget sheets
* Update sales pipeline data
* Analyze metrics and generate reports
* Maintain inventory or contact lists
* Track project progress
* Build data dashboards

***

## Authentication

**Type:** OAuth 2.0

Sign in with your Google account—Spinnable receives a secure access token.

***

## Supported Actions

### Creating & Reading

* Create new spreadsheets
* Add new sheets to existing files
* Get spreadsheet info and sheet names
* Read cell values and ranges
* Search for specific data

### Updating & Analyzing

* Append rows to sheets
* Update cell values
* Batch update operations
* Copy sheets between files
* Create charts

### Managing Data

* Clear cell ranges (⚠️ destructive)
* Delete sheets (⚠️ destructive)
* Update sheet properties

<Warning>
  **Destructive actions available:** Actions like clearing cell ranges, deleting sheets, and batch updates can permanently modify data. Workers will be careful, but review important spreadsheets before granting full access.
</Warning>

***

## Important Notes

<Info>
  **File links always returned:** When workers create or update a spreadsheet, they'll always provide you with the link to access it.
</Info>

***

## Example Workflows

**Create expense tracker**

```
"Create a new Google Sheet called 'Q1 2025 Expenses' with columns: Date, Category, Description, Amount, Receipt. Share the link with me"
```

**Update sales data**

```
"In my 'Sales Pipeline' sheet, add a new row with: Date: today, Client: Acme Corp, Deal Size: $50k, Status: Negotiation"
```

**Weekly report**

```
"Every Friday at 5 PM, create a summary sheet analyzing this week's sales data from the 'Pipeline' sheet. Include total revenue, top deals, and conversion rate"
```

***

## Related Tools

* [Google Drive](/tools/google-drive) - Organize and share spreadsheets
* [Google Docs](/tools/google-docs) - Create text reports
* [Airtable](/tools/airtable) - Alternative database tool