Bibliothek / Web Scraping & Recherche
Web Scraping & Recherche
Konkurrenz-Snapshots von Google Ads aus Apify in Google Sheets protokollieren
Führt ein Apify-Actor nach Zeitplan aus, um die Google-Anzeigen eines Wettbewerbers zu erfassen, und fügt neue Anzeigen-IDs in ein Google-Sheets-Protokoll ein (Upsert), während ältere Zeilen erhalten bleiben.
Was sie bewirkt
# 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
Die Schritte
- 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
Insgesamt 18 Schritte.
Ähnliche Automatisierungen
Texterstellung & Content-GenerierungMeta-Video- und Bildanzeigen aus Drive mit OpenAI und Gemini erstellen49 SchritteSocial-Media-VeröffentlichungVideo- und Bildanzeigen aus Sheets zu Meta hochladen34 SchritteBild, Video & AudioFacebook-Videoanzeigen mit Veo 3 und Claude erstellen17 SchritteWeb Scraping & RechercheBildanzeigen aus der Meta-Werbebibliothek mit Apify und OpenAI analysieren16 Schritte