Dynamically Create Airtable Tables for Webflow Form Submissions
detail.loadingPreview
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_baseIdand 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, andTableName. - [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_currentFormTableIdvariable. If a matching record was found in the 'Form Index' table, it uses the storedTableId. 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_currentFormTableIdhas 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_currentFormTableIdvariable. It also ensuresat_formIndexTableIdis 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 theat_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, andFormCreationDate.
Apps Used
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.
Get This Workflow
ID: 260087b5-dc4c...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
FileMaker Data Entry and Update
Workflow to create a record in FileMaker, then edit it with additional data.
CSV to MySQL Data Ingestion
Reads a CSV file and inserts its data into a MySQL database.
Two-Way Sync Pipedrive and MySQL Contacts
Synchronizes contact data between Pipedrive and a MySQL database to ensure data consistency.