Monitor competitors’ Google Ads with Apify, Google Sheets, Slack and Gmail
UnknownWhat this workflow does
This workflow has 12 nodes and runs on a schedule (every day at 09:00) (plus 1 other trigger). Along the way it connects Google Sheets, Slack, Gmail and Apify (community).
How it runs
Trigger: On a schedule (every day at 09:00) (plus 1 other trigger).
- Workflow settings (Edit Fields (Set)): sets 6 fields: competitors, regions, maxAdsPerQuery…
- Post the error to Slack (Slack): post (message)
- Get new competitor ads (Apify): run actor and get dataset (actors)
- Keep creative rows only (Filter): keeps only the items that match a condition
- Append new ads to Google Sheet (Google Sheets): append
- Group new ads by advertiser (Code): runs custom JavaScript code
- Any new ads today? (If): checks a condition and branches into true / false
- Send digest to Slack (Slack): post (message)
- Campaign launch detected? (If): checks a condition and branches into true / false
- Email the launch alert (Gmail): uses Gmail
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 Get new competitor ads).
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Apify
@apify/n8n-nodes-apify.apify - Filter
n8n-nodes-base.filter - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Quick overview Runs the Google Ads Transparency Center Scraper Actor on Apify daily for the competitors you list, appends every new ad to Google Sheets, posts a per-advertiser digest to Slack and emails you through Gmail when a competitor launches many ads at…