Use SheetsFinance AI
Ask SheetsFinance AI for data, a table, a model or a stock screen, or select cells and ask it to explain or fix them. It writes live SheetsFinance formulas into your sheet and asks before each edit unless you choose otherwise. To open it, see SheetsFinance AI.
Ask for data
Ask for a value or a table by name, such as "Show me Apple's P/E, ROE and net margin". The reply shows a preview card with the data and the exact formula behind it.
Select the cell where the data should start.
Click Insert at selection on the preview card.
The formula goes into your sheet and keeps refreshing like any other SheetsFinance formula.
Build tables, models and screens
Describe what you want, and name the companies, metrics and periods. For example:
"Build a 5-year margin comparison for AAPL, MSFT and GOOGL on a new sheet"
"Make a DCF model for NVDA with the ticker in a cell I can change"
"Screen US stocks with a P/E under 15 and a dividend yield over 3%"
It builds with live SF formulas and usually puts the ticker in an input cell, so you can change the company and the model recalculates. It can also add number formats, conditional formats and charts. Each edit appears as a card that says what will change.
Stock screens
The assistant adds two filters on its own, and the reply names every filter you didn't ask for, so you can ask it to remove one:
When you give only an upper limit on a valuation or payout ratio, such as "P/E under 15", it adds a floor above 0, so loss-making companies don't appear.
When you ask for US or American stocks, it limits the screen to the NYSE and NASDAQ, which leaves out NYSE American and OTC stocks.
Screen results can include preferred shares, funds and second share classes. For the full set of filters, see Stock Screener.
Explain and fix formulas
Select the cells first, then ask. SheetsFinance AI reads the formulas in the selection.
Explain: "Explain what the selected cell calculates", or "What do these numbers show?"
Fix: "Fix the formula in the selected cell". It finds the problem and offers a corrected formula as an edit card.
For errors that come from your account or the add-on rather than the formula, see Fix common spreadsheet errors.
Add a template
Ask for a common model, such as a WACC calculator or a dividend tracker, and SheetsFinance AI may suggest one of our published templates as a card. Click Add to sheet to insert it.
Choose how it edits
Pick a mode in the menu under the message box. Ask first is the default, and the add-on remembers Ask first or Auto-edit for your next chat.
Ask first
Each edit arrives as a card describing the change. Click Apply to write it, or Dismiss to skip it.
Auto-edit
Edits that only add new content are written straight away, without a card to approve. An edit that would replace cells that already have content still stops and asks: the card turns red, lists the cells it replaces, and waits for Replace and apply.
Allow overwrites
The assistant writes every edit straight away, including edits that replace existing cells. A banner stays at the top of the chat while it's on.
Allow overwrites lasts only for the open chat. When you start a new chat, the mode goes back to Ask first or Auto-edit, whichever you used last.
Undo an edit or stop a reply
Revert: click Revert on the latest applied edit to take everything it wrote or added back off the sheet.
Stop: click the stop button where the send button was to cancel a reply that's still running. Edits waiting for your approval count as dismissed.
Reopen or delete past chats
Chats are saved to your account for 90 days after their last message. Google Sheets and Excel keep separate lists.
Click Past chats at the top of the panel, then click a chat to reopen it.
Click the × next to a chat to delete it, or Delete all to delete every saved chat.
Click New chat to start fresh.
A long chat eventually fills up. When it does, the assistant asks you to start a new chat; click Start a new chat and carry on there.
Rate a reply
Click the thumbs up or thumbs down under a reply. After a thumbs down, tell us what went wrong in a few lines and click Send. We read this feedback to improve the assistant.
Get better results
Name the ticker, the metrics and the years or quarters you want.
Say where it should go: "on a new sheet" or "starting at B2".
Select the cells before asking about them.
Ask one thing at a time. SheetsFinance AI handles one message at a time per account, across Google Sheets and Excel.
Check figures before you rely on them. SheetsFinance AI is in Beta and can be wrong.
What's next
SheetsFinance AI credits: how much each plan includes each day
SheetsFinance AI privacy and limits: what is sent and what it can't do yet