Airtable
What it does
Section titled “What it does”The Airtable node connects your workflows to your Airtable bases, allowing you to create, update, or retrieve records automatically.
Think of it as a bridge that sends data from your workflows directly into your Airtable spreadsheets, organizing information in rows and columns without any manual copy-pasting.
When to use it
Section titled “When to use it”- You want to store web-scraped data in an organized spreadsheet format
- You need to build a content calendar, CRM, or project tracker from workflow data
- You want to create searchable databases of articles, products, or contacts
- You prefer a spreadsheet-like interface for viewing your collected data
How it works
Section titled “How it works”The node connects to Airtable using a personal access token. When triggered, it can create new records, update existing ones, or search and retrieve data from your bases.
graph LR
Workflow[Workflow Trigger] --> Airtable{Airtable Node}
Airtable --> Create[Create Record]
Airtable --> Update[Update Record]
Airtable --> Search[Search Records]
style Airtable fill:#6d28d9,stroke:#fff,color:#fff
Setup guide
Section titled “Setup guide”-
Get your Airtable personal access token
- Go to airtable.com/create/tokens
- Click “Create token” and give it a name
- Select scopes:
data.records:writeanddata.records:read - Grant access to the bases you want to use
- Copy the generated token
-
Find your base and table information
- Open your Airtable base in the browser
- The base ID is in the URL:
airtable.com/appXXXXXX/...(the part starting with “app”) - Note the table name you want to use
-
Add the Airtable node to your workflow
-
Configure the connection
- Paste your personal access token
- Enter the base ID and table name
- Choose the action: Create, Update, or Search records
- Map your workflow data to Airtable fields
-
Test the connection by running the workflow
Practical example: Product price tracker
Section titled “Practical example: Product price tracker”Let’s track competitor product prices in an Airtable base.
What you configure:
- Base ID: Your “Price Tracking” base
- Table: “Products”
- Action: Create record
- Fields mapping:
- Product Name: From Get All Text node
- Price: Extracted from the page
- URL: Current page URL
- Date: Today’s date
What happens:
- Your workflow visits product pages and extracts prices
- The Airtable node adds each product as a new row
- You build a historical price database automatically
Common settings
Section titled “Common settings”| Setting | Purpose | When to Use |
|---|---|---|
| Personal Access Token | Your Airtable API key | Required; create at airtable.com/create/tokens |
| Base ID | Target Airtable base | Found in your Airtable URL (starts with “app”) |
| Table Name | Target table within the base | The exact name as shown in Airtable |
| Action | Create, Update, or Search | Choose based on your workflow needs |
| Fields | Mapping data to columns | Match workflow outputs to Airtable field names |
Troubleshooting
Section titled “Troubleshooting”- Authentication failed: Verify your personal access token is correct and has the right scopes
- Base not found: Double-check the base ID from your Airtable URL
- Table not found: Ensure the table name matches exactly (case-sensitive)
- Field doesn’t exist: Check that the field names in your mapping match those in Airtable exactly
- Invalid field value: Some field types are picky (dates must be ISO format, linked records need record IDs)
Related nodes
Section titled “Related nodes”- Notion - Alternative for document-style databases
- Google Sheets - Another spreadsheet option