Connect Vanguard to Google Sheets
Connect Vanguard accounts to Google Sheets. Track your index funds, ETFs, and retirement portfolios with automatic position updates.
Auto-sync your Vanguard holdings into a Google Sheet with InvestSheet. 14-day free trial, $9.99/mo or $7.99/mo annual.
Install InvestSheetHow It Works
Install InvestSheet
Add from Google Workspace Marketplace in one click.
Connect via OAuth
Log in through Vanguard's official website — secure and read-only.
Use formulas
Pull live holdings into any cell with =IVS_BROKERAGE().
Available Formulas
=IVS_BROKERAGE("value")=IVS_BROKERAGE("price", "AAPL")=IVS_BROKERAGE("qty", "AAPL")=IVS_BROKERAGE("gainLoss", "AAPL")=IVS_BROKERAGE("name")Why Use InvestSheet with Vanguard
- No manual data entry — holdings sync automatically
- Read-only OAuth — cannot execute trades
- Track Vanguard alongside other brokerages in one sheet
- Custom formulas for price, quantity, gain/loss, and value
- Works with multi-account setups (IRA + taxable at same brokerage)
- 6-hour cache with auto-refresh on sheet open
Frequently Asked Questions
Can I connect my Vanguard account to Google Sheets?
Yes. InvestSheet connects Vanguard to Google Sheets via secure OAuth. Your holdings, positions, and values sync automatically — no manual data entry required.
Is it safe to link Vanguard to Google Sheets?
Yes. InvestSheet uses official Vanguard OAuth — you log in through Vanguard's website, not through the add-on. Your password is never stored. All connections are read-only; no trades can be executed. Data is encrypted at rest with AES-256-GCM.
What Vanguard data syncs to Google Sheets?
InvestSheet syncs your holdings with ticker, quantity, current price, total value, cost basis, and gain/loss. Use =IVS_BROKERAGE("value") for total portfolio value or =IVS_BROKERAGE("gainLoss", "AAPL") for position P&L.
Can I connect multiple Vanguard accounts?
Yes. InvestSheet supports multiple accounts at Vanguard — for example, a Roth IRA and a standard brokerage. Assign custom nicknames to each and filter formulas by account name.
How much does InvestSheet cost?
$9.99/month (monthly billing) or $7.99/month on the annual plan ($95.88/year). 14-day free trial. Cancel anytime.