Getting started

Sheet Analyst, from install to first result.

This guide covers the standard installation flow and the safest way to use the toolkit.

Installation

  1. 1

    Install

    Open the Sheet Analyst listing in the Google Workspace™ Marketplace and select Install. Review the permissions shown during installation before approving.

  2. 2

    Open a spreadsheet

    Refresh Google Sheets™ after installation. The Sheet Analyst menu appears under Extensions.

  3. 3

    Start the workspace

    Choose Extensions → Sheet Analyst → Open Sheet Analyst for the full workspace, or Open Docked Sidebar for a compact view.

  4. 4

    Select your data

    Select the relevant cells in the sheet, open a tool, then use the capture button beside a range field.

  5. 5

    Review before running

    Check the selected range and output destination. Destructive actions display a confirmation first.

Install Sheet Analyst

Why Sheet Analyst asks for permissions

Sheet Analyst requests access only to the spreadsheet currently open, permission to display its interface inside Google Sheets™, and permission to make an HTTPS licensing request containing only anonymous entitlement metadata. It does not request access to all files in Google Drive™, Gmail™, Calendar or contacts.

spreadsheets.currentonly

Read and update only the spreadsheet where you use the add-on.

script.container.ui

Add the Sheet Analyst menu, dialog and sidebar to Google Sheets™.

script.external_request

Check a random installation identifier, trial status or entered license key with the Better Work Apps licensing service. Spreadsheet contents are never included.

Create a first result safely

Start with a copy of an important workbook. Choose a small range, run Descriptive Statistics, and keep the default output option that creates a new result sheet. Confirm that the result matches the source data before moving to editing or workbook-management tools.

Get help

Include the Sheet Analyst version, browser, feature name, expected result and actual result. Never email confidential spreadsheet data. Use a sanitized sample if an example is necessary.

Open the support guide →