Turn weekly competitor ads into one creative brief with Apify and Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 13 nodes and runs on a schedule (cron 0 9 * * 1) (plus 1 other trigger). Along the way it connects Google Sheets, Slack, Notion and Apify (community).
How it runs
Trigger: On a schedule (cron 0 9 * * 1) (plus 1 other trigger).
- Who you are watching (Edit Fields (Set)): sets 6 fields: searchTerms, country, maxResults…
- Sample ads for testing (Code): runs custom JavaScript code
- Read the ad library (Apify): run actor and get dataset (actors)
- Count what repeats (Code): runs custom JavaScript code
- Keep ads with copy to read (Filter): keeps only the items that match a condition
- Write the brief row (Code): runs custom JavaScript code
- Skip ads already read (Remove Duplicates): removes duplicate items
- Save the weekly brief (Google Sheets): append
- Optional: read TikTok hooks instead (Apify): run actor and get dataset (actors)
- Optional: post the brief to Slack (Slack): uses Slack
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Read the ad library, Optional: read TikTok hooks instead).
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Apify
@apify/n8n-nodes-apify.apify - Filter
n8n-nodes-base.filter - Remove Duplicates
n8n-nodes-base.removeDuplicates - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack - Notion
n8n-nodes-base.notion
From the author
Quick overview This workflow runs weekly to scrape active competitor ads from the Meta Ads Library via Apify, summarizes recurring angles and hooks with OpenAI, and appends the resulting creative brief to Google Sheets. How it works 1. Runs every Monday at…