Airtable Block

What it does: Connect your workflows to Airtable databases to read, write, update, and manage your spreadsheet-style data.

When to Use This

Use Airtable when you need:

• ✅ Store and retrieve structured data
• ✅ Track leads, customers, or inventory
• ✅ Manage project tasks and workflows
• ✅ Create simple CRM or database systems
• ✅ Sync data between workflows and your team's Airtable

Example: Automatically add new leads from a chat conversation to your Airtable CRM, then update their status as they move through your sales process.

Key Features

• Full CRUD Operations: Create, Read, Update, Delete records
• Flexible Queries: Filter and sort data easily
• Field Mapping: Work with text, numbers, dates, attachments, and more
• Batch Operations: Process multiple records at once
• Real-Time Sync: Changes reflect immediately in your Airtable base

Understanding Airtable Structure

Setup Guide

Step 1: Get Airtable Credentials

1. Go to airtable.com/create/tokens
2. Create a new Personal Access Token
3. Give it a descriptive name
4. Select the scopes (permissions) you need:
   • data.records:read (to read data)
   • data.records:write (to add/update data)
5. Select which bases to grant access to
6. Copy and save your token securely

Step 2: Find Your Base and Table IDs

1. Open your Airtable base in a browser
2. Look at the URL - it contains your Base ID (starts with "app")
3. The Table ID is also in the URL (starts with "tbl")
4. Or use the API documentation page to see all your IDs

Step 3: Configure the Block

Connection Settings:

1. Credentials: Select your Airtable credentials from the dropdown or create new ones
2. Base ID: Select from your available Airtable bases
3. Table: Enter the exact table name (case-sensitive)

Choose Your Operation:

Operation-Specific Settings:

For LIST operations:

• Filter By Formula: Airtable formula to filter records (e.g., {Status}='Active')
• Max Records: Limit the number of records returned
• Sort: JSON array for sorting (e.g., [{"field": "Name", "direction": "asc"}])

For READ, UPDATE, DELETE operations:

• Record ID: The Airtable record ID (format: recXXXXXXXXXXXXXX)

For APPEND, UPDATE operations:

• Fields (JSON): Key-value pairs of field names and values

  {"Name": "John Doe", "Email": "john@example.com", "Status": "Active"}

Save in Variables:

• Map response data to workflow variables for later use
• Add custom field mappings to extract specific data points

Common Use Cases

Lead Management

Capture leads from conversations and automatically add them to your Airtable CRM with contact information, source, and initial status.

Order Tracking

Track orders through different stages by updating records as orders are processed, shipped, and delivered.

Content Calendar

Manage blog posts or social media content by creating and updating records with publish dates, status, and content details.

Inventory Management

Track stock levels, update quantities when sales occur, and get alerts when items run low.

Survey Responses

Store and analyze survey or form responses by creating records for each submission with all response data.

Operations Explained

LIST

Retrieve multiple records from your table with flexible filtering options:

• Filter By Formula: Use Airtable formulas to filter records (e.g., {Status}='Active', {Organization}='n8n')
• Max Records: Limit the number of records returned (useful for pagination)
• Sort: Provide a JSON array to sort by multiple fields

  [{"field": "Name", "direction": "asc"}, {"field": "Created", "direction": "desc"}]

READ

Retrieve a specific record by its unique Record ID. You'll need:

• The record ID (format: recXXXXXXXXXXXXXX)
• Returns all fields for that single record

APPEND

Add a new row to your table by providing field values:

• Supply fields as JSON key-value pairs
• Field names must match exactly (case-sensitive)
• Example:

  {"Name": "John Doe", "Email": "john@example.com", "Phone": "+1234567890"}

UPDATE

Modify an existing record by specifying both the Record ID and the fields to update:

• Requires the record ID
• Only updates the fields you specify (other fields remain unchanged)
• Fields provided as JSON

DELETE

Remove a record from your table permanently:

• Only requires the record ID
• Cannot be undone - the record is permanently deleted

What You Get Back

After running an Airtable operation:

• Record Data: The actual data from your records
• Record IDs: Unique identifiers for each record
• Created Time: When records were added
• Field Values: All the data in each field

Tips for Success

1. Use descriptive field names - Makes it easier to map data correctly
2. Create views for filtering - Use Airtable views to simplify queries
3. Test with sample data first - Verify operations work before running on real data
4. Handle empty fields - Not all records may have all fields filled
5. Use Record IDs for updates - Always reference records by their unique ID

Troubleshooting

Best Practices

• Use meaningful record identifiers - Store record IDs for later updates
• Batch similar operations - Group creates/updates when possible
• Validate data before writing - Ensure data matches field types
• Set up error handling - Plan for what happens if operations fail
• Keep tokens secure - Never expose API tokens in public places