Managed day-to-day bookkeiping in QuickBooks Online,including transaction categorization, bank reconciliation,account management and financial reporting. Maintainedaccurate and organized financial records to support
business operations and informed decision-making.
Invoice emails into a Google Sheet, automatically, every hour.
If you copy-paste invoices and receipts from Gmail into a spreadsheet, this one's for you. I built a small Google Apps Script that runs inside your own Google account. Each hour it finds new invoice and receipt emails and adds one row per email: date, vendor, invoice number, total, currency, due date and a link back to the email. PDFs get saved to a Drive folder.
Three rules I built it around:
1. Never guess. If the total isn't clearly labelled, the row is flagged "Needs review".
2. Never log the same email twice.
3. Read-only. It never changes or deletes your mail (it only adds one label).
The screenshot shows the output on 10 fictional sample emails. Spend by vendor and by month is on a Summary tab. Built with AI assistance and checked by hand.
A sales pipeline as a grid: every deal with company, rep, stage, close date, value, probability and last contact, plus hide fields, filter, group, sort and colour.
Presenting the pipeline as a grid instead of kanban makes stage, rep and value scannable in one pass, and the colour-coded stage pills — green Closed won, red Closed lost, yellow Negotiation — tell the story instantly. The Hide fields / Filter / Group / Sort toolbar is the cherry on top.