Automate Ad Spend Logging to Airtable with Meta & Google

Streamline Your Ad Spend Tracking with Airtable Integration

Efficiently manage and track your ad expenditures across major platforms like Meta, Google Ads, TikTok Ads, and Taboola with the "Automate Ad Spend Logging to Airtable" workflow. Designed to run every hour, this powerful n8n automation seamlessly imports campaign spend, clicks, and impressions into Airtable, providing you with a clear, time-stamped overview of your advertising efforts.

What this workflow does

• Automates hourly data collection of ad metrics from Meta, Google Ads, TikTok Ads, and Taboola.
• Builds date values for API queries and filters, accommodating time zones like PST.
• Identifies ACTIVE and PAUSED campaigns from up to four Meta ad accounts and matches them with existing Airtable records.
• Fetches Meta campaign insights and upserts relevant metrics into Airtable while creating a time-slot snapshot for campaigns with non-zero spend.
• Retrieves and normalizes performance data from Google Ads, Taboola, and TikTok, upserting this data into the Airtable “Daily Ad Spend” table.

Use Cases

• Digital Marketing Agencies: Keep client ad spend records current and easily accessible.
• SaaS Operators: Monitor marketing performance efficiently to optimize ad campaigns.
• n8n Users and Automation Engineers: Simplify complex data import processes with set-and-forget automation.

Technical Details

• Integrates with Airtable (personal access token required), Meta Graph API, Google Ads (GAQL), TikTok Ads, and Taboola.
• Uses n8n nodes like if, code, filter, Airtable node, sticky note, and HTTP request to execute robust data operations.
• Set up involves creating Airtable connections and configuring Table IDs for both “Daily Ad Spend” and “Daily Snapshot” tables.