n8n Form Trigger to NocoDB Record Creation

This n8n workflow automates the process of capturing data submitted via an n8n form and storing it in a NocoDB database. It includes logic to handle potential duplicate entries and ensures that each submission is processed individually with a short delay.

What it does

1. Listens for Form Submissions: The workflow starts when an n8n form is submitted.
2. Checks for Existing Records: It queries NocoDB to see if a record with the same "Email" (or a similar unique identifier) already exists.
3. Filters New vs. Existing: Based on the NocoDB query, it filters the incoming form submissions into two branches:
   • New Records: Submissions that do not have a matching "Email" in NocoDB.
   • Existing Records: Submissions that already have a matching "Email" in NocoDB.
4. Creates New NocoDB Records: For new submissions, it creates a new record in the specified NocoDB table.
5. Processes in Batches with Delay: To prevent overwhelming the NocoDB API and ensure reliable processing, it processes new records in batches, introducing a short wait period between each batch.

Prerequisites/Requirements

• n8n Instance: A running n8n instance to host the workflow.
• NocoDB Account/Instance: Access to a NocoDB instance with a configured base and table where the form data will be stored.
• NocoDB Credentials: An API token or other authentication details for NocoDB configured as a credential in n8n.
• n8n Form: An n8n Form Trigger node configured to capture the necessary data (e.g., Email, Name).

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure NocoDB Credentials:
   • Locate the "NocoDB" node (ID: 510).
   • Update its credentials to connect to your NocoDB instance.
   • Specify the Base ID and Table ID where you want to store the form data.
3. Configure n8n Form Trigger:
   • Locate the "On form submission" node (ID: 1225).
   • Ensure the form is configured to capture the fields you intend to save to NocoDB (e.g., email, name).
   • Activate the workflow to generate the webhook URL for your form.
4. Adjust Logic (Optional):
   • "Check if Email exists" (HTTP Request node ID: 19): Modify the URL and query parameters to match your NocoDB table's API endpoint and the field you use for checking uniqueness (e.g., Email).
   • "If" node (ID: 20): Adjust the condition to accurately determine if a record already exists based on the response from the "Check if Email exists" node.
   • "Loop Over Items" (ID: 39) and "Wait" (ID: 514): Adjust batch size and wait time as needed for your specific NocoDB rate limits or performance requirements.
   • "Create NocoDB Record" (NocoDB node ID: 510): Map the incoming form data to the correct columns in your NocoDB table.
5. Activate the Workflow: Once configured, activate the workflow. It will now automatically process form submissions and create/update records in NocoDB.