Send Invoice on Project Validated

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "name": "Send Invoice on Project Validated",
  "nodes": [
    {
      "parameters": {
        "httpMethod": "POST",
        "path": "webhook/project-validated",
        "responseMode": "onReceived"
      },
      "name": "Webhook Trigger",
      "type": "n8n-nodes-base.webhook",
      "typeVersion": 1,
      "position": [
        250,
        300
      ]
    },
    {
      "parameters": {
        "requestMethod": "GET",
        "url": "=\"http://project-service:8082/api/projects/\" + $node[\"Webhook Trigger\"].json[\"projectId\"] + \"/invoice\"",
        "responseFormat": "json",
        "jsonParseResponse": true
      },
      "name": "Get Invoice Metadata",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 1,
      "position": [
        520,
        300
      ]
    },
    {
      "parameters": {
        "requestMethod": "GET",
        "url": "={{$json[\"pdfUrl\"]}}",
        "responseFormat": "file",
        "binaryPropertyName": "invoicePdf"
      },
      "name": "Download PDF",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 1,
      "position": [
        780,
        300
      ]
    },
    {
      "parameters": {
        "fromEmail": "invoices@yourcompany.com",
        "toEmail": "={{$node[\"Webhook Trigger\"].json[\"clientEmail\"]}}",
        "subject": "Votre facture pour le projet {{$node[\"Webhook Trigger\"].json[\"projectId\"]}}",
        "text": "Bonjour,\n\nVeuillez trouver ci-joint la facture pour votre projet.\n\nCordialement,\nL'\u00e9quipe",
        "attachment": [
          {
            "binaryProperty": "invoicePdf",
            "fileName": "invoice-{{$node[\"Webhook Trigger\"].json[\"projectId\"]}}.pdf"
          }
        ],
        "options": {}
      },
      "name": "Send Email",
      "type": "n8n-nodes-base.emailSend",
      "typeVersion": 1,
      "position": [
        1040,
        300
      ],
      "credentials": {
        "smtp": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "operation": "executeQuery",
        "query": "INSERT INTO invoice_logs(project_id, client_email, status, created_at) VALUES ('{{$node[\"Webhook Trigger\"].json[\"projectId\"]}}', '{{$node[\"Webhook Trigger\"].json[\"clientEmail\"]}}', 'sent', now())"
      },
      "name": "Log Sent Invoice",
      "type": "n8n-nodes-base.postgres",
      "typeVersion": 1,
      "position": [
        1280,
        300
      ],
      "credentials": {
        "postgres": {
          "name": "<your credential>"
        }
      }
    }
  ],
  "connections": {
    "Webhook Trigger": {
      "main": [
        [
          {
            "node": "Get Invoice Metadata",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Invoice Metadata": {
      "main": [
        [
          {
            "node": "Download PDF",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download PDF": {
      "main": [
        [
          {
            "node": "Send Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Email": {
      "main": [
        [
          {
            "node": "Log Sent Invoice",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": true,
  "settings": {},
  "id": "send-invoice-workflow"
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• postgres
• smtp

About this workflow

Send Invoice on Project Validated. Uses httpRequest, emailSend, postgres. Webhook trigger; 5 nodes.

Source: https://github.com/LouayJDAY/SolarEase/blob/cd6d5ac228ac2ca543e595701581cec250303743/.n8n/workflows/send-invoice.json — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.