Generate Invoices, Save to Drive and Send Email to Customer with JS + G Sheets โ€” n8n Workflow

Gemiddeld complexiteit๐Ÿ”— Webhook11 knooppunten๐Ÿท๏ธ Invoice Processing๐Ÿ‘ 4,477 weergavendoor Joseph

Overzicht

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

Trigger (Webhook) Starts when an order form is submitted, capturing customer and order details.

Generate Random Order ID A Function node creates a unique alphanumeric invoice ID (e.g., INV-X92B7D).

Check for Duplicate Order ID Google Sheets looks up the generate

Gebruikte knooppunten

Send EmailGoogle SheetsHTTP RequestGoogle DriveCode

Workflow-voorvertoning

Pinned Data to Simulate Webhook Query
โšก
W
Webhook Simulator
Generate Invoice ID
Check if ID Already Exists
I
If Does not Exist
S
Set Fields
Create Invoice HTML
HTML to PDF
Upload PDF to GDrive
Email Invoice to Customer
Append Details to Invoicโ€ฆ
Download PDF from API
11 nodes11 edges

Hoe het werkt

  1. 1

    Trigger

    De workflow start met een webhook-trigger.

  2. 2

    Verwerking

    Gegevens stromen door 11 knooppunten, connecting code, emailsend, googledrive.

  3. 3

    Uitvoer

    De workflow voltooit zijn automatisering en levert het resultaat aan de geconfigureerde bestemming.

Knooppuntdetails (11)

SE

Send Email

emailSend

#1
GO

Google Sheets

googleSheets

#2
HT

HTTP Request

httpRequest

#3
GO

Google Drive

googleDrive

#4
CO

Code

code

#5

Hoe deze workflow te importeren

  1. 1Klik op de knop JSON downloaden rechts om het workflowbestand op te slaan.
  2. 2Open uw n8n-instantie. Ga naar Workflows โ†’ Nieuw โ†’ Importeren uit bestand.
  3. 3Selecteer het gedownloade bestand generate-invoices-save-to-drive-and-send-email-to-customer-with-js-g-sheets en klik op Importeren.
  4. 4Stel inloggegevens in voor elk serviceknooppunt (API-sleutels, OAuth, enz.).
  5. 5Klik op Workflow testen om te controleren of alles werkt, activeer het vervolgens.

Of plak rechtstreeks in n8n โ†’ Importeren uit JSON:

{ "name": "Generate Invoices, Save to Drive and Send Email to Customer with JS + G Sheets", "nodes": [...], ...}

Integraties

codeemailsendgoogledrivegooglesheetshttprequestifsetwebhook

Haal deze workflow op

Download en importeer met รฉรฉn klik

JSON downloadenBekijken op n8n.io
Knooppunten11
Complexiteitmedium
Triggerwebhook
Weergaven4,477

Gemaakt door

Joseph

Joseph

@mjomba

Tags

codeemailsendgoogledrivegooglesheetshttprequestifsetwebhook
โšก

Nieuw bij n8n?

n8n is een gratis open-source workflow-automatiseringstool. Host het zelf of gebruik de cloudversie.

n8n gratis ophalen โ†’

Related Invoice Processing Workflows

COCOEMEX+5
medium

Automate Custom QuickBooks Invoice PDFs & Email with n8n

Standard accounting templates often fail to reflect a premium brand identity. This sophisticated n8n workflow bridges the gap between financial record-keeping and professional client presentation. By moving beyond the native limitations of QuickBooks Online, this automation enables businesses to generate high-end, multi-page PDF invoices that align perfectly with their corporate styling. The process begins the moment a new invoice is generated in QuickBooks, triggering a webhook that captures real-time billing data. The workflow then utilizes advanced HTML-to-File conversion and custom Code nodes to structure data into a polished, branded layout. It handles complex logic such as line-item merging and multi-page formatting automatically. Once the document is rendered, the system bypasses generic 'no-reply' senders by routing the finalized PDF through your preferred email provider. This ensures a seamless, white-labeled experience for your clients while eliminating the manual overhead of exporting, styling, and attaching files. Ideal for agencies and service providers, this flow guarantees that your most frequent touchpointโ€”the billโ€”is as professional as your work. **Common Use Cases:** - High-end creative agencies requiring bespoke, white-labeled billing documents for premium clients. - Automated recurring subscription billing where custom tax disclosures or localized branding are required. - Service-based businesses needing to attach dynamic project reports or terms of service directly to QuickBooks invoices.

๐Ÿ”— Webhookยท12 nodes