n8n-nodes-teable-community

This is a community n8n node for Teable.io - a powerful database platform with a spreadsheet-like interface.

Teable is a Super fast, Real-time, Professional, Developer friendly, No-code database built on Postgres. It uses a simple, spreadsheet-like interface to create powerful database applications.

Installation

Follow the installation guide in the n8n community nodes documentation.

npm install n8n-nodes-teable-community

Operations

This node supports the following operations:

Records

• Get Records: Retrieve records from a table with filtering, sorting, and pagination

  • Support for view-based filtering
  • Pagination with skip/take parameters
  • Field projection to retrieve specific fields only
  • Complex filtering with JSON conditions
  • Sorting with custom order specifications
  • Search functionality across fields
  • Configurable field key types (name, id, dbFieldName)
  • JSON or text cell format options

• Create Records: Create new records in a table

  • Batch creation of multiple records
  • Field mapping with JSON objects
  • Typecast support for automatic field conversion
  • Configurable field key types

• Update Record: Update an existing record

  • Update specific fields with JSON object
  • Typecast support for field conversion
  • Configurable field key types

• Delete Records: Delete one or more records

  • Support for deleting multiple records at once
  • Comma-separated record ID input

Credentials

You need to create a Personal Access Token in Teable to use this node:

1. Go to Teable Token Management
2. Click "Create Token"
3. Choose appropriate permissions and expiration
4. Specify which bases and spaces the token can access
5. Copy the token (it will only be shown once)

Required Information

• Personal Access Token: Your Teable API token
• Base URL: The base URL of your Teable instance (default: https://app.teable.io)

Configuration

Table ID

All operations require a Table ID, which you can find:

• In the table URL: https://app.teable.io/base/[baseId]/[tableId]
• In the Teable API documentation for your specific table

Field Key Types

You can configure how field names are referenced:

• Name: Use human-readable field names (default)
• ID: Use Teable's internal field IDs
• DB Field Name: Use database column names

Examples

Get Records

{
  "tableId": "tblXXXXXXXXXXXXXX",
  "limit": 100,
  "additionalFields": {
    "filter": {
      "filterByFormula": "AND({Status} = 'Active', {Priority} > 3)"
    },
    "orderBy": [
      {"field": "Created", "order": "desc"}
    ]
  }
}

Create Records

{
  "tableId": "tblXXXXXXXXXXXXXX",
  "records": [
    {
      "fields": {
        "Name": "John Doe",
        "Email": "[email protected]",
        "Status": "Active"
      }
    }
  ]
}

Compatibility

This node was developed and tested with n8n version 1.x.

Resources

• n8n community nodes documentation
• Teable API Documentation
• Teable Website

Contributing

This is an unofficial community node. Contributions are welcome! Please feel free to submit issues and pull requests.

License

MIT