# Read and analyse a Google Sheet

> Give your AI a Google Sheets link and ask questions about the data: totals, trends, outliers and comparisons, without copying anything out.

Ask questions about a spreadsheet in plain words, by pasting its link.

## What you'll get

- The spreadsheet's tabs and their sizes, so you can pick the right one.
- Answers worked out from the values: totals, averages, groupings, trends and outliers.
- Tables you can paste back into the sheet or into a report.

## What you need

- [Google Sheets](https://docs.plugsight.app/connectors/google-sheets.md) connected, with a Google account that can open the spreadsheet. Any plan.
- The spreadsheet's link from your browser's address bar. Your AI can't browse or search your Drive for spreadsheets.

## Ask this

```text
Using Plugsight, here's our budget sheet: https://docs.google.com/spreadsheets/d/… First tell me what tabs it has. Then, from the "2026" tab, total the Actual column by category and month, and list the categories that are more than 10% over budget this quarter.
```

## Variations

- **One range:** "Read Sales!A1:F500 and total the Amount column by month."
- **Filter rows:** "Read the Leads tab and list everyone from London."
- **No header row:** "The first row isn't a header; the data starts at A1."
- **Compare with live data:** "Compare the monthly targets in this sheet with actual Google Ads spend." Needs Google Ads on the Pro or Agency plan.
- **A sheet sent by email:** "Add up the totals on the spreadsheet attached to the supplier's last email." That reads the email attachment instead: see [Find and summarise invoices](https://docs.plugsight.app/recipes/find-invoices.md).

## What your AI does behind the scenes

1. Reads the spreadsheet's details (`sheets_get_info`): title, tabs with their size, and named ranges.
2. Reads the values from a tab, a range such as "Sales!A1:F200", or a named range (`sheets_read`), as they're shown in Google Sheets. The first row becomes the column names unless you say otherwise. Without a range, the first tab is read.
3. Works out the answer from the values.

Up to 5,000 rows are read at a time (500 by default). For bigger sheets, ask for a range, or let your AI read it in parts.

## Does it change anything?

No. Google Sheets is read-only in Plugsight: your AI can't edit cells, tabs or files.

## Related articles

- [Google Sheets](https://docs.plugsight.app/connectors/google-sheets.md)
- [Summarise a Google Doc](https://docs.plugsight.app/recipes/summarise-google-doc.md)

---

Web version: https://docs.plugsight.app/recipes/analyse-google-sheet
