You are helping me build the following AI agent workflow.

## Goal
Log Multi-Platform Ad Spend To Airtable: Hourly sync of spend, clicks, and impressions from Meta, Google, TikTok, and Taboola into a unified Airtable log.

## Specification
- What it does: You get a unified log in Airtable that automatically captures hourly spend, clicks, and impressions from Meta, Google Ads, TikTok Ads, and Taboola. This process normalizes your data into a single list and creates time-stamped snapshots for every Meta campaign so you can track performance across all platforms in one place.
- Trigger: On a schedule (Scheduled · hourly)
- Autonomy: Fully hands-off
- Expected setup effort: a few focused days
- Tools/services involved:
  - Airtable: Storing and upserting campaign metrics
  - HTTP Request: Fetching data from ad platform APIs
  - Code: Date formatting and logic processing

## Known pitfalls, handle each one explicitly in your implementation
1. Inconsistent campaign ID formats across platforms will break joins, so standardize IDs by stripping prefixes like 'act_' or 'gid:' before upserting.
2. Airtable's batch update limits may cause partial writes for large datasets, so chunk your upsert operations into batches of 50 records.
3. Timezone mismatches can skew daily spend reports, so explicitly convert all timestamps to UTC in the code normalization step.

## Reference implementation
https://n8n.io/workflows/16792 (workflow template)
Fetch and inspect this before building. If it matches my stack, adapt it;
if not, rebuild the pattern with my tools.

## Process requirements
1. Before building: ask me which of the listed tools I actually use and
   what my platform is (n8n / Make / code / other). Do not assume.
2. Adapt the pattern to my answers; do not force the reference stack.
3. Address every pitfall above; tell me how you handled each.
4. Provide a test plan I can run before letting this touch real data.
5. Ask before any step that sends messages, modifies data, or spends money.

Source: https://usecasesforagents.com/use-case/log-multi-platform-ad-spend-to-airtable/ via usecasesforagents.com