Library / Web Scraping & Research
Web Scraping & Research
Log competitor Google Ads snapshots from Apify into Google Sheets
Runs an Apify actor on a schedule to capture a competitor's Google ads, then upserts new ad IDs into a Google Sheets log while keeping older rows.
What it does
# Track competitor Google ads in Google Sheets with Apify ## Who is this for? Marketing analysts who want a repeatable, bounded log of a competitor's Google ads without maintaining scraper infrastructure. ## What it does The workflow reads saved keys, launches one Apify Actor, waits for completion, checks HEALTH/TARGETS and upserts records into Google Sheets. An empty scope starts a baseline. Later unseen IDs are logged; first-seen time does not prove publication time. Older rows are retained. ## Setup Create a private Ads tab using the supplied CSV headers. Import the inactive workflow. In Configuration, set your spreadsheet ID and Actor input. Connect Header Auth on five Apify HTTP nodes and Google Sheets OAuth2 on both Sheets nodes. Run manually twice, inspect reports and check stable keys before activating the daily 09:00 UTC schedule. Keep Start Actor's Execute Once enabled and run sequentially. ## Requirements and customization Use your own Apify account/token and Google spreadsheet edit access. Defaults: one domain, US, 20 ads, details off, Actor tracking off and a $0.10 Actor charge cap. Hosting and other service costs are separate. Change the domain/region for your use case; each filter scope establishes its own baseline. Tested on self-hosted n8n 2.26.4. Other environments need validation. This is not a complete competitor inventory and sends no notifications. Setup guide and headers
The steps
- Manual start
- Configuration
- Validate configuration
- Read saved ads
- Start Actor
- Wait before poll
- Get run
- Check run status
- Run finished
- Get HEALTH
- Get TARGETS
- Get ads
- Prepare delivery
- Have rows
18 steps in total.
Similar automations
Content Writing & GenerationCreate Meta Video and Image Ads from Drive with OpenAI and Gemini49 stepsReports, Analytics & DashboardsAnalyze Competitor Facebook Ads with OpenAI and Gemini13 stepsReports, Analytics & DashboardsAnalyze Facebook Ads Competitor Creatives and Email Recommendations with OpenAI24 stepsWeb Scraping & ResearchAnalyze Meta Ad Library Image Ads with Apify and OpenAI16 steps