Skip to main content

Google Spreadsheet Toolset

The Google Spreadsheet toolset allows AI models to create and manage spreadsheets in Google Sheets. It is useful for noting structured data from visited websites in an organized way. The toolset is on by default: turn it off with Spreadsheet tools in Options → Tools or the chat's Tools menu.

note

The toolset works with spreadsheets BrowseWiz created, and with your own spreadsheets once you choose them in Google's picker (see Working on your own spreadsheet). It can't open your other Google Sheets spreadsheets.

Capabilities​

The AI can perform the following operations:

  • Create a new spreadsheet — start a new Google Spreadsheet with a given title
  • List spreadsheets — list the spreadsheets BrowseWiz created or you gave it access to, with their links and worksheets
  • Ask for access to your spreadsheet (requestSpreadsheetAccess) — ask you to choose one of your own spreadsheets in Google's picker, so BrowseWiz can read and edit it (see Working on your own spreadsheet)
  • Get the active tab (getActiveTab) — find the tab you're looking at, and, after you allow it, read its address, so "this spreadsheet" means the sheet open in that tab (see Working on your own spreadsheet)
  • Read headers — read the column names in the first row, and the type of each typed column. To set them, the AI writes them as the first row.
  • Set column types (setColumnTypes) — give columns a type: text, number, date, URL or a currency such as PLN. The type is stored in the spreadsheet, stays with the column when you rename its header, and a currency column is formatted as an amount with its code. Ask for it ("keep Price as a PLN amount"), or the AI sets types when a task needs a column kept in one format.
  • Format cells (formatCells) — make cells bold or italic, change their font size, color their text or background, align them left, center or right, wrap their text, or clear that formatting, for up to 20 ranges at once. Number formats, such as a currency column's, stay as they are. Ask for it ("bold the header", "highlight the BMW rows").
  • Format a worksheet (formatWorksheet) — freeze the top rows so the header stays in view, fit the column widths to their contents, and color alternating rows, including rows added later. Turning alternating colors on or off replaces any alternating colors already on the worksheet, also ones you added yourself. When the AI creates a spreadsheet, it is told to freeze and bold the header row.
  • Find rows (findRows) — check which records are already in a worksheet, and in which rows, by up to 50 keys per call. It reads only the key columns, such as a URL or name column.
  • Add or update rows (upsertRows) — add up to 50 records per call, matched by key columns: a record whose key isn't in the worksheet yet is appended, and one whose key is already there is either skipped or has its non-empty values written into the existing row. Rows from a list read are all written by one call, up to 1,000 of them, 50 at a time. Nothing is written when any of them has an empty key, or when the key is the Source URL, which is the same for every row of a page. When a later group of 50 is refused, or a request to Google fails, the groups before it stay in the sheet.
  • Append rows — add up to 50 rows at a time
  • Insert rows — insert up to 50 rows at a specific position
  • Update a row — write values into a specific row, from column A on. An empty value clears its cell, and the cells after the last value given stay as they are.
  • Delete rows — remove a range of rows
  • Read data — read all rows, or a range of rows
  • Add a worksheet — add a new worksheet (tab) to a spreadsheet
  • Delete a worksheet — remove a worksheet from a spreadsheet. The last worksheet can't be deleted.
  • Rename a worksheet — give a worksheet a new name
  • Delete a spreadsheet — move a spreadsheet to the Google Drive trash. The AI is told to do this only when you ask for it, and there is no confirmation step. You can restore it from the trash within 30 days, after which Google deletes it permanently.

Row operations work on the first worksheet unless you name another one.

When Find rows or Add or update rows match keys, they ignore case and extra spaces. URLs also match when they differ only in http or https, a leading www., a #fragment or trailing slashes.

Working on your own spreadsheet​

BrowseWiz can work on a Google Sheets spreadsheet you already have, once you give it access to that one file:

  1. Ask BrowseWiz to work on it: paste its docs.google.com/spreadsheets link, or say its name. With the spreadsheet open in the active tab, you can also say "this spreadsheet".
  2. The chat shows "BrowseWiz needs access to your spreadsheet …". Click Choose in Google.
  3. A BrowseWiz page with Google's picker opens in a new tab. Select the spreadsheet and click Select.
  4. The tab closes, and BrowseWiz goes on with your request in the same chat.

For "this spreadsheet", the chat first shows "BrowseWiz wants to work on docs.google.com in this tab: …". Click Allow for this chat to let it read the address and work on that tab and on docs.google.com without asking for the rest of the chat (the same as approving a browser agent card with Also approve later steps on docs.google.com this chat ticked; see Tab access), or Deny to name the spreadsheet yourself. It doesn't ask when your browser agent settings already approve the site. When you ask BrowseWiz to extract data from websites into "this spreadsheet", it first recommends a new spreadsheet: that keeps the extracted rows apart from your own data, and a spreadsheet created moments ago may not show in Google's picker yet. It then asks which one to use.

BrowseWiz gets access only to the spreadsheet you select, and keeps it: next time it lists that spreadsheet with its own, also for plans and scheduled tasks. Click Cancel on the card or in the picker, or close the tab, to give no access; BrowseWiz then doesn't ask again unless you do. To take the access back, remove BrowseWiz from the third-party connections in your Google Account.

You need to be signed in to Google in BrowseWiz (see Google sign-in). The request works only in a side panel chat: a scheduled task, or Claude Code, can't show the card, so give access from the side panel first.

Opening the spreadsheet from the chat​

As soon as the AI reads or writes a spreadsheet in a chat, a chip with the spreadsheet's name appears above the chat input. Click it to open the spreadsheet in Google Sheets and watch it fill while the AI works: if the spreadsheet is already open in a tab, BrowseWiz switches to that tab instead of opening another one. A dot on the chip pulses while the AI is still working.

The chip shows the spreadsheet the AI last changed, or the one it last read if it changed none. When the chat has used several spreadsheets, the chip also shows how many: click the number to list them all, each marked "edited" or "read", and pick one to open it.

The chip also shows when you open a finished scheduled task run from History, for the spreadsheets that run used. Since the chip links each spreadsheet, the AI leaves spreadsheet links out of its reply unless you ask for them.

Rules for written rows​

When the AI writes rows (append, insert, update, or add or update), these rules apply:

  • Dates must be written as YYYY-MM-DD, for example 2026-10-13. The AI converts dates from the page. If any cell holds a date in another form, the whole write is refused and nothing is written.
  • Source URL. Every row collected from web pages gets a Source URL cell with the address of the page or pages its values came from. If the sheet's header row has no "Source URL" column, the AI first adds one in the first empty header cell. In a sheet with that column, the cell must hold one or more http, https or file URLs, user-provided (for a row you dictated in chat) or model-provided (for a row you asked the AI to produce). A row with an empty Source URL cell or anything else there is refused, and nothing is written. When a row cites several pages, each URL goes on its own line in the cell, and each one is a clickable link. Values you give in chat for rows that already have a source, such as a new column, are added without changing their Source URL.
  • Values are copied word for word from the page. A value the page doesn't show is left blank, never filled in from the AI's own knowledge.
  • Column types. A typed column takes only values of its type: a plain number for number and currency columns, a YYYY-MM-DD date for date columns, and one or more http or https links for URL columns. Otherwise the whole write is refused and nothing is written. Numbers and amounts are written as numbers, so you can sum and sort them. Setting a type doesn't change the cells already in the column. Rows from a list read hold values as the page shows them, so in a number or currency column the number each value shows is written ("3 999,00 zł" as 3999). When a value there shows no number, several numbers, a multiplier ("1,5 mln", "£1.5m") or one separator that could be a decimal or a thousands mark ("1,299"), the whole write is refused. A list read with a date in another form than YYYY-MM-DD, in any column, is refused the same way. A bare "m" with no currency around it is read as metres: "75 m" is written as 75. A multiplier word BrowseWiz doesn't know is written as the bare number, so check a column of amounts written with words.
  • Numbers. A plain number such as 8.99 or -12 is written as a number in a column without a type too, so you can sum, sort and chart it. A number in such a column that looks like an ID stays text: one with a leading zero, such as the postcode 02134, or one longer than 15 digits. Text, date and URL columns keep every value as text. A number keeps no trailing zeros unless its column has a number format: 8.90 shows as 8.9, while currency columns show two decimals.
  • Plain text. Other values are written as plain text, so a formula is stored as text and isn't calculated.

Google sign-in​

The toolset needs access to your Google account. Turning on Spreadsheet tools in Options → Tools signs you in to Google right away, if you aren't signed in yet. While the toolset is on and you aren't signed in, Options → Tools also shows a "Sign in to Google" button next to it. If you haven't signed in, the first time the AI uses the toolset, the chat shows "To continue, you need to sign in to your Google account." Click "Sign in to Google", and BrowseWiz continues your request.

Example Use Cases​

  • Lead research — while you read a company's page or listing, have BrowseWiz add that company's published details (name, website, city) to your spreadsheet
  • Product research — list competition products with parameters in columns while browsing their pages
  • Job postings — collect job listing details from multiple pages into a single sheet
  • Reviews and places — organize reviews or interesting places found during research
  • Content curation — save article summaries, links, and metadata while browsing
caution

You choose which pages BrowseWiz reads and what you do with the data. Check that the site's terms allow it and that you have a legal basis under data-protection law before collecting details about people. Don't use BrowseWiz to copy all or a large part of a site's listings.

Tips​

  • Attach the active tab and ask BrowseWiz to extract relevant data into the spreadsheet
  • Combine with the Browser Use Agent to automate multi-page data collection
  • Define clear column names upfront for consistent data structure