Audit Google Maps local leads with Apify Local Lead Audit and Google Sheets

Quick overview

This workflow runs weekly (or manually) to scrape Google Maps leads via Apify, audits each business website with LatentLark Local Lead Audit to generate issues and outreach angles, and appends the enriched lead data to a Google Sheets spreadsheet.

How it works

1. Runs every Monday at 08:00 (or starts from a manual test run) and loads the search term, location, maximum places, and campaign key.
2. Uses Apify’s Google Maps Scraper actor to collect matching businesses from Google Maps based on the configured search and location.
3. Sends the scraper run’s dataset to Apify’s LatentLark Local Lead Audit actor to audit each website, attempt to find owner/contact details, and generate a pitch angle and email opener while skipping previously seen businesses.
4. Drops results flagged as error, invalid input, or skipped, and keeps only valid business records.
5. Maps the audit output into a consistent set of columns (business details, issues, scores, and outreach fields) and appends each row to Google Sheets.

Setup

1. Install the Apify community node (@apify/n8n-nodes-apify) if needed and add an Apify API token credential.
2. Create a Google Sheet with header columns that match the workflow’s output (for example: businessName, website, city, phone, email, ownerName, problemScore, grade, primaryIssue, issues, pitchAngle, emailOpener, rating, reviewCount, mapsUrl, auditedAt).
3. Add Google Sheets OAuth2 credentials and select the target spreadsheet and sheet/tab in the Google Sheets append step.
4. Update the Settings values (searchTerm, location, maxPlaces, and a unique campaignKey used to deduplicate with onlyNew), then run once manually before enabling the weekly schedule.