@bilig/n8n-nodes-workpaper

This is a Bilig WorkPaper community node for n8n.

It gives an n8n workflow two spreadsheet-shaped operations:

1. run the hosted forecast proof for a no-setup smoke test;
2. send your own WorkPaper JSON document, apply cell edits, and read formula outputs back;
3. return before/after values plus proof that formula output changed and the exported WorkPaper JSON restores to the same result.

Use it when an n8n automation needs formula readback without driving Excel, LibreOffice, Google Sheets, or a browser spreadsheet UI.

Installation

Install the scoped community node package from n8n:

1. Open Settings -> Community nodes.
2. Choose Install a community node.
3. Enter:

@bilig/n8n-nodes-workpaper

Self-hosted n8n instances can also install it from npm:

npm install @bilig/n8n-nodes-workpaper

Do not install an unscoped n8n-nodes-workpaper package for Bilig. The scoped package is the canonical package name.

Operations

Forecast: Verify Formula Readback

Posts to:

POST https://bilig.proompteng.ai/api/workpaper/n8n/forecast

Default parameters:

{
  "sheetName": "Inputs",
  "address": "B3",
  "value": 0.4
}

WorkPaper JSON: Evaluate Document

Posts to:

POST https://bilig.proompteng.ai/api/workpaper/n8n/evaluate

Default request shape:

{
  "document": {
    "format": "bilig.headless.work-paper.document.v1",
    "sheets": [
      {
        "name": "Inputs",
        "content": [
          ["Metric", "Value"],
          ["Win rate", 0.25]
        ]
      },
      {
        "name": "Summary",
        "content": [
          ["Metric", "Value"],
          ["Expected customers", "=Inputs!B2*20"]
        ]
      }
    ],
    "namedExpressions": []
  },
  "edits": [
    {
      "cell": "Inputs!B2",
      "value": 0.4
    }
  ],
  "readCells": "Summary!B2",
  "includeUpdatedDocument": true
}

The response includes before, after, and restored readback records plus an updated WorkPaper document when includeUpdatedDocument is enabled.

The response includes:

{
  "verified": true,
  "editedCell": "Inputs!B3",
  "before": {
    "expectedArr": 60000
  },
  "after": {
    "expectedArr": 96000,
    "targetGap": 5600
  },
  "checks": {
    "formulasPersisted": true,
    "restoredMatchesAfter": true,
    "computedOutputChanged": true
  }
}

Credentials

No credentials are required for the public hosted demo endpoint.

Compatibility

Built with the official @n8n/node-cli scaffold. The node is a thin HTTP integration with no runtime dependencies, matching n8n verification guidance for community nodes.

Usage

1. Add the Bilig WorkPaper node to a workflow.
2. Choose Forecast for the hosted smoke test or WorkPaper JSON for a custom document.
3. Choose Verify Formula Readback or Evaluate Document.
4. Keep the default hosted base URL or point Bilig Base URL at your own Bilig app.
5. For the forecast smoke test, pick an editable input cell:
   • B2: qualified opportunities
   • B3: win rate
   • B4: average ARR
   • B5: expansion multiplier
6. For custom documents, set Document JSON, Edits JSON, and Read Cells.
7. Use the returned verified and checks fields as a gate before the workflow continues.

For a no-install workflow, see:

examples/n8n-workpaper-formula-readback/bilig-workpaper-formula-readback.n8n.json

Resources

• Bilig GitHub repository
• Bilig n8n workflow example
• Bilig n8n formula readback docs
• n8n community nodes documentation

Version history

• 0.2.0: add a generic WorkPaper JSON evaluation operation for user-owned documents.
• 0.1.2: align the node codex category with n8n's supported Development category.
• 0.1.1: publish through the shared trusted-publishing workflow.
• 0.1.0: initial forecast formula-readback action.