Skip to content

airtable.md

Latest commit

 

History

History
172 lines (117 loc) · 5.77 KB

airtable.md

File metadata and controls

172 lines (117 loc) · 5.77 KB

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 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
  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 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 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
  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
  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