Automate Email Expense Tracking with Claude for Chrome

In this guide, you’ll learn how to track and label expenses from Gmail into Google Sheets in a couple of minutes using Claude for Chrome. You’ll produce a populated expense-tracking sheet and use Claude as a personal assistant without building complex automation chains.

  • Beginner
  • 3 steps
  • 1 resource
  • By The Rundown University

Rundown Pro

Every course and recording, the certification program and member perks, for $29 a month. Guides stay free.

Go Pro for $29

Resources 1

Keep a PDF copy to follow offline or share with your team.

Unlock with Pro

$29 a month, cancel anytime

Step by step 3 steps

  1. Step 1 of 3

    Set up Claude for Chrome

    Install Claude for Chrome from the Chrome Web Store.

    01_claude_chrome_store

  2. Step 2 of 3

    Create your Google Sheet

    Create a Google Sheet with the headers you want Claude to populate. In this example, use: Expense Title, Company, Amount, Date, and Renewal Date.

    Pro tip: You can add other headers like “Category” or “Reimbursable?” and Claude for Chrome will fill them out.
    02_sheetheaders

    Copy the link to your Google Sheet. You’ll use it in the next step.

  3. Step 3 of 3

    Prompt Claude to process receipts

    In a new Chrome tab, click Extensions → Claude.

    03_open_extension

    You should see your current tab highlighted. This means Claude can perform work in the tab. Any tabs Claude opens will also be highlighted.

    04_active_tab

    Paste the following prompt into the Claude for Chrome chat box. Make sure you add your Google Sheet link.

    Look through my Gmail inbox and find all software subscription receipts from [Month + Year].
    
    I have a Google Sheet already created at [YOUR GOOGLE SHEET URL HERE] with headers: Expense Title, Company, Amount, Date, Renewal Date. Navigate to it and fill in each row with the extracted information from the receipts. Add a total row at the bottom.
    
    For each email you process: add the “receipt” label to any receipts or subscription sign-ups, and archive everything else that isn’t a receipt, including marketing emails and newsletters.

    Let Claude work for 10–15 minutes. You may have to prompt it to continue if you have a lot of emails.

That's the whole workflow

Mark it complete to keep your progress. The background follows.

Go further with Claude

This Rundown Pro recording covers the same tool or topic as this guide.

$29/mo, cancel anytime

Background and context

Who This Is Useful For

  • Small business owners
  • Freelance consultants
  • Anyone with monthly expense reports

What You Will Build

You’ll build a reusable Claude for Chrome workflow that finds software subscription receipts in Gmail, labels relevant emails, archives non-receipts, and fills a Google Sheet with expense details.

  • A Google Sheet with expense headers such as Expense Title, Company, Amount, Date, and Renewal Date
  • Rows populated from software subscription receipts
  • A total row at the bottom of the sheet
  • A repeatable prompt you can reuse for future months
01_claude_chrome_expenses_what_you_will_build

What You Need

  • Claude account, pro or above
  • Claude for Chrome extension
  • Google Chrome desktop app
  • Google Sheets
  • Access to the Gmail inbox you want Claude to search
  • A month and year to search for software subscription receipts

Going Further

  • Save your prompt as a shortcut by typing / and selecting “Create shortcut.” You can keep using the same Google Sheet and tell Claude which month to run each time you use it.
  • Once you have a shortcut set up, you can have it run daily or weekly on a schedule.
05_going_further