Month-end accounting document check
Checks the month's expected documents and drafts a mail to the accountant. This n8n template mirrors a Dropbox accounting archive into Google Drive and checks each month for the documents you expect. It reads the first pages of PDFs, asks an OpenAI model to classify each document's type, period, issuer and confidence, and compares the result with rules stored in n8n Data Tables. It then emails you a checklist of missing or doubtful items and, once the month is complete, creates a Gmail draft to your accountant with a document index. Its emails are written in Italian, for an Italian accountant.
Steps
- Trigger: Runs on schedules or manually
Daily at 07:50, and on the 5th and 12th at 09:00. - Mirrors recent Dropbox months to Google DriveGoogle Drive
Creates missing year/month folders, uploads new files. - Reads expected document rules from data Tables
- Lists Dropbox folders, selects new or changed filesDropbox
- OpenAI classifies each candidate fileOpenAI
Document type, period, issuer, confidence. - Output: Emails you the checklist via GmailGmail
And a Gmail draft to the accountant when the month is complete. - Output: Stores month status in n8n data Tables
In live mode.
Limits
- Emails are in Italian on purpose.
What it does well
- Nothing on Drive is ever overwritten or deleted.
- The accountant mail is a Gmail draft.
Before you import
You need: Dropbox, Google Drive, Gmail and OpenAI accounts.
Similar templates
Scanned invoices to Sheets via OCR
Also for invoicing and payments, 6 steps.
Route scanned invoices by company
Also for invoicing and payments, 5 steps.
Overdue invoice reminders in Gmail
Also for invoicing and payments, 7 steps.
Gmail and OpenAI: 29 templates compared
Same two apps, different steps.
Gmail and Google Drive: 12 templates compared
Same two apps, different steps.
Google Drive and OpenAI: 11 templates compared
Same two apps, different steps.
Send a recurring summary
Other templates that do this task.