Create numbered PDF invoices from Gmail with Claude, MintPDF, and Google Sheets

Description

Quick overview This workflow polls Gmail for invoice or order request emails, uses Anthropic Claude to extract structured billing details, validates totals, assigns a sequential invoice number from Google Sheets, generates a PDF with MintPDF, replies to the customer via Gmail, archives the PDF in Google Drive, and logs the invoice. How it works Polls Gmail every minute for unread emails with subjects matching invoice or order requests. Uses Anthropic Claude to extract the customer, billing details, and line items from the email into structured data. Validates required fields, currency, and calculates subtotal, tax, and total in integer cents, sending invalid or over-limit requests to a Google Sheets review tab and emailing the owner. Reads the existing invoice log in Google Sheets to skip already-invoiced emails, assign the next yearly invoice number, and generate escaped HTML for the invoice. Converts the HTML into an A4 PDF using MintPDF and emails the owner if rendering fails. Archives the PDF to Google Drive, replies to the original Gmail thread with the PDF attached, and appends the invoice details and Drive link to the Google Sheets invoice log. Setup Install the community node n8n-nodes-mintpdf and add a MintPDF API credential. Add credentials for Gmail, Google Sheets, Google Drive, and Anthropic (Claude) in n8n. Create a Google Sheets spreadsheet with Invoices and Review tabs and columns matching the fields appended by the workflow. In the Invoice settings, set your seller details, owner email, currency, tax rate, approval limit, payment terms, and update the Google Sheet ID and Google Drive folder ID. Requirements A MintPDF API key (free plan: 100 PDFs a month) Gmail, Google Sheets and Google Drive accounts An Anthropic API key (or swap in another chat model) Customization Change the invoice design in the "Number invoice and build HTML" node Set your tax rate, currency and approval limit in "Invoice settings" Replace Claude with OpenAI or Gemini. An n8n automation workflow template by Peter Hallander.

Community Metrics

Categories

• Automation
• AI

Tags

• n8n
• workflow
• google-sheets
• google-drive
• gmail
• code
• anthropic-chat-model
• information-extractor

Capabilities

• 6 nodes

Information