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.

n8nRead on 2026-11-167 steps

Steps

  1. Trigger: Runs on schedules or manually
    Daily at 07:50, and on the 5th and 12th at 09:00.
  2. Mirrors recent Dropbox months to Google DriveGoogle Drive
    Creates missing year/month folders, uploads new files.
  3. Reads expected document rules from data Tables
  4. Lists Dropbox folders, selects new or changed filesDropbox
  5. OpenAI classifies each candidate fileOpenAI
    Document type, period, issuer, confidence.
  6. Output: Emails you the checklist via GmailGmail
    And a Gmail draft to the accountant when the month is complete.
  7. 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