Generate and qualify local business leads using Google Sheets, RapidAPI and OpenAI

How it works This workflow automatically discovers and qualifies local business leads using structured inputs. It runs on a schedule, reads search queries from Google Sheets, and fetches business data via an API. The data is cleaned and enriched before being analyzed by AI for lead scoring and categorization. Finally, all enriched leads are stored back in Google Sheets for outreach and tracking.

Step-by-step

- Trigger workflow automatically - Schedule Trigger – Runs the workflow at defined time intervals.

- Fetch lead search inputs - Read Search Requests – Retrieves keywords and locations from Google Sheets.

- Collect business data from API - Search Businesses API – Queries RapidAPI to find local businesses with contact details.

- Clean and structure results - Format Business Results – Extracts and formats business name, email, phone, website, and address.

- Analyze and score leads with AI - Message a model – Uses OpenAI to classify businesses, assign lead scores, and generate outreach lines.

- Store enriched leads - Write to Business Results – Saves all processed and scored leads into Google Sheets.