Overview
The BaserowAdvanced node for n8n allows you to create new rows in a specified Baserow database table. This is particularly useful for automating data entry, syncing information from other sources, or integrating Baserow with other systems. For example, you might use this node to automatically add form submissions, CRM leads, or processed data into a Baserow table.
Common scenarios include:
- Ingesting data from webhooks or APIs and storing it in Baserow.
- Migrating or synchronizing records from another database or spreadsheet.
- Automating business processes that require structured data storage.
Properties
| Name | Meaning |
|---|---|
| Database Name or ID | The target Baserow database. You can select from a list or specify an ID using an expression. |
| Table Name or ID | The specific table within the selected database. Select from a list or provide an ID via expression. The available tables depend on the chosen database. |
| Process in Batches | If enabled, input items are processed in batches (recommended for efficiency when creating many rows). |
| Max Batch Size | The maximum number of rows to process in each batch when "Process in Batches" is enabled. |
| Data to Send | Determines how the row data is provided: - Auto-Map Input Data to Columns: Automatically maps incoming item properties to table columns by name. - Define Below for Each Column: Manually set field values. |
| Inputs to Ignore | (Only shown if "Auto-Map Input Data to Columns" is selected) Comma-separated list of input properties to exclude from being sent to Baserow. Leave empty to send all properties. |
| Fields to Send | (Only shown if "Define Below for Each Column" is selected) Specify one or more fields: - Field Name or ID: Choose the column. - Field Value: Set the value for that column. |
Output
- On success, each output item contains the JSON representation of the newly created Baserow row.
- Field names in the output match the column names of your Baserow table.
- If batch processing is used, multiple items are returned, each corresponding to a created row.
- Example output structure:
{
"id": 123,
"Name": "John Doe",
"Email": "john@example.com",
"Created At": "2024-06-01T12:34:56Z"
}
- If creation fails for an item and "Continue On Fail" is enabled, the output will contain an error message for that item.
Dependencies
- External Service: Requires access to a Baserow instance.
- API Key: Needs valid Baserow API credentials configured in n8n under the credential type
baserowApi. - n8n Configuration: No special environment variables required beyond standard credential setup.
Troubleshooting
Common Issues:
- Invalid Credentials: If the Baserow API key is missing or incorrect, the node will fail to authenticate.
- Table/Database Not Found: Supplying an invalid database or table ID will result in errors.
- Field Mapping Errors: If using auto-mapping, ensure your input property names exactly match the destination column names in Baserow.
- Batch Size Too Large: Setting a very high batch size may cause request failures due to server limits.
Error Messages & Resolutions:
"Request failed with status code 401": Check your Baserow API credentials."Table not found"or"Database not found": Verify the IDs or names provided."Field does not exist": Ensure all mapped fields correspond to actual columns in the Baserow table."Cannot read property 'split' of undefined": Make sure all required properties are set, especially when using auto-mapping.