Generate Invoices, Save to Drive & Email via G Sheets

This n8n workflow streamlines invoice automation starting with a webhook trigger that captures order form data including customer details, items, and totals. It generates a unique alphanumeric order ID (e.g., INV-X92B7D) using a JavaScript Function node, then checks for duplicates in a Google Sheets log via lookup. An IF node ensures uniqueness by looping back to regenerate if needed, preventing errors in high-volume scenarios.

Next, it prepares formatted invoice data with a Set node, converts HTML templates to PDF using a RapidAPI HTTP request, and uploads the PDF to Google Drive or Dropbox with a descriptive filename. The workflow then sends a personalized email to the customer attaching the PDF invoice, including the order ID in the subject and body for easy reference. Finally, it appends all details—customer info, ID, total, and PDF link—to Google Sheets for comprehensive tracking.

Benefits include time savings by eliminating manual invoicing, reduced errors via duplicate checks and automation, and centralized data logging for CRM integration. Ideal for e-commerce stores, freelancers, SaaS businesses, or any operation handling orders, it scales effortlessly with n8n's no-code power, supporting thousands of invoices monthly while integrating natively with Google services and email providers.