Skip to content
NEWMarketplace and your team: sell what you build, and get plans and changes that are tested before you see them. See what is new

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

  1. Manual start
  2. Configuration
  3. Validate configuration
  4. Read saved ads
  5. Start Actor
  6. Wait before poll
  7. Get run
  8. Check run status
  9. Run finished
  10. Get HEALTH
  11. Get TARGETS
  12. Get ads
  13. Prepare delivery
  14. Have rows

18 steps in total.

Similar automations