AutomationFlowsEmail & Gmail › Automate Invoice Creation and Delivery with Google Sheets, Invoice Ninja and…

Automate Invoice Creation and Delivery with Google Sheets, Invoice Ninja and…

Original n8n title: Automate Invoice Creation and Delivery with Google Sheets, Invoice Ninja and Gmail

ByMarth - Business Automation @marth on n8n.io

This workflow automates the repetitive task of invoicing, turning a manual process into an efficient, hands-free operation.

Event trigger★★☆☆☆ complexity6 nodesGoogle Sheets TriggerHTTP RequestGmailGoogle Sheets
Email & Gmail Trigger: Event Nodes: 6 Complexity: ★★☆☆☆ Added:

This workflow corresponds to n8n.io template #6447 — we link there as the canonical source.

This workflow follows the Gmail → Google Sheets recipe pattern — see all workflows that pair these two integrations.

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 →

Download .json
{
  "id": "qclESQ5SPXlYdUS1",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Invoice Automation Workflow with Invoice NINJA",
  "tags": [],
  "nodes": [
    {
      "id": "1009fb50-b8fe-4949-8756-c61311d0ab1f",
      "name": "0. Google Sheets (Invoice Trigger)",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -112,
        64
      ],
      "parameters": {},
      "description": "Triggers when a project's status is changed to 'Ready for Invoice'.",
      "typeVersion": 1
    },
    {
      "id": "bba87058-2b13-4f63-8999-f45b43256ff5",
      "name": "1. HTTP Request (Create Invoice)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        144,
        64
      ],
      "parameters": {},
      "description": "Sends data to the invoicing service API to create a new invoice.",
      "typeVersion": 1
    },
    {
      "id": "adbca28b-bd7a-488d-86bd-8280be4cebb7",
      "name": "2. Gmail (Send Invoice)",
      "type": "n8n-nodes-base.gmail",
      "position": [
        400,
        64
      ],
      "parameters": {},
      "description": "Emails the newly created invoice to the client.",
      "typeVersion": 1
    },
    {
      "id": "029aee61-c444-4445-bd04-00ac3b86d708",
      "name": "3. Google Sheets (Update Status)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        640,
        64
      ],
      "parameters": {},
      "description": "Updates the project status to 'Invoiced' in Google Sheets.",
      "typeVersion": 3
    },
    {
      "id": "8d23368c-48fe-4752-a277-0d320b9045ae",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -192,
        0
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "33b56fca-b0c9-4c74-a17c-134aa775045c",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -192,
        304
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "0b42dd37-a3f4-4948-a9ae-1ec2550585a7",
  "connections": {
    "2. Gmail (Send Invoice)": {
      "main": [
        [
          {
            "node": "3. Google Sheets (Update Status)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1. HTTP Request (Create Invoice)": {
      "main": [
        [
          {
            "node": "2. Gmail (Send Invoice)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0. Google Sheets (Invoice Trigger)": {
      "main": [
        [
          {
            "node": "1. HTTP Request (Create Invoice)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This workflow automates the repetitive task of invoicing, turning a manual process into an efficient, hands-free operation.

Source: https://n8n.io/workflows/6447/ — original creator credit. Request a take-down →

More Email & Gmail workflows → · Browse all categories →

Related workflows

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

Email & Gmail

Automatically processes new orders added to Google Sheets. Small orders are approved instantly; large orders trigger an HTML email with one-click Approve / Reject links — each handled by an independen

Google Sheets Trigger, Google Sheets, Gmail +1
Email & Gmail

Fluidflow Licensing Framework. Uses httpRequest, xero, googleSheetsTrigger, slack. Event-driven trigger; 25 nodes.

HTTP Request, Xero, Google Sheets Trigger +4
Email & Gmail

This workflow monitors a Google Sheets billing queue, creates Mercado Pago payment links for new invoices, emails customers via Gmail, and logs sent links back to Google Sheets, while also handling Me

Google Sheets Trigger, @Mercadopago/N8N Nodes Mercadopago, HTTP Request +2
Email & Gmail

This workflow watches Google Sheets for new rows, renders a personalized video with iLoveVideoEditor using the row data, uploads the finished MP4 to Google Drive, writes the Drive link back to the sam

Google Sheets Trigger, N8N Nodes Ilovevideoeditor, HTTP Request +3
Email & Gmail

Hiring teams often struggle with document follow-ups, offer letter generation, and stakeholder communication. Manual checks, email back-and-forth, and missing files slow down hiring and create chaos d

Google Sheets Trigger, HTTP Request, Slack +3