What GOOGLEFINANCE returns
GOOGLEFINANCE is built into Google Sheets. Its form is =GOOGLEFINANCE(ticker, attribute, start_date, end_date, interval), and Google's help page asks for the exchange with the ticker, as in "NASDAQ:GOOG". For today it returns the price, the day's open, high, low and volume, market cap, P/E, EPS, the 52-week high and low, the change since the last close, beta and shares outstanding. With dates it returns a table of open, close, high, low and volume for each day or week.
Where GOOGLEFINANCE stops
There is no attribute for revenue, gross profit, operating cash flow, debt or any other line of a financial statement. The P/E and EPS it returns are single current figures, with no history by year or quarter.
Google's help page sets three more limits. Quotes may be delayed up to 20 minutes. The data is not for use by financial industry professionals. And historical data cannot be downloaded or read through the Sheets API or Apps Script; a script that tries gets #N/A in those cells.
How to add financial statements to Google Sheets
The SN Data add-on is listed on the Google Workspace Marketplace. Install it and allow it on your Google account, then make a free SN Data account and copy your key from your account page, under Data. It starts with sn_live_. In any sheet, open Extensions > SN Data > Your SN Data key, paste the key and press OK. The key is kept in your own Google account, so people you share the sheet with do not see it.
Then type a formula in any cell. =SN("AAPL", "revenue", 2025) returns 416161000000, Apple's revenue for fiscal 2025.
The =SN formula
=SN(ticker, figure, period, divisor). The ticker and the figure are needed. A figure goes by its id, such as gross_margin, or its name, such as "Gross margin"; Extensions > SN Data > List the figures puts every one on a new tab with how it is worked out. The period is a fiscal year, "TTM", "LY" for the latest year, "LQ" for the latest quarter, or a quarter such as "Q3 2026"; left out, it returns every year with the years as a header row. Percentages come as fractions, so a cell formatted as a percent reads 46.9%. The divisor turns money into millions with 1000000.
The ticker and the period can be ranges, so one formula fills a whole table: ten companies down and five years across from a single cell.
=SN("AAPL", "revenue", 2025)
=SN("AAPL", "Gross margin", "TTM")
=SN("MSFT", "Free cash flow", , 1000000)
=SN(A2:A11, "revenue", {2022,2023,2024,2025,2026})GOOGLEFINANCE and =SN in one sheet
The two formulas work side by side. GOOGLEFINANCE fills a price column, delayed as Google describes, and =SN() fills the reported figures beside it: revenue, margins, cash flow and returns by year or quarter. A sheet of 50 companies uses 50 SN Data calls however many figures each row shows, because one call brings every figure a company has and keeps it for 6 hours.
So in one sheet, GOOGLEFINANCE gives today's price and the =SN() formula gives what the company reported, line by line, from its 10-K and 10-Q filings.