Apify Google Maps Lead Audit with LatentLark & Google Sheets (n8n)

Audit Google Maps leads at scale—automatically

This n8n workflow pulls new business leads from Google Maps via Apify, audits each business website with LatentLark Local Lead Audit to uncover outreach angles, and then appends the enriched results to Google Sheets. Set it to run weekly (Monday 08:00) or trigger it manually to keep your lead pipeline fresh.

What this workflow does

• Schedules or manual run: Runs every Monday at 08:00 (or starts from a manual test run).
• Scrapes Google Maps leads: Uses Apify’s Google Maps Scraper actor with your configured search term, location, maximum places, and campaign key.
• Audits websites for issues and pitch angles: Sends the scraper dataset to Apify’s LatentLark Local Lead Audit actor. For each website, it generates issues and outreach fields (including a pitch angle and email opener) while skipping previously seen businesses.
• Filters out unusable records: Drops results flagged as error, invalid input, or skipped, keeping only valid business records.
• Appends to Google Sheets: Maps the audit output into consistent columns (business details, issues, scores, and outreach fields) and appends each row to your spreadsheet.

Use cases

• Weekly local outreach sourcing for agencies and consultants targeting businesses discovered on Google Maps.
• Lead enrichment pipelines in n8n where you need website audits, issue scoring, and tailored email openers in one place.
• SaaS operators monitoring new opportunities by combining Apify scraping + LatentLark auditing + Google Sheets tracking.

Technical details

• n8n nodes: manual trigger, set, filter, sticky note, Google Sheets, @apify/n8n-nodes-apify
• Apify actors: Google Maps Scraper and LatentLark Local Lead Audit
• Credentials: Apify API token + Google Sheets OAuth2

Works best when your Google Sheet headers match the expected output columns (e.g., businessName, website, city, phone, email, ownerName, problemScore, grade, primaryIssue, issues, pitchAngle, emailOpener, rating, reviewCount, mapsUrl, auditedAt).