Dynamically create tables in Airtable for your Webflow form submissions

Target Audience

- Webflow Users: Those who utilize Webflow for form submissions and need to manage the data more effectively.
- Airtable Users: Individuals or teams using Airtable to organize and analyze data from various sources.
- Developers and Automators: Professionals looking for a way to automate data collection and management without extensive coding.
- Small Business Owners: Entrepreneurs who want to streamline their form submission processes and keep track of customer interactions efficiently.

Problem Solved

This workflow addresses the challenge of managing form submissions from Webflow by automatically creating corresponding tables in Airtable. It eliminates the need for manual data entry and organization, ensuring that every submission is recorded accurately and efficiently. This integration allows users to:
- Dynamically create tables based on form submissions.
- Keep track of multiple forms and their submissions in a structured manner.
- Save time and reduce errors associated with manual data handling.

Workflow Steps

1. Webflow Submission Trigger: The process begins when a form submission occurs on a Webflow site, triggering the workflow.
2. Prepare Form Submission: The data from the submission is prepared for processing, extracting key information such as formId, formName, and the submission data.
3. Get Form Index Reference Table ID: The workflow checks for an existing Airtable table that serves as an index for form submissions.
4. Check for Index Table Existence: It verifies if the index reference table exists; if not, it creates one.
5. Create Index Reference Table: If the index table does not exist, it creates a new table to store references for forms submitted.
6. Create Webflow Form Table: For each unique form submission, a new table is created in Airtable to store that form's submissions.
7. Insert Record in Form Index: The workflow inserts a record into the index table to keep track of the new form and its corresponding table.
8. Insert Record in Webflow Form Table: Finally, it inserts the actual form submission data into the newly created table in Airtable.

Customization Guide

- Change Webflow Credentials: Update the Webflow API credentials to connect to your specific site.
- Modify Airtable Access: Ensure the Airtable Personal Access Token is set correctly to allow for table creation and data entry.
- Adjust Form Names: Customize the names of the forms in Webflow to match the desired naming convention in Airtable.
- Edit Field Types: Depending on your data needs, you may customize the fields created in Airtable tables (e.g., add more fields or change field types).
- Add Additional Logic: If necessary, you can include more complex conditions or additional nodes to further refine the workflow based on your requirements.