Airtable

LiveAPI Key

Automation

Overview

Automatically add identified companies and hot leads as records in your Airtable bases. ClearView creates new rows with full company details including name, domain, industry, employee count, lead score, and traffic source. Use Airtable's views, filters, and automations to manage your pipeline directly from the data ClearView provides.

What Gets Synced

New records - Each identified company or hot lead creates a new row in your specified table
Company details - Name, domain, industry, size, lead score, and source page
Timestamps - First seen and last seen dates for tracking engagement timeline

Supported Events

Event	Description
`company.identified`	Fires when a new company is identified visiting your site
`lead.hot`	Fires when a visitor is classified as a hot lead

Prerequisites

An Airtable account with a base and table ready to receive data
A Personal Access Token with data.records:write scope
Your Base ID and Table ID (or table name)
ClearView tracking script installed on your site

Setup Guide

Create a Personal Access Token

Go to airtable.com/create/tokens and click "Create new token". Give it a descriptive name like "ClearView Integration".

Add the required scope

Under Scopes, add data.records:write. This allows ClearView to create new records in your base.

Minimal permissions

ClearView only needs write access to create records. It does not need read, update, or delete permissions.

Add your base to the token

Under Access, click "Add a base" and select the base where ClearView should create records. Click "Create token" and copy the token (starts with pat_).

Save your token

Airtable only shows the token once. Copy it immediately and store it securely.

Find your Base ID

Open your base in Airtable. The Base ID is in the URL: airtable.com/appXXXXXXXXX/... Copy the part that starts with "app".

Find your Table ID

Click on the table you want to use. The Table ID appears in the URL after the Base ID: .../tblXXXXXXXX/... You can also use the table name as a string.

Configure in ClearView

Go to ClearView Dashboard > Integrations > Airtable. Enter your API key (pat_xxx), Base ID (appXXX), and Table ID. Select your events and save.

Prepare your table columns

Ensure your Airtable table has columns matching the data ClearView sends: Name (text), Domain (URL), Industry (text), Size (number), Lead Score (number), Source (URL).

Test the connection

Click the Test button in ClearView. Check your Airtable table for a new test record.

Configuration Fields

Field	Type	Description
`apiKey`	Secret	Personal Access Token (starts with pat_). Created at airtable.com/create/tokens.
`baseId`	String	Your Airtable Base ID (starts with app). Found in the base URL.
`tableId`	String	Your Table ID (starts with tbl) or table name. Found in the table URL.

Data Mapping

ClearView Field	Airtable Column	Field Type
Company Name	`Name`	Single line text
Domain	`Domain`	URL
Industry	`Industry`	Single line text
Employee Count	`Size`	Number
Lead Score	`Lead Score`	Number
Source Page	`Source`	URL
First Seen	`First Seen`	Date
Last Seen	`Last Seen`	Date

Example Record

ClearView creates records using the Airtable API. Here is the structure of a record creation request:

airtable_record.json

json

{
  "records": [
    {
      "fields": {
        "Name": "Acme Corp",
        "Domain": "https://acme.com",
        "Industry": "Technology",
        "Size": 250,
        "Lead Score": 87,
        "Source": "https://yoursite.com/pricing",
        "First Seen": "2026-03-20",
        "Last Seen": "2026-03-25"
      }
    }
  ]
}

Troubleshooting

AUTHENTICATION_REQUIRED error

Your Personal Access Token may be invalid or expired. Generate a new token at airtable.com/create/tokens and ensure it has the data.records:write scope and access to the correct base.

TABLE_NOT_FOUND error

Double-check your Base ID and Table ID. The Base ID starts with "app" and the Table ID starts with "tbl". Make sure the token has access to the specific base.

UNKNOWN_FIELD_NAME error

Ensure your Airtable table has columns with the exact names listed in the Data Mapping section above. Column names are case-sensitive.

Need Help?

Our team is here to help you get the Airtable integration running smoothly.

Contact Support