DEV Community

Stackscale
Stackscale

Posted on

Sync Google Sheets Expenses to Notion Budget Tracker with Make (No Code)

Your expenses sit in Google Sheets while your Notion budget tracker stays empty. Learn how to build a notion budget tracker that syncs itself — Make watches your Sheets expense log and keeps Notion's monthly totals and budget remaining up to date.

This is the companion tutorial for the StackScale video above. No code, no live expenses, and no real spending — the whole flow runs on fictional November demo rows totalling $541.00 so you can test it safely.

What You Will Build

A Make scenario that watches your Google Sheets expense log and syncs every new or updated row into a Notion budget tracker, with monthly totals and budget remaining. November's fictional demo rows total $541.00 — Food & Drink $312.40, Transport $96.10, Software $58.00, Office $74.50 — against a monthly budget of $800.00, leaving $259.00. This is not logging receipts or extracting data — the amounts are already in your sheet. The new job is syncing them into Notion.

Prerequisites / Tools

  • A Make account (free plan is enough to start)
  • A Google Sheet with your expense log — one row per expense, with date, merchant, category, and amount
  • A free Notion workspace with a budget tracker database — one entry per category, a monthly budget figure, and two formula fields for the month total and budget remaining
  • Dummy expenses to test with — the fictional November rows used in the video

Disclosure: Some links below are affiliate links, meaning StackScale may earn a commission at no extra cost to you.

The Workflow

Make watches the expense log for a new or updated row, and the scenario starts the moment one changes. Make maps the row's fields into the Notion budget tracker, and Notion rolls each category up into a November month total of $541.00 and subtracts it from the $800.00 monthly budget — leaving $259.00. Both figures update with every sync.

Step 1: Build the Google Sheets Expense Log

Each row holds a date, a merchant, a category, and an amount. Keep the category names identical to the ones in your Notion tracker, because Make matches on those names. November's fictional demo rows total $541.00: Food & Drink $312.40, Transport $96.10, Software $58.00, and Office $74.50.

Step 2: Trigger on a New or Updated Row

In Make, set the scenario to watch the expense log for a new or updated row. A new expense or a corrected amount starts it — nothing syncs twice.

Step 3: Map the Fields into Notion

Map the fields into the Notion budget tracker (copy as-is):

{
  "Date": "expense date",
  "Merchant": "expense merchant",
  "Category": "expense category — must match the tracker category names exactly",
  "Amount": "expense amount",
  "Month total (Notion formula)": "sum of Amount for the month, per category — November demo total $541.00",
  "Budget remaining (Notion formula)": "Monthly budget − Month total — November demo: $800.00 − $541.00 = $259.00"
}
Enter fullscreen mode Exit fullscreen mode

Date goes to the date property, merchant to the name, category to the category select, and amount to the amount field. One row in Sheets becomes one synced entry in Notion.

Step 4: Monthly Totals and Budget Remaining in Notion

Let Notion do the maths. The tracker rolls each category up into a November month total of $541.00, and subtracts it from your $800.00 monthly budget — leaving $259.00. Both figures update with every sync.

Step 5: Test with the Dummy Data

Drop in the fictional November rows, then check the month total reads $541.00 and the remaining figure reads $259.00.

The Finished Result

Every expense synced, a November total of $541.00, and $259.00 left of an $800.00 budget — visible in Notion the moment the sheet changes.

One Honest Limit

The sync is only as good as the sheet — if a category name is misspelled in Sheets, it will not match the Notion tracker, and the row lands uncategorised or fails to sync. Keep your category names identical in both places. This tracks a budget, it does not replace an accountant.

Watch the Full Tutorial

The video at the top walks through the same five steps with the synthetic mockups. All mockups in the video are synthetic, created for this tutorial, with dummy data only — no real expense or account is shown, and no real account appears anywhere.

New automation tutorials every day on StackScale — subscribe on YouTube at https://www.youtube.com/@StackScaleHQ.

Top comments (0)