how i build thousands of meta ads with airtable in 2026

Adtable.ai: Bulk Ads Creation System – Detailed Overview

Key Concepts:

Adtable.ai: A web application built on top of Air Table designed for bulk ad creation and management across Meta Ads and Google Ads.
Air Table Integration: The core of the system, utilizing Air Table’s database capabilities for organizing and automating ad creation processes.
Reference Tables: Air Table tables containing essential data like ad accounts, pixels, audiences, placements, and creative assets.
Webhooks: Automated triggers that initiate ad creation processes in Adtable.ai when changes are made in Air Table.
Advantage+ Campaigns: Meta’s automated campaign optimization features, supported within the system.
Creative Enhancements: Features like dynamic creative and automated A/B testing within Meta Ads.
Payload: The structured data package sent to the ad platforms (Meta, Google) to create ads.

1. System Overview & Account Connection

Adtable.ai streamlines ad creation by centralizing data and automating processes within Air Table. The system connects to multiple platforms including Air Table, Meta Ads, Google Drive, and Frame.io. The initial setup involves connecting these accounts to facilitate seamless data flow. The primary goal is to automate the upload of creatives from Google Drive or Frame.io directly into the corresponding ad accounts.

2. Creative Asset Management – The Creative Upload Database

The “Creative Upload Database” within Air Table is central to the workflow. Users input the Google Drive folder containing creatives and specify the target ad account. Upon uploading new files to the designated folder, Adtable.ai automatically uploads them to the specified ad account, generating a unique “Asset ID” crucial for ad building.

The system offers multiple Air Table views for creative management:

Today’s Uploads: Displays recently uploaded creatives.
Upload Queue: Shows ads awaiting upload.
Creative Gallery: Provides a visual overview of all available creatives.

3. Reference Tables – Data Centralization

Adtable.ai relies heavily on “reference tables” within Air Table to store and organize critical data. These tables include:

Ad Account Table: Contains details like ad account IDs, pixels, Facebook/Instagram pages, and linked landing pages. It also pulls in existing campaigns and ad sets for launching ads into pre-existing structures.
Placement Selection Table: Allows for custom combinations of ad placements across different platforms (Facebook, Instagram, Audience Network, etc.).
Custom Audiences Table: Stores defined target audiences for ad campaigns.
Demographic Targeting Table: Includes data on countries, states, cities, and zip codes for granular targeting.
Creative Enhancements Table: Allows users to manually select or globally enable/disable creative enhancements within Meta Ads.

4. Reporting & Analytics Views

Adtable.ai provides reporting views within Air Table to track ad performance:

Top Ad Copy View: Aggregates ad copy variations across all ads, displaying performance trends over the last 7 days, 30 days, and year-to-date. This helps identify high-performing ad copy.
Top Ads View: Provides a breakdown of top-performing ads, including post IDs for potential reuse in future campaigns.

5. Campaign, Adset, and Ad Creation – The Build View

The “Build View” is where users create campaigns, ad sets, and ads. Each view is configured with specific fields relevant to its purpose.

5.1 Campaign Creation:

Record Creation: Clicking into the campaign view automatically creates a new record.
Campaign Settings: Users can define campaign status (paused/active), campaign type (Advantage+ campaigns supported), budget (CBO or Advantage+), campaign objective (leads, sales, traffic), and special ad categories (for restricted industries).
Account Selection: The target ad account is selected from the Ad Account Table.
Naming Convention: Campaign names can be manually entered or dynamically generated using Air Table formulas.
Webhook Trigger: Changing the table action to “Create Campaign” triggers a webhook, initiating the ad creation process.

5.2 Adset Creation:

Automatic Campaign Linking: Adset rows automatically link to the previously created campaign.
Adset Settings: Users define adset description, ad account, pixel, launch date, Advantage+ audience targeting, custom audience inclusion/exclusion, age and gender targeting, and geographic targeting (countries, states, cities, zip codes).
Budget & Bid Strategy: Users can set adset budgets, minimum/maximum daily spend limits, and bid strategies (lowest cost, cost cap, etc.).
Bulk Adset Creation: The system allows for the creation of multiple ad sets simultaneously by adjusting the “Adsets per Campaign” field. This enables rapid scaling of campaigns.

5.3 Ad Creation:

Adset Association: Ad rows are associated with specific ad sets.
Creative Selection: Creatives are selected from the Creative Table, with options for single assets or customized assets for different placements (e.g., 9x6 for stories/reels, square for feeds).
Landing Page Selection: The target landing page is selected from the Landing Pages Table.
Ad Copy: Users input five variations of post text and headlines, a link description, and a call-to-action (CTA).
AI-Powered Ad Copy Generation: Air Table’s AI capabilities can generate new ad copy based on top-performing ads.
UTM Parameters: Custom UTM parameters can be added for tracking.
Creative Enhancements: Users select desired creative enhancements.
Webhook Trigger: Changing the table action to “Create Ads” triggers a webhook, initiating ad creation.

6. Technical Implementation & Workflow

The core of Adtable.ai’s functionality lies in its integration with Air Table and the use of webhooks. When a table action (e.g., “Create Campaign”) is triggered, a webhook sends data to Adtable.ai’s web application. This application then assembles the data into the correct payload format required by the ad platforms (Meta, Google) and initiates ad creation. The system provides a direct link to the ad account within Ads Manager for spot-checking and verification.

Quote: "What's happening behind the scenes is essentially our web app that we've built on top of air tableable is connected to your base your air table base and we have a web hook that essentially is triggered whenever the table action is changed to create campaigns or create adsets or create ads and then um our scripts basically take all the data from your air table assemble it correctly for the payload and build the ads with it." – Caleb (Creator of Adtable.ai)

Conclusion:

Adtable.ai offers a powerful solution for automating and scaling ad creation processes. By leveraging Air Table’s database capabilities and integrating with major ad platforms, the system streamlines workflows, reduces manual effort, and enables rapid campaign deployment. The emphasis on reference tables, customizable naming conventions, and AI-powered ad copy generation provides users with a high degree of control and flexibility. The system’s ability to create and launch multiple ad sets and ads simultaneously significantly accelerates campaign build times.