Netlify Form Submissions to Airtable

This n8n workflow automates the process of capturing new form submissions from Netlify and adding them as new records in an Airtable base. It simplifies data collection from your Netlify-hosted forms, ensuring that every submission is automatically logged for easy management and analysis.

What it does

1. Listens for New Netlify Form Submissions: The workflow is triggered every time a new form submission is received by your Netlify site.
2. Edits Fields: It processes the incoming Netlify data, likely mapping or transforming the form fields to match the expected structure in Airtable.
3. Adds Record to Airtable: Finally, it creates a new record in a specified Airtable base and table, populating it with the data from the Netlify form submission.

Prerequisites/Requirements

• n8n Instance: A running instance of n8n.
• Netlify Account: With at least one form configured and receiving submissions.
• Airtable Account: An Airtable base and table where you want to store the form submissions.
• Netlify API Key: For the Netlify Trigger node.
• Airtable API Key: For the Airtable node.
• Airtable Base ID and Table Name: The specific Airtable base and table you want to write to.

Setup/Usage

1. Import the Workflow:

   • Download the provided JSON file for this workflow.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the three dots in the top right corner and select "Import from JSON".
   • Paste the workflow JSON or upload the file.

2. Configure Netlify Trigger:

   • Click on the "Netlify Trigger" node.
   • Add your Netlify API Key credential.
   • Follow Netlify's instructions to set up a webhook for your form that points to the webhook URL provided by this n8n node. This typically involves going to your Netlify site settings, then "Forms", and adding a new "Incoming Webhook" notification.

3. Configure Edit Fields (Set) Node:

   • Click on the "Edit Fields" node.
   • Review and adjust the field mapping to ensure the Netlify form submission data correctly corresponds to the fields in your Airtable table. You might need to rename or select specific properties from the Netlify payload.

4. Configure Airtable Node:

   • Click on the "Airtable" node.
   • Add your Airtable API Key credential.
   • Enter the Base ID of your Airtable base.
   • Enter the Table Name where you want to add the submissions.
   • Map the fields from the previous "Edit Fields" node to your Airtable table columns.

5. Activate the Workflow:

   • Once all credentials and configurations are set, click the "Activate" toggle in the top right corner of the n8n editor to enable the workflow.

Now, every time a user submits your Netlify form, this workflow will automatically add that submission as a new record in your specified Airtable table.