n8n Workflow: Generate Invoice PDFs to Google Drive

Turn invoice text into shareable PDF files in Google Drive—fully automated with n8n

This n8n sub-workflow takes plain-text invoice details, uses OpenAI to extract and normalize the invoice data, generates a styled A4 PDF via PDFCrowd, uploads it to a specified Google Drive folder, and returns a shareable Drive link—then clears working sheets so you can run again immediately.

What this workflow does

• Receives invoice details from a parent workflow.
• Extracts structured invoice fields using OpenAI from the free-form text. It uses a structured output parser that can retry and auto-fix malformed JSON.
• Adds company metadata and invoice date, mapping extracted values into the exact fields required by the invoice template.
• Builds a styled HTML invoice document from the structured fields.
• Generates a PDF with PDFCrowd by sending the HTML to the PDFCrowd API and producing an A4 PDF.
• Uploads the PDF to Google Drive in your chosen folder and returns a view URL.
• Prepares for the next run by clearing rows in the “Invoice Input” and “Invoice Output” tabs in Google Sheets.

Use cases

• Convert emailed or pasted invoice text into consistent PDFs and store them automatically in Google Drive.
• Speed up back-office operations by generating invoice documents without manual formatting.
• Centralize invoice PDFs per customer/project using a Drive folder workflow.

Technical details

• OpenAI: parses and structures invoice data with retry/repair for malformed JSON.
• PDFCrowd: renders the styled HTML invoice into an A4 PDF.
• Google Drive: uploads the generated PDF to YOUR_DRIVE_FOLDER_ID and returns a link.
• Google Sheets: clears “Invoice Input” and “Invoice Output” tabs using YOUR_GOOGLE_SHEET_ID.
• n8n nodes used: set, code, sticky note, Google Drive, HTTP Request, Google Sheets.

Perfect for n8n workflow automation engineers and SaaS operators who need reliable, repeatable invoice PDF generation with Google Drive storage.