Google Maps B2B Leads to Google Sheets with Website Tech Audit & AI Icebreakers

Built with n8n
1

Hi everyone! :waving_hand:

I built an automated B2B lead generation & tech enrichment workflow for n8n that extracts Google Maps places, audits their website technical stack, and exports enriched leads into Google Sheets.

:rocket: What this workflow does:

  1. Scheduled Trigger: Runs on a recurring schedule (e.g., every Monday at 9 AM) or on demand.
  2. Apify Multi-Signal Extraction: Calls Apify (datalabs/google-maps-lead-enricher-tech-audit) to extract local businesses with verified emails, phones, social profiles (LinkedIn, Instagram, Facebook, X), WhatsApp links, SSL status, TTFB load speed, and active ad spend (Google Ads, Meta Pixel, TikTok).
  3. Smart Opportunity Filter: Automatically filters for high-intent prospects that have a verified contact email and an Opportunity Score ≥ 50.
  4. Google Sheets Sync: Appends the company name, email, phone, website, LinkedIn, WhatsApp link, and pre-synthesized cold outreach icebreaker directly into your sales spreadsheet.

:hammer_and_wrench: How to use:

  1. Copy the JSON code below and paste it directly into your n8n canvas (Ctrl+V / Cmd+V).
  2. In the HTTP Request node, insert your Apify API Token in the authentication query parameter (?token=YOUR_APIFY_TOKEN).
  3. Connect your Google Sheets account and select your target spreadsheet.

:clipboard: Workflow JSON (Copy & Paste into n8n):

Hope this helps streamline your outbound and agency prospecting pipelines! Feel free to ask any questions or share improvements.