How to Bulk Check Google Ads Spend & Verify B2B Leads using Python and n8n (Zero-Budget Guide)

Description and use

Targeting leads based on verified ad spend transforms outbound response rates from the standard 1-2% up to 8-12%. Prospects appreciate outreach that references their actual live campaigns and creative choices rather than generic cookie-cutter templates.

Problem

Agencies and lead generators face two bottlenecks when prospecting via Google Ads: the official Ads Transparency Center UI only supports one advertiser domain at a time, and enterprise ad intelligence tools like Semrush or SpyFu cost $150–$300/month. This limits bulk prospect qualification and forces manual research.

Outcome

Targeting leads based on verified ad spend transforms outbound response rates from the standard 1-2% up to 8-12%. Prospects appreciate outreach that references their actual live campaigns and creative choices rather than generic cookie-cutter templates.

Workflow

• Input a list of prospect domains (CSV / CRM / manual list).
• Query the Google Ads Transparency Center gRPC endpoint (SearchService/SearchSuggestions) for each domain using Python urllib POST request with form-encoded payload.
• Parse the response, stripping the ')]}' JSON hijacking prefix, and extract verified advertiser name, country, and active ad counts across Search, YouTube, and Display.
• Categorize each domain into adSpendTier based on ad count thresholds: 50+ → Enterprise, 10–49 → Growth, 1–9 → Testing, 0 → None.
• Enrich each domain with email and WhatsApp contact via wa.me lookup.
• Generate a personalized cold pitch hook based on the tier and outreach angle.
• Optionally use Apify's cloud actor (Google Ads Transparency Scraper) or the open-source GitHub repository for production-grade handling of retries, pagination, and multi-country targeting.

Evidence

By directly querying the underlying gRPC/JSON endpoints, you can evaluate 1,000+ prospect domains in under 2 minutes.

Source

No Native Bulk Export: The official UI only supports looking up one single advertiser domain at a time.

Source

Tools like Semrush or SpyFu charge $150 to $300/month for ad intelligence subscriptions.

Source

Apify provides $5 free monthly credits, which is more than enough to test 5,000+ domain lookups.

Source

Targeting leads based on verified ad spend transforms outbound response rates from the standard 1-2% up to 8-