PlugsightDocs

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

  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.