Paid invoices into your bookkeeping sheet

Every paid Stripe invoice is recorded automatically, ready for your accountant.

Easy Saves ~5 hours/month Finance & AdminBy Flowngn team

Works with n8n · Make · Zapier

Get paid faster

How it works

Trigger: Stripe — invoice paid event

Receive the paid invoice event from Stripe.
Extract date, customer, amount, currency, tax and invoice PDF link.
Append a row to your bookkeeping sheet.

Diagram

Trigger App Logic

Build it

Pick your tool — same automation, step by step.

Copy and paste straight into an n8n canvas (Ctrl+V), or download and use Import from File. Then connect your own credentials and replace every YOUR_… placeholder.

Workflow JSON

Show code (149 lines)

{
  "name": "Paid invoices into your bookkeeping sheet (Flowngn)",
  "nodes": [
    {
      "parameters": {
        "content": "## Paid invoices into your bookkeeping sheet\nEvery paid Stripe invoice is recorded automatically, ready for your accountant.\n\n**Setup**\n1. Open each node and connect your own credentials.\n2. Replace every YOUR_… placeholder.\n3. Test once, then activate.\n\nFree template from Flowngn",
        "height": 260,
        "width": 340
      },
      "id": "458223d5-1673-42cd-a93b-ba83e310fb25",
      "name": "Setup notes",
      "type": "n8n-nodes-base.stickyNote",
      "typeVersion": 1,
      "position": [
        -420,
        -60
      ]
    },
    {
      "parameters": {
        "events": [
          "invoice.paid"
        ]
      },
      "id": "458223d5-1673-42cd-a93b-ba83e310fb25",
      "name": "Invoice paid",
      "type": "n8n-nodes-base.stripeTrigger",
      "typeVersion": 1,
      "position": [
        0,
        0
      ],
      "webhookId": "458223d5-1673-42cd-a93b-ba83e310fb25"
    },
    {
      "parameters": {
        "assignments": {
          "assignments": [
            {
              "id": "a1",
              "name": "date",
              "value": "={{ DateTime.fromSeconds($json.data.object.created).toISODate() }}",
              "type": "string"
            },
            {
              "id": "a2",
              "name": "customer",
              "value": "={{ $json.data.object.customer_email }}",
              "type": "string"
            },
            {
              "id": "a3",
              "name": "amount",
              "value": "={{ $json.data.object.amount_paid / 100 }}",
              "type": "number"
            },
            {
              "id": "a4",
              "name": "currency",
              "value": "={{ $json.data.object.currency.toUpperCase() }}",
              "type": "string"
            },
            {
              "id": "a5",
              "name": "tax",
              "value": "={{ ($json.data.object.tax || 0) / 100 }}",
              "type": "number"
            },
            {
              "id": "a6",
              "name": "invoice_pdf",
              "value": "={{ $json.data.object.invoice_pdf }}",
              "type": "string"
            }
          ]
        },
        "options": {}
      },
      "id": "458223d5-1673-42cd-a93b-ba83e310fb25",
      "name": "Pick invoice fields",
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [
        300,
        0
      ]
    },
    {
      "parameters": {
        "operation": "append",
        "documentId": {
          "__rl": true,
          "value": "YOUR_SPREADSHEET_ID",
          "mode": "id"
        },
        "sheetName": {
          "__rl": true,
          "value": "Invoices",
          "mode": "name"
        },
        "columns": {
          "mappingMode": "autoMapInputData",
          "value": {}
        },
        "options": {}
      },
      "id": "458223d5-1673-42cd-a93b-ba83e310fb25",
      "name": "Add to bookkeeping",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        600,
        0
      ]
    }
  ],
  "connections": {
    "Invoice paid": {
      "main": [
        [
          {
            "node": "Pick invoice fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Pick invoice fields": {
      "main": [
        [
          {
            "node": "Add to bookkeeping",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "meta": {
    "templateCredsSetupCompleted": false
  },
  "tags": []
}

Open in the playground to edit →

Tips

Stripe amounts are in cents — divide by 100 before saving.

Related flows

Finance & AdminEasy

Instant alert when a Stripe payment fails

Know about failed payments right away and log them for follow-up.

Stripe → Slack → Google Sheets2h/mo

Finance & AdminMedium

Weekly KPI report by email

Every Monday, get a short summary of last week's key numbers from your sheet.

Google Sheets → Gmail3h/mo

Finance & AdminMedium

Log expenses by texting a Telegram bot

Send "12.50 lunch" to your bot and it's saved to a Google Sheet instantly.

Telegram → Google Sheets3h/mo