Bear Brown
← All N8N workflows
Data & databasesAggregateAirtableCodeFilterForm

🚨 Change your Base ID and Table ID here!

Configured with Aggregate, Airtable, Filter, Form, and additional nodes. Review the connections and setup before adapting this template.

Download workflow JSONView files on GitHub ↗26 nodes · MIT
Workflow preview
Data storeGet Base SchemaAirtableTriggerOn form submissionForm TriggerRoutingFilter UnsupportedFieldTypesFilterTransformCombine FieldsAggregateIntegrationRender FormFormCodeFiles To ListCodeTransformFields to ListSplit OutCodeCovert to n8n FormFieldsCodeRoutingFilter TableFilterWeb / APIBaserow List FieldsHTTP RequestCodeCovert to n8n FormFields1CodeTransformCombine Fields1AggregateRoutingFilter UnsupportedFieldTypes1FilterIntegrationRender Form1FormWeb / APIBaserow Create RowHTTP RequestTriggerOn form submission1Form TriggerCodeFiles To List1CodeWeb / APIBaserow Upload FileHTTP RequestWeb / APIBaserow Update RowHTTP RequestCodeGroup By FieldNameCodeWeb / APIUpdate Airtable RowHTTP RequestCodePrep Data for Insert1CodeCodePrep Data for InsertCodeData storeAirtable Create RecordAirtableIntegrationShow Completion!FormIntegrationShow Completion!1Form

Node categories in this workflow

  • Data store
  • Trigger
  • Routing
  • Transform
  • Integration
  • Code
  • Web / API

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
Get Base SchemaData storeAirtablebase / getSchema
On form submissionTriggerForm TriggerSee node parameters
Filter Unsupported FieldTypesRoutingFilterSee node parameters
Combine FieldsTransformAggregateSee node parameters
Render FormIntegrationFormSee node parameters
Files To ListCodeCodeSee node parameters
Fields to ListTransformSplit OutSee node parameters
Covert to n8n Form FieldsCodeCodeSee node parameters
Filter TableRoutingFilterSee node parameters
Baserow List FieldsWeb / APIHTTP RequestSee node parameters
Covert to n8n Form Fields1CodeCodeSee node parameters
Combine Fields1TransformAggregateSee node parameters
Filter Unsupported FieldTypes1RoutingFilterSee node parameters
Render Form1IntegrationFormSee node parameters
Baserow Create RowWeb / APIHTTP RequestPOST
On form submission1TriggerForm TriggerSee node parameters
Files To List1CodeCodeSee node parameters
Baserow Upload FileWeb / APIHTTP RequestPOST
Baserow Update RowWeb / APIHTTP RequestPATCH
Group By FieldNameCodeCodeSee node parameters
Update Airtable RowWeb / APIHTTP RequestPOST
Prep Data for Insert1CodeCodeSee node parameters
Prep Data for InsertCodeCodeSee node parameters
Airtable Create RecordData storeAirtablecreate
Show Completion!IntegrationFormcompletion
Show Completion!1IntegrationFormcompletion

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • airtableTokenApi
  • httpHeaderAuth

Workflow notes

Try It Out!

Try It Out!

This template is an example of how you could replace Airtable or Baserow forms with n8n forms. Though debateable whether this is actually useful, it is a cool demo of how someone would approach this if it every became a problem.

How it works

  • A form trigger is used to dynamically select a database/table from which to build the n8n form from.
  • the table's schema is imported into the workflow and using the code node, is converted into the n8n form fields schema.
  • This let's us dynamically build the fields in our n8n form when we choose to define the form using the JSON option.
  • Once the n8n form submits, we convert the values back into our table's API schema so that we can create a new row.
  • Note any files/attachments fields are removed as they need to be handled separately.
  • Files are processed separately as they may first need to be stored. Once complete, the reference is saved into the newly created row.

Check out the example Airtable here - https://airtable.com/appfP15Xd0aVZR9xV/shrGFgXLyQ4Jg58SU

⭐️ New to Airtable? Sign up here!

How to use

  • The n8n form is autogenerated which means you only need provide access to the table. Using this approach, this template can be reused for any number of Airtable and/or Baserow tables.

Need Help?

Join the Discord or ask in the Forum!

Happy Hacking!

1. Get Table Schema

1. Get Table Schema

Airtable schema returns all tables with extra metadata whereas Baserow has a dedicated list fields endpoint for each table. This means for Airtable, we need to filter out the table we want and split out its fields array.

2. Convert To N8N Form Schema

2. Convert To N8N Form Schema

Both products contain similar schema with only different field labels. This makes it quite simple to convert either to n8n's forms. JSON schema.

3. Render as N8N Form

3. Render as N8N Form

Did you know you can build forms dynamically from JSON? Well, you can! This flexibility makes working with n8n forms strategic because you can conditionally exclude fields which may not apply to the user or the context.

4. Create New Row

4. Create New Row

Both Airtable and Baserow accept field labels as body param keys when using their API however, files and attachments are handled separately. Here we omit any file fields

5. Upload Files & Attachments

5. Upload Files & Attachments

Baserow requires a 2 step process where the file is first uploaded and the returning reference is used to update the row. Airtable API allows upload and update of the row in one operation. The Airtable upload API also seems to work in an append fashion - each call adds to the attachments array - but Baserow uses replace approach meaning you need to upload the files in one go.

🚨 Change your Base ID and Table ID here!

🚨 Change your Base ID and Table ID here!

Purpose and structure

This folder contains the 🚨 Change your Base ID and Table ID here! workflow. Its executable nodes use aggregate, airtable, code, filter, form, formTrigger, httpRequest, splitOut. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

On form submission, On form submission1

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Splitout/0654_Splitout_Code_Create_Webhook.json MIT; preserve source notices.

Canvas section labels

These name areas of the original canvas; they do not include explanatory instructions.

  • AirTable Example
  • BaseRow Example

More in Data & databases

1/ Add Your credentials1/ Add Your credentials2. Add Beehiiv newsletter subscribers from Gumroad sales