# Airtable

Store your Web3Forms submissions in Airtable, the flexible database that combines the power of a database with the simplicity of a spreadsheet. Perfect for organizing, filtering, and collaborating on form data.

{% hint style="info" %}
This integration uses **Webhooks**, which is a PRO feature. You must have an active PRO plan subscription to use Airtable with Web3Forms.
{% endhint %}

## What is Airtable?

[Airtable](https://airtable.com/) is a cloud-based collaboration platform that combines the features of a database, spreadsheet, and project management tool. It's ideal for storing and organizing form submissions because it offers:

* **Rich Field Types**: Text, numbers, attachments, checkboxes, dates, and more
* **Views**: Grid, calendar, kanban, gallery, and form views
* **Filtering & Sorting**: Powerful data organization tools
* **Collaboration**: Share with team members and set permissions
* **Automations**: Trigger actions based on new submissions
* **Integrations**: Connect with thousands of other apps

## Integration Methods

There are two ways to integrate Web3Forms with Airtable:

### Method 1: Using Zapier or Make (Recommended)

The easiest way to connect Web3Forms to Airtable is through automation platforms:

* **Zapier**: Simple setup with no-code interface
* **Make**: More advanced features and better free tier

### Method 2: Direct Webhook Integration

For developers, you can use Airtable's API with a custom webhook endpoint or services like Pipedream.

## Setup via Zapier

### Step 1: Create Airtable Base

1. Log in to [Airtable](https://airtable.com/)
2. Create a new base or open an existing one
3. Create a table for form submissions (e.g., "Contact Forms")
4. Add fields matching your form data:
   * Name (Single line text)
   * Email (Email)
   * Phone (Phone number)
   * Message (Long text)
   * Submitted At (Date)

**\[SCREENSHOT PLACEHOLDER: Airtable base with form submission fields]**

### Step 2: Set Up Zapier Integration

1. Go to [Zapier](https://zapier.com/) and create a new Zap
2. **Trigger**: Choose "Webhooks by Zapier" → "Catch Hook"
3. Copy the webhook URL
4. Add the webhook URL to your Web3Forms integration settings
5. Test by submitting your form

**\[SCREENSHOT PLACEHOLDER: Zapier webhook trigger setup]**

### Step 3: Configure Airtable Action

1. **Action**: Search for "Airtable" and select it
2. Choose **Create Record** as the action event
3. Connect your Airtable account
4. Select your base and table
5. Map form fields to Airtable fields:
   * Name → Name field
   * Email → Email field
   * Message → Message field
   * etc.

**\[SCREENSHOT PLACEHOLDER: Zapier Airtable action with field mapping]**

### Step 4: Test and Activate

1. Test the Zap to ensure data is being created correctly
2. Check your Airtable base for the test record
3. Turn on your Zap
4. Submit a form to verify end-to-end functionality

## Setup via Make (Integromat)

### Step 1: Create Airtable Base

Follow the same steps as in the Zapier method to create your Airtable base and table.

### Step 2: Set Up Make Scenario

1. Go to [Make](https://www.make.com/) and create a new scenario
2. Add a **Webhooks** module → **Custom webhook**
3. Create a new webhook and copy the URL
4. Add the webhook URL to Web3Forms

**\[SCREENSHOT PLACEHOLDER: Make webhook module configuration]**

### Step 3: Add Airtable Module

1. Click **+** after the webhook module
2. Search for "Airtable" and select it
3. Choose **Create a Record** as the action
4. Connect your Airtable account (you'll need an API key)
5. Select your base and table
6. Map the webhook data to Airtable fields

**\[SCREENSHOT PLACEHOLDER: Make Airtable module with field mapping]**

### Step 4: Test and Activate

1. Run the scenario once to test
2. Submit a test form
3. Verify the record appears in Airtable
4. Activate your scenario

## Airtable API Key Setup

If using Make or direct API integration, you'll need an Airtable API key:

1. Go to [Airtable Account Settings](https://airtable.com/account)
2. Click **Generate API key** in the API section
3. Copy your API key (keep it secure!)
4. Use this key when connecting to Make or other services

{% hint style="warning" %}
Never share your Airtable API key publicly or commit it to version control.
{% endhint %}

## Getting Your Base ID

To use the Airtable API, you need your Base ID:

1. Go to [Airtable API Documentation](https://airtable.com/api)
2. Select your base from the list
3. The Base ID appears in the introduction section
4. It starts with "app" (e.g., `appXXXXXXXXXXXXXX`)

## Troubleshooting

### Records Not Creating

* **Check Field Names**: Ensure field names in Airtable match your mapping
* **Field Types**: Verify field types are compatible (e.g., email field for email data)
* **API Permissions**: Make sure your API key has write permissions
* **Base Limits**: Check if you've reached Airtable plan limits

### Authentication Errors

* **Regenerate API Key**: Create a new API key in Airtable settings
* **Reconnect Account**: In Zapier/Make, reconnect your Airtable account
* **Check Permissions**: Ensure the API key has access to the specific base

### Missing Data

* **Field Mapping**: Review field mappings in your automation
* **Required Fields**: Ensure all required Airtable fields are mapped
* **Data Format**: Check that data formats match (dates, numbers, etc.)

### Rate Limits

Airtable has API rate limits:

* **Free Plan**: 5 requests per second per base
* **Paid Plans**: Higher limits available
* If you hit limits, consider batching or reducing frequency

## Related Integrations

* [Google Sheets Integration](https://docs.web3forms.com/getting-started/integrations/google-sheets) - Alternative spreadsheet solution
* [Zapier Integration](https://docs.web3forms.com/getting-started/integrations/soon/zapier) - Automation platform guide
* [Make Integration](https://docs.web3forms.com/getting-started/integrations/soon/integromat) - Advanced automation
* [Webhooks Documentation](https://docs.web3forms.com/getting-started/pro-features/webhooks) - Direct API integration