Automate Airtable & Baserow Form Integration with n8n

This workflow automates form generation and data insertion for Airtable and Baserow tables, solving the challenge of manual data entry and file uploads. It dynamically creates n8n forms based on table schemas, processes entries including file attachments, and updates records seamlessly.
airtable
formTrigger
filter
+6
Workflow Identifier: 1906
NODES in Use: airtable, formTrigger, filter, aggregate, form, code, splitOut, httpRequest, stickyNote
Automate forms with n8n and Airtable

Press CTRL+F5 if the workflow didn't load.

Learn how to Build this Workflow with AI:

What this workflow does

This workflow creates forms automatically from Airtable and Baserow table structures inside n8n.

It takes data submitted through the form and adds it to the right database rows.

Files attached to the form upload separately and connect correctly to records.

This saves time building forms and avoids mistakes in data and file processing.


Who should use this workflow

This workflow is good for people managing projects that use Airtable or Baserow databases.

It helps teams that need to collect data from many users with forms and handle file uploads.

No need to build forms by hand or manually upload attachments later.

Users with some basic knowledge of API keys and n8n node setup can run it.


Tools and services used

  • Airtable API: Retrieves table schemas and inserts records.
  • Baserow API: Gets table fields and adds rows with uploads.
  • n8n Automation platform: Runs the workflow nodes and manages data flow.
  • HTTP Request nodes: Make API calls to fetch schemas and upload files.
  • Code nodes: Convert schemas to form fields and prepare data.
  • Form Trigger and Form nodes: Capture submissions and render forms for users.

How this workflow works (Input → Process → Output)

Inputs

The workflow starts on form submission through a Webhook node or Form Trigger node.

Select BaseId (Airtable) or TableId (Baserow) from dropdown options to specify where data goes.

The submitted data may include text fields and file attachments.

Processing steps

The workflow retrieves the schema for the selected Airtable base or Baserow table using API calls via Airtable or HTTP Request nodes.

It filters the schema to only supported field types and splits those into single items for transformation.

Code nodes map database field types to n8n form fields, like text, email, dropdown, date, or file input.

The form fields are combined into one JSON schema and rendered to the user through the Form node.

Submitted data is prepared by separating file attachments from normal fields, ensuring type castings and correct formatting.

New records are created in Airtable or Baserow using API calls.

Files in the submission upload separately and get associated with the correct records via additional API updates.

Outputs

Records in Airtable or Baserow are created or updated with user data and attachments.

The form shows a message confirming submission success.


Beginner step-by-step: How to use this workflow in n8n

Step 1: Import the workflow

  1. Download this workflow file using the Download button on this page.
  2. Open your n8n editor dashboard.
  3. Select Import from File and upload the downloaded workflow JSON file.

Step 2: Add credentials and configure IDs

  1. Add your Airtable Personal Access Token and Baserow API Token in the credentials section.
  2. Update BaseId (Airtable) or TableId (Baserow) fields if your database has different values from dropdown options.
  3. Check any emails, folder IDs, or channel names if present and change to your own.

Step 3: Test and activate the workflow

  1. Trigger the form by opening the webhook URL provided by the Form nodes and submit sample data.
  2. Check the execution in n8n to see that data made it into your Airtable or Baserow tables.
  3. Activate the workflow switch in n8n to keep it running for production submissions.

If you want to run self-host n8n, follow standard hosting steps.


Customization ideas

  • Add new field types by editing the Code nodes to map your database fields to n8n forms.
  • Change placeholder text and help hints inside the JSON form schema before rendering.
  • Limit form access with authentication nodes before submission triggers.
  • Make dropdown options dynamic by requesting table lists through API calls instead of hardcoded values.
  • Edit the final form completion message in the Form Completion node for custom text.

Common problems and fixes

No form submission data received

Cause: Wrong or inactive webhook URL in Form Trigger nodes.

Fix: Make sure webhook path and URL match, and the n8n workflow is active.

Schema fetch fails or is empty

Cause: Bad or missing API Key for Airtable or Baserow.

Fix: Check keys carefully and test using API tools before trying in n8n.

File uploads don’t work or attachments are missing

Cause: Binary file data not mapped properly or incorrect HTTP Request settings.

Fix: Confirm Code nodes extract file data correctly and HTTP Requests use multipart form-data.


Before going live checklist

  • Try submitting the form with and without file uploads to confirm workflow behavior.
  • Verify Airtable and Baserow API Keys have needed permissions.
  • Confirm that all form fields show correctly and required fields enforce input.
  • Check records in databases created from test submissions, including attached files.
  • Back up any existing Airtable or Baserow data before final deployment.

Summary of results

✓ Forms build automatically from Airtable or Baserow schemas inside n8n.

✓ Form submissions insert accurate rows including files in databases fast.

✓ Manual form design and file handling are no longer needed.

→ Saves hours per week and reduces errors in data entry.

→ Enables easy data collection across team projects using common database tools.

Automate forms with n8n and Airtable

Visit through Desktop to Interact with the Workflow.

Frequently Asked Questions

The workflow fetches the schema from Airtable or Baserow tables using API calls, then a code node converts each field into an n8n form field type. Unsupported fields are filtered out before rendering the form.
File attachments are extracted separately from other data. They upload using API calls to Airtable or Baserow, then the record is updated to link with the uploaded files.
Add API keys for Airtable and Baserow credentials. Update any BaseId or TableId used in dropdowns to match your databases. Test the form triggers and activate the workflow.
Yes, the workflow supports multiple file attachments for file fields and processes them individually before linking to the database records.

Promoted by BULDRR AI

Related Workflows

Automate Twist Channel Creation and Messaging with n8n

This workflow automates creating and updating a channel in Twist and sending a personalized message to specific users. It eliminates manual setup errors and saves time managing Twist communications.

Automate Ideogram Image Generation with Google Sheets & Gmail

This workflow automates graphic design image generation via Ideogram AI, storing image data in Google Sheets and Google Drive, with email alerts via Gmail. It saves designers hours by automating image creation, remixing, review, and record-keeping.

Automate IT Support with Slack and OpenAI in n8n

Streamline IT support by automating Slack message handling using n8n and OpenAI. This workflow handles Slack DMs, filters bots, queries a Confluence knowledge base, and delivers AI-generated responses, improving support efficiency and response time.

Automate Crypto Analysis with CoinMarketCap & n8n AI Agent

Discover how this unique n8n workflow leverages CoinMarketCap’s multi-agent AI to deliver precise, real-time cryptocurrency insights directly via Telegram. Manage crypto data analysis efficiently with automated multi-source API integration.

Automate Gumroad to Beehiiv Subscriber Sync with n8n

Learn how to automatically add new Gumroad sales customers as Beehiiv newsletter subscribers using n8n automation. This workflow saves time by syncing sales data to Google Sheets CRM and notifying your Telegram channel instantly.

Generate On-Brand Blog Articles Using n8n and OpenAI

This workflow automates the creation of on-brand blog articles by analyzing existing company content using n8n and OpenAI. It extracts article structures and brand voice to produce consistent draft articles, saving significant content creation time.
1:1 Free Strategy Session
Your competitors are already automating. Are you still paying for it manually?

Do you want to adopt AI Automation?

Every hour your team does repetitive work, you're burning real money.
While you wait, faster businesses are cutting costs and moving quicker.
AI and automations aren't the future anymore — they're the present.

Book a live 1-on-1 session where we show you exactly which of your daily tasks can be automated — and what it’s costing you not to.