Google Ads Keyword Planner Demand Funnel PDF (n8n)

Build a Google Ads Keyword Planner Demand Funnel PDF for your drive-time trade area

This n8n workflow creates a demand + funnel report by generating a drive-time boundary around a location, pulling Google Ads Keyword Planner search volume and bid ranges for your keywords, modeling a conversion funnel, and exporting everything as a polished PDF with a boundary map.

What this workflow does

• Runs manually to load your location, trade-area settings, Google Ads configuration, and funnel assumptions.
• Requests a drive-time isochrone polygon from OpenRouteService, then samples points inside the polygon.
• Reverse-geocodes sampled points using OpenStreetMap Nominatim to collect unique ZIP codes within the trade area.
• Looks up Google Ads geo target constants for those ZIP codes and compiles your configured keyword list.
• Fetches Keyword Planner historical metrics via the Google Ads API Keyword Planner historical metrics endpoint, including average monthly searches and top-of-page bid ranges per keyword.
• Models funnel scenarios by calculating low/high price scenarios per category (impressions, clicks, landing page views, actions, customers, spend, and revenue).
• Generates a boundary map and PDF by building a static map URL with Geoapify, downloading the image, rendering an HTML report with tables and funnel charts, and converting it to a PDF using PDFShift.

Use cases

• Estimate realistic Google Ads demand and budget ranges for a local service business by drive time.
• Compare funnel impact using different funnel assumptions (low vs high price scenarios) for specific keyword categories.
• Create consistent sales/marketing reports for multiple locations using a repeatable n8n automation workflow.

Technical details

• Trigger: Manual Trigger
• Nodes/blocks: set, code, sticky note, http request, manual trigger
• External services: OpenRouteService (drive-time isochrones), OpenStreetMap Nominatim (reverse geocoding ZIPs), Google Ads API Keyword Planner (search volume + bid ranges), Geoapify (static map), PDFShift (PDF conversion)
• Setup: Add Google Ads OAuth2 credentials, Google Ads customer ID (and optional login customer ID), and a valid Google Ads developer token; configure an OpenRouteService API key.