Dynamically Create Airtable Tables for Webflow Form Submissions

Name: Dynamically Create Airtable Tables for Webflow Form Submissions
Rating: 5 (5 reviews)
Author: Free N8N

Intermediate

12 nodes connected

detail.loadingPreview

Free N8N Temples

448 views

31 downloads

Data Managementairtableautomationdatabaseformswebflow

Automatically create dedicated Airtable tables for each Webflow form and log submissions.

About This Workflow

This workflow dynamically creates tables within an Airtable base for each unique Webflow form submission. It ensures that submissions from different forms are stored in their respective, newly created Airtable tables, providing organized data management.

Key Features

Dynamic Table Creation: Automatically generates new tables in Airtable based on Webflow form names.
Form Submission Logging: Records each Webflow form submission as a new record in the corresponding Airtable table.
Index Table Management: Maintains a 'Form Index' table to map Webflow form IDs to their respective Airtable table IDs.
Robust Error Handling: Includes checks to see if tables already exist, preventing duplicates and managing workflow execution.

How To Use

Webflow Submission Trigger: Connect to your Webflow site and configure the webhook to trigger on form submissions.
Prepare form submission for workflow: This node processes the incoming Webflow submission data, extracting relevant information and preparing it for further processing.
[AIRTABLE] Get Base Schema from list: Configure this node with your Airtable Personal Access Token and select the Airtable base where you want to create tables. This node fetches the schema to identify existing tables.
Get Form Index Reference Table ID: This code node determines the at_baseId and searches for an existing 'Form Index' table. If not found, it prepares to create one.
Does Index Reference Table Exist?: An IF node that checks if the 'Form Index' table ID was found. If not, it proceeds to create it.
- If True (table exists): Proceeds to search for the specific Webflow form record in the 'Form Index' table.
- If False (table does not exist): Proceeds to create the 'Form Index' table.
[AIRTABLE] Create Index Reference Table: An HTTP Request node used to create the 'Form Index' table in Airtable if it doesn't exist. It defines the fields for FormId, FormName, TableId, and TableName.
[AIRTABLE] Find Webflow Form Record In Form Index Reference Table: Searches the 'Form Index' table for a record matching the submitted Webflow form's ID.
Set Webflow Form Table ID: A code node that updates the at_currentFormTableId variable. If a matching record was found in the 'Form Index' table, it uses the stored TableId. Otherwise, it remains null, indicating a new table needs to be created.
Does This Webflow Form Table Exist?: An IF node that checks if at_currentFormTableId has a value.
- If True (table already exists): Proceeds to insert the record into the existing Webflow form table.
- If False (table needs to be created): Proceeds to create the specific Webflow form table.
[AIRTABLE] Create Webflow Form Table: An HTTP Request node used to create a new table in Airtable for the specific Webflow form. The table name is derived from the wf_formName.
Set New Webflow Form Table ID: A code node that captures the ID of the newly created Webflow form table and updates the at_currentFormTableId variable. It also ensures at_formIndexTableId is set, whether it was just created or already existed.
[AIRTABLE] Insert Record In Form Index Reference Table: Inserts a new record into the 'Form Index' table, linking the wf_formId, wf_formName, and the at_currentFormTableId.
[AIRTABLE] Insert Record In Webflow Form Table: Inserts the actual Webflow form submission data as a record into the appropriate Webflow form table. The fields include Id, FormId, FormName, FormContent, and FormCreationDate.

Apps Used

airtable

automation

database

forms

webflow

Workflow JSON

{
  "id": "260087b5-dc4c-47f0-9189-da346de0e592",
  "name": "Dynamically Create Airtable Tables for Webflow Form Submissions",
  "nodes": 12,
  "category": "Data Management",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.