Monitor competitor TikTok ads and log new ones to Google Sheets

Scans the TikTok Ads Library for new competitor ads, logs them in a spreadsheet, and pings you when new ones appear.

How the work actually flows

A straight line. Runs once per each new ad found.

Pattern: Sequence (1) ยท Multiple Instances without a priori Run-Time Knowledge (15)

flowchart TD trig(["scheduled ad library check"]):::trigtime s0["search tiktok ads library"]:::svc s1["filter out duplicate ads"]:::task s2[["log new ads to spreadsheet"]]:::mi s3["send count notification"]:::svc trig --> s0 s0 --> s1 s1 -->|"one per each new ad found"| s2 s2 --> s3 out[/"spreadsheet of competitor ads updated"/]:::out pay{{"competitor creative tracked with no manual scrolling"}}:::pay s3 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepAn outside serviceRuns once per itemResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
Social Media ManagementMessaging & NotificationsSpreadsheet & Database OpsResearch & Market Intelligence
Connects
ApifyGoogle SheetsSlackTelegram

The problem it solves

Manually checking the TikTok Ads Library for competitor creatives eats up time you don't have, and it's easy to lose track of which ads you've already seen. You end up scrolling through the same ads over and over, unsure what's actually new.

Who it fits

Marketers or agencies who track competitor advertising on TikTok.

How it works

  1. A schedule runs the check daily or weekly
  2. It searches the TikTok Ads Library by advertiser or keyword
  3. New ads are matched against what's already logged to avoid duplicates
  4. New ads are added to a spreadsheet
  5. A short alert with the count of new ads is sent to Slack or Telegram
What you get

Competitor ad launches you'd otherwise miss

You get a running log of every new competitor TikTok ad, with an alert whenever fresh ones show up in the library.

What you get

An updated spreadsheet of competitor ads and a short notification of how many new ads were found.

What you need

A web scraping service account, and Google Sheets with Slack or Telegram accounts.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Spot viral TikTok and Instagram trends in your niche daily

Scans TikTok and Instagram every day, flags videos going viral in your niche, and emails you a trend report.

Advanced

Turn trending TikTok videos into carousel posts automatically

Finds trending TikTok videos and turns them into carousel posts for your team to review and publish.

Advanced

Find and score sales leads from X/Twitter conversations

Scans X/Twitter for people discussing your topic and ranks them as sales leads in a spreadsheet.

Standard

Get prioritized AI industry news translated into Japanese in Slack

Collects AI news, translates it into Japanese, and sends the most urgent stories straight to Slack.

Advanced
Back to the AI Playbook