Install the Google Sheets Add-in
Install the add-on from the Google Workspace Marketplace, sign in, and pull your first live number into a cell.
Setup takes about two minutes: install, sign in, type a formula.
Install from the Marketplace
- Open the Spreadsheets hub and click the Google Sheets card — a guided setup opens with a one-click install link to the add-on's listing on the Google Workspace Marketplace (or search the Marketplace for "Dividend Data").
- Click Install on the listing and approve the standard Google permissions prompt.
- Open any Google Sheet — new or existing — and find the add-on under Extensions → Dividend Data.
Sign in and Connect
Open the sidebar from the Extensions menu and sign in with the same email you use for your Terminal account. Your account is keyed by email — same email means your plan, functions, and credit pool connect automatically. There is no API key to paste.
Your First Formula
In any cell, type:
=DIVIDENDDATA_DIVIDENDS("AAPL", "fwd_yield")
Apple's forward dividend yield appears in the cell within a moment. Google Sheets uses the underscore syntax — every function is =DIVIDENDDATA_NAME(...). Try a table next:
=DIVIDENDDATA_DIVIDENDS("KO", "history", TRUE)
That spills Coca-Cola's full dividend payment history, with headers, from a single cell.
Where to Go Next
The Functions tab on the Spreadsheets hub is the full reference: every function, its parameters, copy-paste examples, and a Formula Builder that assembles the syntax for you. When you'd rather not type at all, the add-on sidebar's Quick Actions load a full data table in one click.
For what each function does and how credits are spent, see Functions, Credits, and Examples.