index

How I automatically track all online expenses in spreadsheet

Lately, I’ve been tinkering with Google Apps Script. I wanted to build a spreadsheet add-on that can automatically collect all invoices from my Gmail inbox within a specific timeframe, and have those written in my expense tracker spreadsheet.

I decided to publish this script as open-source, along with the spreadsheet template so anyone can feel free to use this.

This add-on supports multi-currency.

Please note that you need an OpenAI API Key to use the add-on.

How to use

  1. Click “Open Gmail Invoice Parser” gmail invoice parser menu

  2. A sidebar will open. Fill in the “Start Date”, “End Date”, and also enter your OpenAI API Key. Your API Key is stored locally. Then click Process Invoices Wait till it’s done.

  3. Once it’s done, you can click Insert to Sheets to write the results in the active spreadsheet done alt text Or, you can also click Download CSV to download them as csv instead.

Google Sheets template.
Github

I hope you find the script and the spreadsheet useful.
Till next time, thanks for reading!