Airtable Automate - N8N Workflow Directory

Target Audience

This workflow is ideal for:
- Small Business Owners looking to automate data collection and management between Airtable and Baserow.
- Developers who want to integrate forms into their applications without building custom solutions from scratch.
- Data Analysts who need to streamline data entry processes while ensuring data integrity across platforms.
- Marketing Teams that require dynamic forms to capture leads and feedback efficiently.

By automating the data flow, users can save hours of manual entry and reduce errors significantly.

Problem Solved

This workflow addresses the challenge of manually transferring data between Airtable and Baserow. It allows users to:
- Seamlessly collect form submissions through n8n forms.
- Automatically create and update records in Airtable and Baserow, ensuring that all data is synchronized.
- Handle file uploads efficiently, with separate processing for attachments to comply with API requirements.

Ultimately, this workflow eliminates redundancy, enhances productivity, and ensures accurate data management.

Workflow Steps

Form Submission Trigger: The workflow begins with a manual trigger that activates upon form submission.
2. Get Base Schema: It retrieves the structure of the specified Airtable base to understand which fields are available for data entry.
3. Filter Unsupported Field Types: The workflow filters out any unsupported field types that cannot be processed.
4. Convert to n8n Form Fields: Valid fields are transformed into a format suitable for n8n forms.
5. Render Form: The generated form is displayed to the user for data entry.
6. Data Preparation: Once the form is submitted, the data is prepped for insertion into Airtable, ensuring that file inputs are handled separately.
7. Create Record in Airtable: The workflow creates a new record in Airtable with the submitted data.
8. File Processing: Any files submitted are uploaded to Baserow, and the corresponding references are updated in the newly created row.
9. Completion Notification: Finally, a completion message is shown to the user, confirming that their submission has been processed successfully.

Customization Guide

To customize this workflow:
- Modify Form Fields: Users can easily change the fields in the form by adjusting the settings in the 'On form submission' node. Add or remove fields as necessary.
- Change Base and Table IDs: Update the BaseId and TableId values in the dropdown options to point to different Airtable or Baserow tables.
- Adjust API Endpoints: If the API structure changes, users can modify the HTTP request nodes to match the new endpoints.
- Add Additional Processing: Users can insert additional nodes between steps to handle specific data processing tasks, such as data validation or transformation.
- Customize Completion Messages: Edit the 'Show Completion!' nodes to personalize the messages displayed to users after form submission.