How to Automate Net Worth Updates in Google Sheets

There’s a particular kind of person who opens a net worth spreadsheet and thinks: “I could automate this.” If that’s you, this article is about what’s actually worth automating in Google Sheets - and what’s more trouble than it’s worth.

Track your wealth: The Net Worth Tracker includes pre-built calculation formulas - add GOOGLEFINANCE for live stock prices as described below.

The Automation Landscape

Not everything in a net worth tracker can - or should - be automated. The good news is that the parts causing the most friction are often the easiest to automate.

Stock and ETF prices are the clear winner here. GOOGLEFINANCE pulls live prices directly into your sheet, which means your entire investment portfolio can update itself every time you open the file. Currency conversions work the same way. Date calculations, progress percentages, and charts all recalculate automatically once the formulas are in place.

The partially automatable category is where things get interesting. Account aggregation through services like Tiller can pull bank balances automatically, but that requires a paid subscription and connecting your financial accounts to a third party. Property values can technically be scraped from Zillow or Redfin using Apps Script, but those scripts break whenever the site changes its layout - which happens often. Cryptocurrency prices are available through API endpoints, but the formats change frequently enough that maintaining the connection becomes a recurring chore.

Then there’s the stuff that simply requires manual entry: bank account balances (unless you use an aggregation service), private investments, personal property values, and most debt balances. Accepting this reality upfront saves a lot of frustration. The goal isn’t to eliminate all manual entry - it’s to eliminate the tedious parts so the manual entry that remains takes two minutes instead of twenty.

GOOGLEFINANCE: The One Automation Everyone Should Set Up

The single most impactful automation for most net worth trackers is GOOGLEFINANCE. At its simplest:

=GOOGLEFINANCE("AAPL")

That returns Apple’s current stock price. But the real power comes from building a portfolio table:

Enter your share counts once, and the portfolio value updates every time you open the sheet. For mutual funds, the syntax changes slightly - =GOOGLEFINANCE("MUTF:VTSAX") - though mutual fund data can be delayed or unavailable for some funds.

You can also pull historical prices for a specific date with =GOOGLEFINANCE("VTI","close",DATE(2026,3,1)), which is useful for recording month-end snapshots in a value log.

Date Functions and Conditional Formatting

These are small automations that add up. =TODAY() gives you the current date and recalculates every time the sheet opens. =TODAY()-LastUpdateDate tells you how many days since your last update - pair that with conditional formatting that turns cells red after 30 days, and you’ve built a visual nudge system that highlights stale data without any effort on your part.

Setting up conditional formatting takes about two minutes: select the date column, go to Format > Conditional formatting, enter the custom formula =TODAY()-A2>30, and set a red background. After that, the sheet quietly monitors itself.

The Calculations That Run Themselves

Net worth formulas are straightforward - =TotalAssets-TotalLiabilities - but the real value is in the derived calculations that update automatically alongside them.

Month-over-month change (=CurrentNetWorth-PreviousMonthNetWorth), percentage change (=(CurrentMonth-PreviousMonth)/ABS(PreviousMonth)), and year-over-year comparisons all recalculate every time the sheet opens. Once these formulas are in place, updating your net worth means typing in a few bank balances. Everything else happens on its own.

From our experience: We automate stock prices with GOOGLEFINANCE and let formulas handle all the derived calculations - but we deliberately enter bank balances, property values, and debt numbers by hand each month. That five-minute manual review is when we actually notice things: an account fee we forgot about, a loan balance dropping faster than expected, or savings that stalled. Full automation would have hidden those signals. - Stefan

Building a Reminder System (Because the Hard Part Is Showing Up)

The biggest challenge with any tracking system isn’t the math - it’s actually doing it. Automation handles the calculations, but someone still needs to enter the bank balances.

A basic Apps Script can check your last update date and send you an email reminder:

function checkUpdate() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var lastUpdate = sheet.getRange("A1").getValue();
  var today = new Date();
  var diff = (today - lastUpdate) / (1000 * 60 * 60 * 24);

  if (diff > 30) {
    MailApp.sendEmail("you@email.com", "Net Worth Update Reminder",
      "It's been " + Math.floor(diff) + " days since your last update.");
  }
}

Set this to run on a time-driven trigger (Edit > Current project’s triggers > Add trigger) and pick a monthly schedule. It takes five minutes to set up, and it solves the most common reason people stop tracking: they simply forget.

Third-Party Integrations: The Cost of Full Automation

If you want bank balances to update automatically, you’re looking at third-party tools. Tiller Money connects to bank and credit card accounts and imports transactions directly into Google Sheets, updating balances daily. Plaid-based solutions offer similar functionality through different interfaces.

These tools work. But they add cost (Tiller runs about $79/year), require connecting your financial accounts to another service, and introduce a dependency that can break. Some people find the trade-off worthwhile. Others prefer the two minutes of manual entry each month, knowing they don’t depend on anything that might change its pricing, API, or privacy policy.

A middle ground: download account statements as CSV files and import them into Google Sheets. It’s semi-automated - you still need to do the download - but it avoids ongoing subscriptions and account connections.

Property and Crypto: Where Automation Gets Questionable

Property values change slowly. A house that was worth $350,000 last quarter is probably worth something close to that this quarter. Checking Zillow or Redfin once every three to six months and typing in a number takes less time than building and maintaining a web scraping script that will break the next time the site updates its HTML structure. Manual entry wins here.

Cryptocurrency is a similar story. GOOGLEFINANCE doesn’t reliably track crypto. You can use =IMPORTDATA() with various API endpoints, but availability and formats change frequently. For most people holding crypto as part of a larger portfolio, a monthly manual update is simpler than maintaining automation that needs periodic fixing.

The pattern is clear: automate things that change frequently and have reliable data sources (stock prices). Accept manual entry for things that change slowly (property) or have unreliable data sources (crypto).

Designing the Dashboard

A well-designed net worth dashboard separates what updates automatically from what needs your input. Put the investment portfolio - with its GOOGLEFINANCE formulas - in one section. Put bank balances, property values, and debt balances in another section, clearly marked as manual entry. Add a “Last Updated” cell with =NOW() so you can see when the sheet last recalculated.

The automated section stays current without effort. The manual section is clearly marked and takes a few minutes to update. The combination creates something sustainable - which matters more than creating something that’s fully automated but fragile.

When to Stop Automating

There’s a temptation to automate everything. Resist it. Every automation adds complexity, and complexity means more things that can break. A GOOGLEFINANCE formula that stops working is a minor inconvenience. An Apps Script that scrapes property values from a website that changed its layout three months ago, silently returning stale data, is a subtle problem you might not catch.

Automate what’s easy and reliable: stock prices, calculations, date functions, conditional formatting. Accept manual entry for everything else. The goal is a tracking system you’ll actually maintain for years, not one that’s impressively automated for three months before something breaks and you abandon the whole thing.

Related

• Net Worth Tracking for Beginners
• Financial Planning Template - Automated projections for long-term goals
• Net Worth Tracker - Pre-built automation
• Tracking Investments in Net Worth Spreadsheet
• Google Sheets Formulas for Budgeting
• How Often to Calculate Net Worth