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 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
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.
What your AI does behind the scenes
- Reads the spreadsheet's details (
sheets_get_info): title, tabs with their size, and named ranges. - 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. - 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
Was this page helpful?