Everything explained, start to finish

SheetPilot guides

How the side panel is organised, what each tab is for, and how a page becomes rows in your own spreadsheet without the clipboard ever getting involved.

Setup

Do this once, then never again

  1. 01Install and pin

    Add SheetPilot from the Chrome Web Store and pin it to your toolbar. The whole product lives in Chrome's side panel — click the icon and it opens beside whatever page you are reading.

  2. 02Connect Google

    Open the Settings tab and press Connect Google. Chrome's own sign-in handles it and asks for a single permission: writing to spreadsheets. No password to type, no access to the rest of your Drive.

  3. 03Point at a spreadsheet

    Paste the address of a sheet you already use, or let SheetPilot create a fresh one. Menus, automations and AI runs all choose their destination from there.

Worth doing straight after installing: reload the tabs you already had open. Chrome only puts extension code into pages that load after the extension exists, so an old tab may sit there doing nothing until you refresh it.

The side panel

Six tabs, one job each

Menus

Your own entries in the right-click menu. Each one remembers a spreadsheet, a tab inside it, a column, and a rule for what to put in that column.

Auto

Little block diagrams that read many values off a page at once and write them as rows. Everything runs on your machine and costs nothing.

AI

One button. The model reads the page in front of you, decides on the columns itself, and shows you the rows before a single one is written.

Tables

Every HTML table found on the page, listed with its size and ready to export in a click. Free, instant, no AI anywhere near it.

History

What you saved recently, which row it landed in, and a link straight back to the spreadsheet it went to.

Settings

Google connection, interface language, whether recipes are kept automatically, the panel shortcut, and your SheetPilot account.

AI extraction: one click, then a preview

The AI tab has a single button. It sends the page's text and an outline of its structure, and the model works out on its own whether it is looking at one record or a list, then names the columns for you. Names follow your interface language; the values stay in the page's own words.

  • 1Run it

    Open a page and press the button. A detail page comes back as one row; a search result or listing page comes back as many — up to fifty in a single run.

  • 2Correct the preview

    Column names are editable — click one and type your own. Untick any row you do not want. Nothing has touched your spreadsheet yet.

  • 3Clean up or translate

    Two optional passes, one credit each: tidy inconsistent values into a single format, or translate the whole preview into your language.

  • 4Choose where it lands

    Save into a brand-new spreadsheet, or into one you have used before. Writing into an existing sheet lines the columns up with your header row; anything that does not match is named in plain sight and skipped, never forced into a column that means something else.

Very long lists can hit the model's output ceiling. When that happens SheetPilot keeps every complete row it received, discards the half-written one at the end, and says it only got the first few — you are never quietly short-changed.

Recipes: pay once, replay for free

While the AI reads a page it also notes where in the page's structure each value came from. That pattern is the recipe, and it is remembered against the site — so your next visit does not need the AI at all.

  • Replay happens locally

    When a recipe exists for the site you are on, the AI tab offers to replay it instead. It runs inside your browser, finishes instantly, and costs nothing.

  • Sites change, re-learning is one click

    If a replay comes back empty, the layout has probably moved. A single AI run rewrites the recipe and replays are free again.

  • Kept with your account

    Recipes are stored on your account, so they follow you to another computer. Free accounts hold ten, Starter sixty, Pro three hundred — and you can prune them from the dashboard.

A recipe stores the pattern only — which part of a page each column came from. The values you extracted are never part of it.

Choosing a spreadsheet

The dropdown lists spreadsheets SheetPilot has already worked with, not everything in your Drive. That is on purpose: listing your whole Drive would mean asking for access to all your files, and Google's file picker would mean loading code from elsewhere at runtime. Neither is a reasonable price for a dropdown.

  • Paste an address

    Copy the URL of any spreadsheet you can edit and paste it in. From then on it sits in the dropdown like the others.

  • Create a new one

    SheetPilot can make a fresh spreadsheet named after the page you are on and start writing into it immediately.

  • Pick the tab

    Once a file is chosen, say which tab inside it receives the rows. Different menus and automations can feed different tabs of the same spreadsheet.

When something does not behave

The handful of things that actually go wrong, and what fixes them.

Nothing happens on a tab I had open before installing

Refresh the tab. Chrome only injects extension code into pages loaded after the extension was installed or updated. SheetPilot repairs this on the fly where Chrome lets it, but a reload is the dependable fix.

Connect Google does nothing

SheetPilot uses the Google sign-in built into Chrome, which needs a Google account signed into the browser itself. Other Chromium-based browsers can install the extension, but their support for that sign-in varies.

Some columns were skipped when I saved

You saved into a sheet that already has a header row, and one of the column names did not match anything in it. Rename the column in the preview so it matches your header, then save again — the skipped names are listed for you.

A saved value went into the wrong place

Check which sheet tab the menu or the sheet block is bound to, and which column each field targets. Two fields aimed at the same column is another cause: only the first one pointing at a column is honoured.

I only got the beginning of a long list

One run returns at most fifty rows, and very dense pages can end sooner. Page through the site and run again — with duplicate detection on, the second pass only adds what is new.

Next: build something that repeats itself

Menus and AI cover the everyday. When you want a page turned into a dozen rows by your own rules — a selector here, a filter there, a date column stamped on the end — that is what automations are for.

Add to Chrome SheetPilot