Problem: Business owners get invoices and receipts as PDFs and phone photos, then waste hours typing vendor names, dates, tax and totals into a sheet. Mistakes and missed bills follow.
What I built: An automation where the owner drops an invoice or receipt into a Google Drive folder. AI reads it, the details are saved as one row in Google Sheets, and an alert is sent to Discord. Unclear or blurry files are marked NEEDS REVIEW in red, so a human checks them before anyone trusts the numbers. Finished files move to a Processed folder, so nothing is entered twice.
Tools: n8n, Google Drive, Google Sheets, Google Gemini AI, Discord, custom JavaScript.
Outcome: Working demo, tested with sample invoices and receipts. A clean PDF invoice was read correctly (vendor, invoice number, dates, tax, total, category), and a blurry receipt was flagged for human review. No real client data was used.
For the tax document checklist, I'd match uploads to both the client and tax period before marking an item complete. How do you handle a client uploading last year's statement or a replacement after the checklist has already cleared?
An AI workflow that reads every incoming email, sorts it into 6 categories, and takes the right action automatically.
The problem: businesses lose time and leads because customer emails are mixed with promotions, job alerts, and security emails.
What I built:
Gmail Trigger that picks up each new email
AI Text Classifier (Google Gemini) with 6 categories: Security Alert, Promotions, Jobs, Personal, Payments, and Client Inquiries
Automatic Gmail labels for every category
Google Sheets log for jobs, leads, and payments
AI information extraction for client emails (name, phone, service, budget)
AI-written reply drafts for client emails, saved as drafts so a person approves every reply
Instant Discord alerts for security, payment, and client emails
Tools: n8n, Google Gemini, Gmail, Google Sheets, Discord
This project is a working demo built on my own inbox. The same system can be adapted to any business email, such as travel agencies, event venues, stores, recruiters, and consultants.