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)
  • 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.
  • 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.
  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.

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.
  • 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.
  • 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 generation — browse a conference attendee list or LinkedIn profiles and have BrowseWiz extract contact details into a 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

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
Last updated on