Archive unread Gmail receipts on a daily bookkeeping schedule
At a glance
This workflow processes unread messages carrying a receipt label, extracts financial fields with OpenAI, stores attachments in Drive, and marks processed messages as read. This workflow is listed under life, email, receipts, bookkeeping.
OCR and AI parse attached timesheets into month-specific billable hours, including weeks spanning months, before the workflow creates QuickBooks invoices and an audit sheet.
A self-hosted n8n template uses Mistral to structure chat-submitted expenses, archives receipt images in Drive, and links the resulting Google Sheets rows to the originals.
OpenAI categorizes submitted expenses and marks those needing approval, while the workflow records status in Sheets and sends managers details through Telegram and Gmail.
GPT-4o-mini summarizes resume PDFs linked from a candidate sheet, emails the interviewer a structured brief, and marks the row processed to avoid repeats.