AI Analysis & Classificationfree

AI-Powered Local Business Lead Scraping, Qualification and Outreach System

by Chris ZhangUpdated Aug 2026

Requires

Google SheetsOpenAI

1/5

STEPS · 16

Run manually by an operator

Scrapes local business leads with Apify, enriches emails via Hunter and Tavily, qualifies them with OpenAI, and logs to Google Sheets.

SEO key word analysis and filter

On manual run, extracts keywords from Google Drive files, classifies and filters them with OpenAI, and writes results to Google Sheets.

On a schedule, reads campaign rows from Google Sheets, fetches ad metrics via HTTP, and analyzes them into structured insights with Gemini.

On a schedule, pulls Google Analytics and web data, runs OpenAI SEO specialists, and writes the audit to Google Sheets.