Automatically generate an Invoice PDF from Google Sheets data with DocuPotion
Automatically generate an Invoice PDF from Google Sheets data with DocuPotion How it works This workflow automatically generates a branded PDF invoice from data in Google Sheets and saves it to Google Drive. No manual document editing required. It's triggered when you update the status column of any row in your invoices sheet to Active. From there it: Fetches all line items for that invoice from a separate "line items" tab (matched by invoice_number) Aggregates the line items and calculates the total Generates a PDF using your DocuPotion invoice template, with customer details and line items merged in Uploads the PDF to your Google Drive, named Invoice-{invoice_number}.pdf Writes the PDF link back to the invoice row and updates its status to Sent The workflow loops over invoices, so you can flip multiple rows to Active at once and each will be processed independently. Polling runs every minute (but you can change this to whatever frequency you want). What you'll need A Google account (Sheets + Drive) A DocuPotion account with an invoice template configured The DocuPotion community node installed in your n8n instance Set up steps 1. Copy the demo Google Sheet 👉 Demo invoice Sheet Open the link and go to File → Make a copy. This gives you a Sheet with the correct structure: invoices** tab: invoice_number, invoice_date, due_date, status, customer_name, customer_email, customer_company, customer_address, pdf_url line items** tab: invoice_number, description, quantity, unit_price 2. Install the DocuPotion community node In n8n, go to Settings → Community Nodes → Install and enter 'DocuPotion'. 3. Create your DocuPotion invoice template Log into DocuPotion and create a template for your invoice layout. The workflow passes these merge fields to the template: invoice_number, invoice_date, due_date, customer_name, customer_company, customer_address, customer_email, total, and line_items[] (an array where each item has description, quantity, unit_price). Note the template ID from DocuPotion — you'll need it in step 5. 4. Connect credentials Import this workflow into n8n, then connect credentials for: Google Sheets (used by the trigger and two action nodes) Google Drive DocuPotion 5. Point the workflow at your resources In all three Google Sheets nodes (Invoice Status Updated to Active, Get Invoice Items, Add Link to Google Sheet), replace the document ID with your copied Sheet's ID. In the Generate PDF node, replace the template ID with your DocuPotion template ID. Optionally, in Upload to Google Drive, change the destination folder from root to a subfolder like /Invoices. 6. Activate and test Turn on the workflow. Then in your invoices Sheet, change the status of a sample row to Active. Within a minute, you should see: A new PDF in your Drive The pdf_url column populated The status column updated to Sent Customisation ideas Email the PDF:** add a Gmail node after Upload to Google Drive to send the invoice to customer_email automatically. Different statuses:** change the filter to trigger on a custom status like Approved or Ready to send. Branded filename:** edit the filename expression in Upload to Google Drive to include company name or date. Faster polling:** change the trigger from "every minute" to a shorter interval if you're on self-hosted n8n. An n8n automation workflow template by Alex Cooney.
Alex Cooney
web
free
Others in the same category, ranked by how often they are opened.
