Build Your Expense Report From Receipt Emails
For the expense report after a trip. DuckyHelper searches your inbox for receipts from those dates, reads each one, fills an expense sheet with date, vendor, amount and category, and saves the receipts to a Drive folder.
“Make an expense report for my Chicago trip, Nov 3 to 6, from receipt emails, with the receipts saved to Drive.”
- 01Learn the web APIs of Gmail and Google Sheets, first time onlyBuilt from each site's own buttons, forms and requests. Kept on your device and reused next time.
searchThreads(query)getAttachments(id)appendRows(sheet, rows)
- 02Find receipts from the trip dates
- 03Read the date, vendor and amount from each
- 04Fill the report sheet with categories
- 05Save the receipts to a Drive folder
You getReported the day you're back. A full report with every receipt saved. The next trip is one ask.
A run, drawn from this page · early access on Mac
Nothing to send, so it runs straight through.
Nothing in this job sends a message or pays for anything, so it works through to the end and tells you when it's done. If a step ever would, it's built to stop and ask you first.
If it hits a sign-in, you sign in yourself. It's built not to type your passwords or card numbers.
Before you ask it.
What do I say?
Press fn (Ctrl+Shift+Space on Windows and Linux) and ask out loud, in your own words, like "Make an expense report for my Chicago trip, Nov 3 to 6, from receipt emails, with the receipts saved to Drive."
Why is the second time faster?
The first time, it writes small JavaScript tools for Gmail, Google Sheets and Google Drive and builds an API from each site's own buttons, forms and requests. After that it calls them directly, so the job runs in one go instead of click by click. It costs less and breaks less.
Will it send anything without me?
It's built to ask first before it sends a message or pays for anything, and to wait for your yes. It may not recognize every send or payment, so keep an eye on tasks that involve messages or money. It's built not to type your passwords or card numbers: you sign in yourself, and it picks up from there.
Why not just do it by hand?
Receipts arrive as emails, PDFs and photos, and building the report means retyping every one.
Can I use this today?
Doing jobs in your apps is in early access on Mac. Talking to DuckyHelper, and having it see your screen and draw on it, works today on Mac, Windows and Linux.
- Early access
“Code this week's Brex transactions with our GL rules, add them to the Expense Ledger sheet and flag anything odd.”
Code a Week of Brex Expenses
See it run
- Early access
“Find overdue invoices in QuickBooks and draft a polite reminder for each, firmer for 30+ days late.”
Chase Overdue Invoices, Politely
See it run
- Early access
“Match this week's Stripe payouts to Xero bank lines and explain any gap over $50.”
Match Stripe Payouts to Xero
See it run
Do anything
Ask it a question or hand it a job, in any app.
Doing jobs for you is in early access on Mac. Asking works on Mac, Windows and Linux.