Manage Webflow Form Submissions in Airtable

This n8n workflow automates the process of capturing new form submissions from Webflow and storing them in an Airtable base. It also includes logic to check if a submission with the same email already exists in Airtable, preventing duplicate entries.

What it does

1. Listens for new Webflow form submissions: The workflow is triggered every time a form is submitted on your Webflow site.
2. Extracts submission data: It captures the relevant data from the Webflow form submission (e.g., name, email, message).
3. Formats data for Airtable: Transforms the incoming data into a structure suitable for an Airtable record.
4. Checks for existing records in Airtable: It queries your Airtable base to see if a record with the same email address already exists.
5. Conditionally creates new records:
   • If no matching record is found, a new record is created in Airtable with the form submission data.
   • If a matching record is found, the workflow does not create a duplicate. (Note: The provided JSON does not include an explicit "update" path for duplicates, only a conditional check).

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Webflow Account: A Webflow site with at least one form configured.
• Airtable Account: An Airtable account with a base and a table set up to store form submissions. The table should have fields corresponding to the data you expect from your Webflow form (e.g., "Name", "Email", "Message").
• Webflow API Key: For the Webflow Trigger node.
• Airtable API Key: For the Airtable node.

Setup/Usage

1. Import the workflow:
   • Download the provided JSON file.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Webflow Trigger:
     • Click on the "Webflow Trigger" node.
     • Add your Webflow API Key credential.
     • Select the Webflow site and the form you want to monitor.
     • Activate the webhook.
   • Airtable:
     • Click on the "Airtable" node.
     • Add your Airtable API Key credential.
     • Specify your Airtable "Base ID" and "Table Name".
3. Adjust Field Mapping (if necessary):
   • Edit Fields (Set) Node: This node is currently empty. You will need to configure it to map the incoming Webflow form fields to the desired Airtable field names. For example, if your Webflow form has a field named email_address and your Airtable table has a field named Email, you would add a mapping here.
   • Code Node: This node is also currently empty. It can be used for more complex data transformations if needed.
   • Airtable Node: Ensure the "Create" operation in the Airtable node correctly maps the fields from the "Edit Fields (Set)" node to your Airtable table columns.
4. Activate the Workflow: Once all credentials and configurations are set, activate the workflow by toggling the "Active" switch in the top right corner of the n8n editor.

Now, every time a user submits the specified form on your Webflow site, n8n will capture the data, check for duplicates in Airtable, and add a new record if it's a unique submission.