N8N Tools - Pipefy Database icon

N8N Tools - Pipefy Database

Manage Pipefy database tables and records with advanced data operations

Overview

This node enables managing Pipefy database tables, specifically allowing creation of new tables within an organization. It is useful for automating the setup of structured data storage in Pipefy, such as project management boards or custom data collections.

Typical use cases include:

  • Creating a new table to organize workflows or data sets in a Pipefy organization.
  • Setting up tables with specific attributes like color themes, descriptions, and access permissions.
  • Automating table creation as part of a larger workflow that provisions resources dynamically.

For example, you might use this node to create a "Project Tasks" table with a blue theme and public form enabled, granting read authorization to users.

Properties

Name Meaning
Organization ID The ID of the Pipefy organization where the new table will be created. (Required)
Table Name The name to assign to the new table. (Required)
Additional Fields Optional extra settings for the table:
- Description: Text describing the table
- Color: Color theme for the table; options are Blue, Red, Green, Yellow, Purple, Orange, Pink, Gray
- Public Form: Boolean indicating if the table has a public form
- Authorization: Access level for the table; options are Read, Write, Admin

Output

The node outputs a JSON object representing the newly created table. This includes all relevant details such as the table's ID, name, description, color, public form status, and authorization level.

Example output structure (simplified):

{
  "id": "table_123",
  "name": "My New Table",
  "description": "Optional description",
  "color": "blue",
  "publicForm": false,
  "authorization": "read"
}

No binary data is produced by this operation.

Dependencies

  • Requires an API key credential for authenticating with the Pipefy API.
  • Requires a second API authentication token credential for the n8n Tools API.
  • The node uses GraphQL queries and mutations to interact with Pipefy's database backend.
  • Proper configuration of these credentials in n8n is necessary for successful execution.

Troubleshooting

  • Missing Required Fields: Errors occur if "Organization ID" or "Table Name" are not provided. Ensure these fields are filled before running.
  • Invalid API Credentials: Authentication failures may happen if API keys are incorrect or expired. Verify credentials in n8n settings.
  • API Request Failures: Network issues or Pipefy service downtime can cause request errors. Check connectivity and Pipefy status.
  • JSON Parsing Errors: Not applicable for this operation but relevant for other operations involving JSON input.
  • Permission Issues: Insufficient authorization levels may prevent table creation. Confirm your API user has rights to create tables in the specified organization.

Links and References

Discussion