Back

Log invoices and receipts from my inbox to a sheet

Vendor, amount, and due date of every invoice or receipt you get, in one sheet

FoundersOpsAnalystsWhen a new email arrives
Prompt

A new email just arrived in my Gmail. Decide whether it's an invoice, receipt, or bill, either in the body or as an attached PDF. If it isn't, stop and do nothing. If it is, pull out: the vendor, invoice or receipt number, date, amount, currency, due date if there is one, and what it's for. Add a row to my sheet [sheet name or link] with those fields and a link to the email. If a row with the same vendor and invoice number already exists, don't add a duplicate. Don't pay, reply to, or forward anything. Tell me what you logged, and flag anything due in the next [7] days.

Works withmail.google.comsheets.google.com