Automate Netlify Form Data to Airtable with n8n

What This Automation Does

This workflow sends form data from Netlify to Airtable automatically.
It starts when someone submits a form on a Netlify site.
The data like Name, Email, and Role gets cleaned and saved in Airtable.
It stops manual typing and cuts errors in tracking.
You save lots of time and have organized records ready to use.

Tools and Services Used

• Netlify: Hosts the website and form. Sends form submission events.
• n8n: Automates the process by connecting triggers and actions.
• Airtable: Stores form submissions in a structured table.

How the Workflow Works

Inputs

Input data is a new form submission from a Netlify site and form.
The form contains fields like Name, Email, and Role.

Processing Steps

First, the Netlify Trigger listens and fires when someone submits the form.
Next, the Set node pulls the needed fields from the form’s JSON payload.
It formats values like picking the first Role if Role is an array.
Then, the Airtable node adds a new record to the right base and table with that data.

Output

The result is a new record in Airtable with the form data stored neatly.
This data is ready for tracking or to follow up with leads without typing manual entries.

Beginner step-by-step: How to build this in n8n

Import Workflow

1. Download the workflow file using the Download button on this page.
2. In the n8n editor, click on Import from File.
3. Select the workflow file to import.

Configure Credentials

1. Add or select your saved Netlify API credentials in the Netlify Trigger node.
2. Add or select your Airtable API Key in the Airtable node.

Customize IDs and Fields

1. Update the Site ID and Form ID in the Netlify Trigger to match your Netlify setup.
2. Update the Base ID and Table name in the Airtable node to your Airtable base and table.
3. Change field mappings in the Set node if you added more form fields.

Test and Activate

1. Run the workflow manually once by submitting a test form on your Netlify site.
2. Check if a new record appears in Airtable with the form data.
3. Once verified, activate the workflow by turning on the trigger node for production use.

If you self-host n8n, consider checking self-host n8n for reliable server setup.

Common Problems and Fixes

• Problem: No webhook trigger firing when form is submitted.
  Cause: Wrong Site ID or Form ID in the Netlify Trigger node.
  Fix: Double-check IDs in Netlify dashboard and n8n node settings.
• Problem: Airtable fails to add new record.
  Cause: Wrong Base ID, Table name, or invalid API Key.
  Fix: Verify API Key access and that the Airtable base and table exist with correct permissions.
• Problem: Data fields like Role appear wrong or empty.
  Cause: Incorrect expression to access array data.
  Fix: Use the correct expression syntax with brackets, e.g. {{$json["role"][0]}}.

Customization Ideas

• Add more form fields like Phone Number or Company in the Set node by matching new JSON properties.
• Insert an If node after the Set node to filter submissions based on Role.
• Add a Gmail node after the Airtable node to send confirmation emails to contacts.

Summary and Benefits

→ Automates moving form data from Netlify to Airtable.
→ Stops manual data entry saving hours every week.
→ Improves data accuracy for better tracking.
→ Makes form submission data ready and easy to use.