Generate invoices, save to Drive and send email to customer with JS + G Sheets
This workflow automates invoice generation from form submissions, ensuring unique order IDs, creating PDF invoices, storing files, emailing customers, and logging invoice data — all seamlessly integrated. --- 🔹 Workf...
Template notes
This workflow automates invoice generation from form submissions, ensuring unique order IDs, creating PDF invoices, storing files, emailing customers, and logging invoice data — all seamlessly integrated.
---
🔹 Workflow Overview
1. Trigger (Webhook) Starts when an order form is submitted, capturing customer and order details.
2. Generate Random Order ID A Function node creates a unique alphanumeric invoice ID (e.g., INV-X92B7D).
3. Check for Duplicate Order ID Google Sheets looks up the generated order ID in your invoice log sheet to prevent duplicates.
4. Conditional Check (IF Node)
If the ID already exists → regenerates a new ID (loops back) If unique → proceeds to invoice creation