January 22, 2026

Apify + Google Sheets: TikTok ads log stays clean

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Checking the TikTok Ads Library “real quick” turns into a daily rabbit hole. Then you still have to copy links, names, and screenshots into a spreadsheet, and you’re never fully sure you didn’t log the same ad twice.

This TikTok ads log automation hits performance marketers first, but agency owners and growth-focused operators feel it too. The outcome is simple: a clean, always-updated Google Sheet that only adds truly new creatives, plus a short Slack or Telegram ping when something changes.

Below you’ll see exactly how this n8n workflow watches the library via Apify, de-dupes by adId, updates your log, and keeps notifications quiet unless there’s something worth looking at.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Apify + Google Sheets: TikTok ads log stays clean

Click to explore

flowchart LR

    subgraph sg0["Schedule Flow"]
        direction LR
        n0@{ icon: "mdi:swap-vertical", form: "rounded", label: "Set Parameters", pos: "b", h: 48 }
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Convert Dates to Unix"]
        n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Build Apify Body"]
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Prepare Data for Sheets"]
        n4@{ icon: "mdi:database", form: "rounded", label: "Read existing IDs", pos: "b", h: 48 }
        n5["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Collect ID list"]
        n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Attach existing ids"]
        n7["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Filter new creatives"]
        n8["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Count new ads"]
        n9@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Any new ads?", pos: "b", h: 48 }
        n10@{ icon: "mdi:database", form: "rounded", label: "Append or update row in sheet", pos: "b", h: 48 }
        n11["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/slack.svg' width='40' height='40' /></div><br/>Send a message"]
        n12["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/telegram.svg' width='40' height='40' /></div><br/>Send a text message"]
        n13@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Get TT Ads through Apify", pos: "b", h: 48 }
        n14@{ icon: "mdi:play-circle", form: "rounded", label: "Schedule Trigger", pos: "b", h: 48 }
        n9 --> n12
        n9 --> n11
        n8 --> n9
        n0 --> n1
        n5 --> n6
        n2 --> n13
        n14 --> n0
        n4 --> n5
        n6 --> n7
        n7 --> n10
        n7 --> n8
        n1 --> n2
        n3 --> n4
        n3 --> n6
        n13 --> n3
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n14 trigger
    class n9,n13 decision
    class n4,n10 database
    class n1,n2,n3,n5,n7,n8 code
    classDef customIcon fill:none,stroke:none
    class n1,n2,n3,n5,n6,n7,n8,n11,n12 customIcon

The Problem: Competitor ad tracking turns into messy busywork

Competitor monitoring sounds straightforward until you actually do it for a week. You search the TikTok Ads Library, open a bunch of creatives, copy details into a sheet, and promise yourself you’ll “clean it up later.” Later rarely comes. The log becomes inconsistent (different naming, missing fields, broken links), and duplicates sneak in because you’re working from memory. Worst part: you end up spending your best thinking time collecting data instead of learning from it.

The friction compounds. Here’s where it breaks down.

You re-check ads you already saw because there’s no reliable “already logged” system.
Manual copy-paste introduces little errors that ruin analysis later (wrong advertiser, missing IDs, mismatched dates).
Your sheet grows, but it doesn’t stay usable, so nobody trusts it when it’s time to make decisions.
Notifications become noise when you share updates, so the team stops paying attention.

The Solution: Scheduled scraping + de-duplication + clean logging

This workflow runs on a schedule and searches the TikTok Ads Library the same way you would, but without the manual clicking. n8n builds a request (country, date range, advertiser IDs, or keyword searches), then Apify scrapes the matching creatives and returns structured data. From there, the workflow formats each result for your spreadsheet, reads the existing adId values already logged, and filters out anything you’ve seen before. Only fresh creatives get written to Google Sheets, using adId as the “match” key so re-runs stay safe. Finally, if new ads exist, you get a short Slack or Telegram message with the count and a link to the sheet. If nothing changed, it stays silent.

The workflow starts with a Scheduled Automation Trigger and a simple “input options” node where you define what to track. Apify fetches and returns the ads, then n8n compares their IDs against your sheet before upserting rows and sending a lightweight notification.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

It scrapes TikTok Ads Library results through Apify based on your advertiser IDs or keyword searches.
It converts your date range into the Unix format the API expects, so recurring searches stay consistent.
It reads your existing Google Sheet adId column and filters out duplicates before writing anything.
It posts a short Slack or Telegram update only when new creatives were discovered.

Most teams get about 3–5 hours back per week once this runs daily.
Your competitor log stays clean because adId acts as the single source of truth.
You can trust your dataset enough to do real pattern spotting (hooks, formats, offers, angles).
Fewer “false alarms” in Slack, which means people actually open the sheet when pinged.
Reruns are safe, so you can schedule it without babysitting.

Example: What This Looks Like

Say you track 8 competitors and do a quick check each morning. If you spend about 10 minutes per competitor opening creatives and logging details, that’s roughly 80 minutes a day, plus the inevitable “did I already log this one?” backtracking. With this workflow, the daily routine becomes: set it once, let the scheduled run scrape and de-dupe, then glance at a Slack/Telegram message that says “6 new ads” and open the sheet when it’s worth it. The human time drops to maybe 5 minutes a day.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Apify to scrape TikTok Ads Library results
Google Sheets to store your clean competitor log
Slack or Telegram for “new ads found” notifications
Apify API token (get it from Apify Console settings)

Skill level: Intermediate. You’ll connect accounts, paste an API token, and confirm your Sheet columns match the workflow mapping.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A scheduled run kicks things off. You choose a cadence (every morning is common), and the workflow pulls “yesterday to today” by default so you’re always scanning the newest window.

Your search parameters get cleaned up. n8n stores your inputs (country, keyword, advertiser business IDs, optional result limit), then converts dates into Unix timestamps so the request behaves the same way every time.

Apify retrieves the ad results, then n8n filters them. The workflow extracts key fields like adId, video URLs, cover image, advertiser details, and username. Next it reads the adId column from Google Sheets, merges that “existing ID list” into the current run, and keeps only ads that are truly new. It even prevents duplicates inside the same scrape batch.

Google Sheets gets an upsert, not a messy append. New creatives are appended or updated using adId as the matching column, and cover images can be displayed via an =IMAGE() formula so your log becomes browsable, not just “data storage.”

You can easily modify the search inputs (country, advertiser IDs, or keyword logic) to match how you monitor competitors. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Scheduled Automation Trigger

Set the schedule that starts the automation and feeds default inputs into the workflow.

Open Scheduled Automation Trigger and configure the schedule rule that matches your monitoring cadence.
Verify Scheduled Automation Trigger connects to Define Input Options as shown in the workflow connections.

Step 2: Define Input Parameters and Date Conversion

Provide the ad search filters and convert human-readable dates into Unix timestamps for the API request.

In Define Input Options, set Ad target country to all.
Set Ad published date From (DD/MM/YYYY) to {{ $now.minus({ days: 1 }).toFormat('dd/MM/yyyy') }} and Ad published To (DD/MM/YYYY) to {{ $now.toFormat('dd/MM/yyyy') }}.
Update adv_biz_ids to your advertiser ID in the format [YOUR_ID], and optionally fill Advertiser name or keyword or Ad limit.
Confirm Transform Dates to Unix follows Define Input Options to generate start_time_unix and end_time_unix.

⚠️ Common Pitfall: If your date format does not match DD/MM/YYYY, Transform Dates to Unix will throw an error and stop the run.

Step 3: Build and Run the Apify Request

Create the custom payload for the TikTok Ads actor and execute the Apify run.

Open Assemble Apify Payload and keep the logic that builds the URL and JSON body for the actor request.
In Retrieve TikTok Ads, set Operation to Run actor and get dataset and map Custom Body to {{ $json.customBody }}.
Credential Required: Connect your apifyApi credentials in Retrieve TikTok Ads.

Tip: If you use Ad limit in Define Input Options, Assemble Apify Payload automatically injects resultsLimit into the JSON body.

Step 4: Prepare, De-duplicate, and Identify New Ads

Normalize the response, load existing IDs from Google Sheets, and filter only new creatives.

Review Format Rows for Sheets to ensure videoUrl, coverImageUrl, and tiktokUsername are safely extracted for each ad.
Format Rows for Sheets outputs to both Load Existing IDs and Merge Prior IDs in parallel.
In Load Existing IDs, set the Document ID to [YOUR_ID] and Range to K:K for the existing adId column.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Load Existing IDs.
Confirm Gather ID Catalog feeds into Merge Prior IDs, and then Filter Fresh Creatives removes any ads already found in Sheets.

Tip: There are multiple code nodes (6 total). Keep them as-is to avoid data type mismatches during de-duplication.

Step 5: Write New Ads and Send Notifications

Insert or update new ads in Google Sheets and notify your channels if any were found.

Filter Fresh Creatives outputs to both Upsert Sheet Rows and Tally New Ads in parallel.
In Upsert Sheet Rows, confirm Operation is appendOrUpdate and the column mappings use expressions like {{ $json.adId }} and {{ $json.coverImageUrl ? `=IMAGE("${$json.coverImageUrl}"; 1)` : '' }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Upsert Sheet Rows.
Tally New Ads feeds into Check New Ads with a numeric condition {{ $json.newCount }} > 0.
Check New Ads outputs to both Send Telegram Update and Post Slack Update in parallel.
Credential Required: Connect your telegramApi credentials in Send Telegram Update and set Chat ID to [YOUR_ID].
Credential Required: Connect your Slack credentials in Post Slack Update and select the target Channel.
Keep the message content in both notification nodes as Hello! {{$json.newCount}} TikTok ads were found today. Review the list in your spreadsheet..

⚠️ Common Pitfall: Post Slack Update has no credentials configured in the workflow JSON—be sure to add them or Slack messages will fail.

Step 6: Test and Activate Your Workflow

Run a manual test to validate the flow, then enable the schedule for production.

Click Execute Workflow to run the full flow from Scheduled Automation Trigger onward.
Confirm new rows appear in Google Sheets through Upsert Sheet Rows, and that Tally New Ads outputs a newCount value.
If newCount is greater than zero, verify both Send Telegram Update and Post Slack Update deliver messages in parallel.
Once verified, toggle the workflow to Active to allow Scheduled Automation Trigger to run on its schedule.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Apify credentials can expire or the actor can require the right access. If things break, check your Apify token and actor permissions in the Apify Console first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Google Sheets upsert depends on your matching column. If adId isn’t in the expected column/range (or the sheet header changed), duplicates will slip in even though the workflow “ran successfully.”

Frequently Asked Questions

How long does it take to set up this TikTok ads log automation?

About 30–60 minutes if your Apify, Google Sheets, and Slack/Telegram accounts are ready.

Do I need coding skills to automate TikTok ads logging?

No. You will mostly connect accounts and paste an Apify token. The only “technical” part is making sure your Google Sheet has the expected columns.

Is n8n free to use for this TikTok ads log workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Apify usage costs for the TikTok Ads Scraper actor.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this TikTok ads log workflow for tracking multiple advertisers at once?

Yes, and it’s a common upgrade. You can turn the advertiser business IDs (adv_biz_ids) in the “Define Input Options” node into a list, then loop over it so each run checks multiple competitors. Another option is switching from advertiser IDs to keyword-based searches by changing the same input node, then letting the “Assemble Apify Payload” logic build the right URL. Most people also tweak the Slack/Telegram message to include the date range or advertiser label.

Why is my Apify connection failing in this workflow?

Usually it’s an expired or incorrect Apify API token in n8n. Regenerate the token in Apify, update the credential used by “Retrieve TikTok Ads,” and try a manual run. If it still fails, check that your Apify plan/actor access includes the TikTok Ads Scraper actor, and watch for rate limits if you’re scraping large result sets.

How many ads can this TikTok ads log automation handle?

A lot, as long as your Apify run and your n8n plan can keep up.

Is this TikTok ads log automation better than using Zapier or Make?

Often, yes, because this is not a simple “if new row then send message” flow. You need safe reruns, de-duplication, and an upsert strategy based on adId, plus some light data shaping before writing to Sheets. n8n handles branching and code steps without turning every extra filter into another paid task. Zapier or Make can still work if you already live there, but you’ll likely spend more time fighting edge cases like duplicate handling. If you want help deciding, Talk to an automation expert and bring your exact volume and reporting needs.

You get a competitor log that stays trustworthy, even when you stop thinking about it. Set the schedule, keep the sheet link handy, and use the time you saved to actually make better creative decisions.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": "",
"meta": {
"instanceId": "0ccb11871fd36c3000e59335642db8d3eb724db365023e009a9ec60680d1b12e"
},
"name": "Automated Ads Monitoring Workflow",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-11615",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 800,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "7c1b1a25-2ce6-48a4-9226-7d0158b3e98c",
"name": "Scheduled Automation Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
690,
135
],
"parameters": {
"rule": {
"interval": [
[]
]
}
},
"typeVersion": 1.2
},
{
"id": "204f29b8-31d7-4c68-bef8-0f46b882376a",
"name": "Define Input Options",
"type": "n8n-nodes-base.set",
"position": [
415,
120
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "c39dfde7-66b4-4ca2-97b2-d134b4f24502",
"name": "Ad target country",
"type": "string",
"value": "all"
},
{
"id": "92724e8e-d4b6-4a27-8460-dc9d0073c124",
"name": "Ad published date From (DD/MM/YYYY)",
"type": "string",
"value": "={{ $now.minus({ days: 1 }).toFormat('dd/MM/yyyy') }}"
},
{
"id": "30f957d6-f3e2-46f8-8f35-2a836d3f5fcd",
"name": "Ad published To (DD/MM/YYYY)",
"type": "string",
"value": "={{ $now.toFormat('dd/MM/yyyy') }}"
},
{
"id": "32bf3fc0-d6c1-469c-908a-84feb0653b71",
"name": "Advertiser name or keyword",
"type": "string",
"value": ""
},
{
"id": "83371530-fba9-456e-9a50-28aa52981106",
"name": "adv_biz_ids",
"type": "string",
"value": "[YOUR_ID]"
},
{
"id": "06bdf732-62ca-409a-a38a-2df29e58dbbb",
"name": "Ad limit",
"type": "string",
"value": ""
}
]
}
},
"typeVersion": 3.4
},
{
"id": "1e175c48-7bbd-4b5b-bed4-b7f16a78b6f6",
"name": "Transform Dates to Unix",
"type": "n8n-nodes-base.code",
"position": [
225,
140
],
"parameters": {
"jsCode": "// Convert dates from DD/MM/YYYY to Unix timestamp (milliseconds)\nconst input = $input.first().json;\n\nfunction dateToUnix(dateStr) {\n  if (!dateStr || dateStr.trim() === '') return null;\n  \n  // Parse DD/MM/YYYY format\n  const parts = dateStr.split('/');\n  if (parts.length !== 3) {\n    throw new Error(`Invalid date format: ${dateStr}. Expected DD/MM/YYYY`);\n  }\n  \n  const day = parseInt(parts[0], 10);\n  const month = parseInt(parts[1], 10) - 1; // Month is 0-indexed in JavaScript\n  const year = parseInt(parts[2], 10);\n  \n  // Create date object and convert to Unix timestamp in milliseconds\n  const date = new Date(year, month, day);\n  return date.getTime();\n}\n\nconst startTimeUnix = dateToUnix(input['Ad published date From (DD/MM/YYYY)']);\nconst endTimeUnix = dateToUnix(input['Ad published To (DD/MM/YYYY)']);\n\n// Return all original fields plus converted timestamps\nreturn {\n  json: {\n    ...input,\n    start_time_unix: startTimeUnix,\n    end_time_unix: endTimeUnix\n  }\n};"
},
"typeVersion": 2
},
{
"id": "ea56c4d8-d916-41f4-92ab-4fa2f92081f7",
"name": "Assemble Apify Payload",
"type": "n8n-nodes-base.code",
"position": [
5,
310
],
"parameters": {
"jsCode": "// Build customBody JSON with conditional resultsLimit\nconst input = $input.first().json;\n\n// Get adv_biz_ids from input\nconst advBizIds = input.adv_biz_ids || '';\n\n// Build URL with conditional adv_biz_ids parameter\nlet url = `https://library.tiktok.com/ads?region=${input['Ad target country']}&start_time=${input.start_time_unix}&end_time=${input.end_time_unix}&adv_name=${input['Advertiser name or keyword']}`;\n\n// Add adv_biz_ids only if it's not empty\nif (advBizIds && advBizIds.trim() !== '') {\n  url += `&adv_biz_ids=${advBizIds}`;\n} else {\n  url += `&adv_biz_ids=`;\n}\n\nurl += `&query_type=1&sort_type=last_shown_date,desc`;\n\n// Build the base object\nconst body = {\n  skipDetails: false,\n  startUrls: [\n    {\n      url: url\n    }\n  ]\n};\n\n// Add resultsLimit only if Ad limit is not empty\nif (input['Ad limit'] && input['Ad limit'].trim() !== '') {\n  const limit = parseInt(input['Ad limit'], 10);\n  if (!isNaN(limit) && limit > 0) {\n    body.resultsLimit = limit;\n  }\n}\n\n// Return the JSON string for customBody\nreturn {\n  json: {\n    ...input,\n    customBody: JSON.stringify(body, null, 2)\n  }\n};"
},
"typeVersion": 2
},
{
"id": "00ea4eb6-6dbd-401b-a865-de40421a3ca2",
"name": "Retrieve TikTok Ads",
"type": "@apify/n8n-nodes-apify.apify",
"position": [
180,
335
],
"parameters": {
"actorId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Tiktok Ads Scraper"
},
"operation": "Run actor and get dataset",
"customBody": "={{ $json.customBody }}"
},
"credentials": {
"apifyApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "55a900ff-ca28-49a7-b662-d542b5a2e39e",
"name": "Format Rows for Sheets",
"type": "n8n-nodes-base.code",
"position": [
480,
315
],
"parameters": {
"jsCode": "// Safely extract video data and prepare for Google Sheets\n// Process all input items\nconst items = $input.all();\n\nreturn items.map(item => {\n  const input = item.json;\n  \n  // Safely get first video URL\n  const videoUrl = (input.videos && Array.isArray(input.videos) && input.videos.length > 0 && input.videos[0].url) \n    ? input.videos[0].url \n    : '';\n  \n  // Safely get cover image URL\n  const coverImageUrl = (input.videos && Array.isArray(input.videos) && input.videos.length > 0 && input.videos[0].coverImageUrl) \n    ? input.videos[0].coverImageUrl \n    : '';\n  \n  // Safely get tiktokUser username\n  const tiktokUsername = (input.tiktokUser && input.tiktokUser.username) \n    ? input.tiktokUser.username \n    : '';\n  \n  // Return all original data plus safely extracted fields\n  return {\n    json: {\n      ...input,\n      videoUrl: videoUrl,\n      coverImageUrl: coverImageUrl,\n      tiktokUsername: tiktokUsername\n    }\n  };\n});"
},
"typeVersion": 2
},
{
"id": "3804ed9d-b6ea-44d5-af30-ad22998e4e5c",
"name": "Load Existing IDs",
"type": "n8n-nodes-base.googleSheets",
"position": [
700,
535
],
"parameters": {
"options": {
"dataLocationOnSheet": {
"values": {
"range": "K:K",
"rangeDefinition": "specifyRangeA1"
}
}
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Ads Research Sheet"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "2df43f3d-b374-4fe4-ac0c-609147c6b566",
"name": "Gather ID Catalog",
"type": "n8n-nodes-base.code",
"position": [
420,
585
],
"parameters": {
"jsCode": "// Collect existing IDs from Google Sheets\nconst items = $input.all();\n\nconst ids = items\n  .map(item => item.json.adId)\n  // Cast all values to strings to avoid mismatches like \"123\" vs 123\n  .map(id => id != null ? String(id) : undefined)\n  .filter((id, index, arr) => id && arr.indexOf(id) === index);\n\nreturn [{ json: { existingIds: ids } }];"
},
"typeVersion": 2
},
{
"id": "7d08dbfc-2d45-4098-92f1-900a6301eb80",
"name": "Merge Prior IDs",
"type": "n8n-nodes-base.merge",
"position": [
235,
500
],
"parameters": {
"mode": "combine",
"options": [],
"combineBy": "combineAll"
},
"typeVersion": 3.2
},
{
"id": "f96de8ba-6796-4772-9100-213a4112568d",
"name": "Filter Fresh Creatives",
"type": "n8n-nodes-base.code",
"position": [
0,
770
],
"parameters": {
"jsCode": "// Filter new ads that don't exist in Google Sheets\nconst items = $input.all();\nconst input = items[0].json;\n\n// Get existing IDs from merged data\nconst existingIds = (input.existingIds || []).map(id => id != null ? String(id) : undefined).filter(Boolean);\nconst seen = new Set(existingIds);\n\n// Get all ads from items (skip first item which contains existingIds)\nconst ads = items.slice(1).map(item => item.json);\nconst newAds = [];\n\nfor (const ad of ads) {\n  if (!ad?.adId) continue;\n  const adId = String(ad.adId);\n  if (!seen.has(adId)) {\n    newAds.push(ad);\n    seen.add(adId); // protect against duplicates within a single run\n  }\n}\n\n// Return new ads as separate items\nreturn newAds.map(ad => ({ json: ad }));"
},
"typeVersion": 2
},
{
"id": "25aae637-70ec-4a31-81fd-974b6e47ffcc",
"name": "Upsert Sheet Rows",
"type": "n8n-nodes-base.googleSheets",
"position": [
220,
700
],
"parameters": {
"columns": {
"value": {
"adId": "={{ $json.adId }}",
"adName": "={{ $json.adName }}",
"paidBy": "={{ $json.paidBy }}",
"videos": "={{ $json.videoUrl }}",
"startURL": "={{ $json.startUrl }}",
"targeting": "={{ $json.targeting }}",
"tiktokUser": "={{ $json.tiktokUsername }}",
"Impressions": "={{ $json.impressions }}",
"regionStats": "={{ $json.regionStats }}",
"advertiserID": "={{ $json.advertiserId }}",
"coverImageURL": "={{ $json.coverImageUrl ? `=IMAGE(\"${$json.coverImageUrl}\"; 1)` : '' }}",
"advertiserName": "={{ $json.advertiserName }}"
},
"schema": [
{
"id": "coverImageURL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "coverImageURL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "videos",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "videos",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "adName",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "adName",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Impressions",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Impressions",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "regionStats",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "regionStats",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "targeting",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "targeting",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tiktokUser",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "tiktokUser",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "startURL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "startURL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "paidBy",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "paidBy",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "advertiserName",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "advertiserName",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "adId",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "adId",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "advertiserID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "advertiserID",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"adId"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Ads Research Sheet"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "4821abfe-854f-41a4-afce-1a4cb09805fb",
"name": "Tally New Ads",
"type": "n8n-nodes-base.code",
"position": [
490,
780
],
"parameters": {
"jsCode": "// Count new ads\nconst items = $input.all();\nreturn [{\n  json: {\n    newCount: items.length\n  }\n}];"
},
"typeVersion": 2
},
{
"id": "e352dc0a-0fb9-42a1-8110-aa6ceeda45b0",
"name": "Check New Ads",
"type": "n8n-nodes-base.if",
"position": [
660,
965
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d0e1f2a3-b4c5-6789-0123-456789012345",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.newCount }}",
"rightValue": 0
}
]
}
},
"typeVersion": 2.2
},
{
"id": "3ac92c9f-5416-462a-a0f1-c5efc68217f1",
"name": "Post Slack Update",
"type": "n8n-nodes-base.slack",
"position": [
435,
890
],
"webhookId": "a3b4c5d6-e7f8-9012-3456-789012345678",
"parameters": {
"text": "=Hello!\n{{$json.newCount}} TikTok ads were found today.\nReview the list in your spreadsheet.",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": ""
},
"otherOptions": []
},
"typeVersion": 2.3
},
{
"id": "183b249c-fdcc-40ca-a489-1a09f07c608c",
"name": "Send Telegram Update",
"type": "n8n-nodes-base.telegram",
"position": [
205,
1020
],
"webhookId": "b4c5d6e7-f8a9-0123-4567-890123456789",
"parameters": {
"text": "=Hello!\n{{$json.newCount}} TikTok ads were found today.\nReview the list in your spreadsheet.",
"chatId": "[YOUR_ID]",
"additionalFields": []
},
"credentials": {
"telegramApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"Check New Ads": {
"main": [
[
{
"node": "Send Telegram Update",
"type": "main",
"index": 0
},
{
"node": "Post Slack Update",
"type": "main",
"index": 0
}
]
]
},
"Tally New Ads": {
"main": [
[
{
"node": "Check New Ads",
"type": "main",
"index": 0
}
]
]
},
"Define Input Options": {
"main": [
[
{
"node": "Transform Dates to Unix",
"type": "main",
"index": 0
}
]
]
},
"Gather ID Catalog": {
"main": [
[
{
"node": "Merge Prior IDs",
"type": "main",
"index": 1
}
]
]
},
"Assemble Apify Payload": {
"main": [
[
{
"node": "Retrieve TikTok Ads",
"type": "main",
"index": 0
}
]
]
},
"Scheduled Automation Trigger": {
"main": [
[
{
"node": "Define Input Options",
"type": "main",
"index": 0
}
]
]
},
"Load Existing IDs": {
"main": [
[
{
"node": "Gather ID Catalog",
"type": "main",
"index": 0
}
]
]
},
"Merge Prior IDs": {
"main": [
[
{
"node": "Filter Fresh Creatives",
"type": "main",
"index": 0
}
]
]
},
"Filter Fresh Creatives": {
"main": [
[
{
"node": "Upsert Sheet Rows",
"type": "main",
"index": 0
},
{
"node": "Tally New Ads",
"type": "main",
"index": 0
}
]
]
},
"Transform Dates to Unix": {
"main": [
[
{
"node": "Assemble Apify Payload",
"type": "main",
"index": 0
}
]
]
},
"Format Rows for Sheets": {
"main": [
[
{
"node": "Load Existing IDs",
"type": "main",
"index": 0
},
{
"node": "Merge Prior IDs",
"type": "main",
"index": 0
}
]
]
},
"Retrieve TikTok Ads": {
"main": [
[
{
"node": "Format Rows for Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}