Turn receipts and invoices into expense rows
Reads each receipt or invoice you link, pulls out supplier, date, total and tax, and adds a row to your expenses sheet.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1Google SheetsRead rowsReads the Source link column of both tabs first, so a receipt already recorded or already waiting for review is not read again.
For each
rawLink- 2Google SheetsAppend rowAppends a row of supplier, date, number, total, tax and currency to 'Expenses', or to 'Needs review' with the reason.
- 2
How it works
What happens on each run, in plain English.
Paste the links to a batch of receipts and invoices and run it. Each file is read, its supplier, date, invoice number, total, tax and currency are pulled out, and a row is added to your 'Expenses' tab.
Values are written exactly as they were read, so nothing becomes a formula or a reinterpreted date. A wrong figure costs more than a missing row, so it refuses to guess: if no supplier, date or total could be read, or the reader was not confident, the row goes to a 'Needs review' tab with a last column saying what is wrong. A figure not found is left blank rather than written as zero. Links already on either tab are skipped, so you can add receipts to the list and run it again. A file that cannot be opened is named in the run's result and tried again next time, and the rest of the batch still goes through.
You need an OpenAI connection (it reads the receipts) and a Google Sheets connection, a spreadsheet with an 'Expenses' tab and a 'Needs review' tab headed for the columns the rows fill, its link, and the receipt links - each must open the file itself without signing in.
You may also be interested in
File emailed documents and log what they sayFiles every document that arrives by email into Box and records what it says as a row on your register.
Never miss a filing or renewal deadlineChecks your deadline sheet each morning and emails you as each licence, permit, tax filing or renewal comes due, with a calendar event.
Email last month's profit and loss for each departmentOn the 3rd of each month, emails you last month's profit and loss for each department, or for the whole business, with AI commentary.
Verify the vendor behind a bank or card lineThe engine behind the bank-line checks: finds who a feed line was paid to, what they do and what it was likely for, or says it could not.Start from a workflow that already works.
Add "Turn receipts and invoices into expense rows" to your workspace, connect its apps, and make it yours.
Free plan, no credit card