Vanguard
Google Sheets logo
Beam

Connect Vanguard to Google Sheets

Automatically sync your portfolio balances and trades to a Google Sheets spreadsheet.

Get started
Secure read-only connectionSimple per-connection pricing

Features

From

Vanguard

  • Secure read-only connection with automatic portfolio syncing
  • Account balances, holdings, and positions
  • Trade history, dividends, and corporate actions

To

Google Sheets

  • Keep a spreadsheet up to date automatically with bank sync
  • Choose exactly which transaction fields appear as columns
  • Track current and historical balances on dedicated tabs
  • Data syncs as real numbers and dates, ready for formulas and pivot tables
  • Enrich transactions with clean merchant names, logos, and more (Pro)

Setup

How it works

Step 01

Connect securely

Log in through Vanguard's own authentication flow. Synci never sees or stores your credentials.

Step 02

Pick accounts

Choose which Vanguard accounts you want to sync.

Step 03

Link to Google Sheets

Step 04

Sync automatically

Balances, holdings, and trades flow from Vanguard to Google Sheets from that point on.

Get started

FAQ

Frequently asked questions

How often does Vanguard sync to Google Sheets?
Synci polls Vanguard for new data every 30 to 360 minutes, depending on your plan. When new balances, holdings, or trades are found, they are transferred to Google Sheets within seconds.
What gets synced from Vanguard to Google Sheets?
Account balances, holdings, and historical trades — including dividends and corporate actions where available. You control which Vanguard accounts sync, and rules can transform data before it reaches Google Sheets.
Is my Vanguard login shared with Synci?
No. Synci connects to Vanguard through a secure data provider, which means authentication happens on Vanguard's own login flow. Your login credentials are never shared with or stored by Synci.
Which provider does Synci use to connect to Vanguard?
Synci currently connects to Vanguard through SnapTrade, a secure data provider. Providers handle the technical connection to the brokerage — your login credentials stay between you and Vanguard.