Qualify Google Maps leads with ScrapeHero, OpenAI, and Google Sheets

Quick overview

This workflow manually scrapes Google Maps business listings via ScrapeHero, paginates through results, deduplicates and normalizes each listing, enriches each business with an OpenAI lead-qualification score, and appends the structured results to Google Sheets.

How it works

1. Starts when you run the workflow manually.
2. Sends the configured Google Maps search query to ScrapeHero and repeatedly follows the returned next-page URL until pagination ends or the max page limit is reached.
3. Combines results from all pages, splits them into individual businesses, normalizes key Google Maps fields, and removes duplicates.
4. Sends each unique listing and your target service description to OpenAI to produce a structured lead qualification (score, quality, fit, and recommended action).
5. Merges the original Google Maps listing data with the structured AI output and parses it into a single flattened record.
6. Appends one enriched business lead per row to a Google Sheets worksheet.

Setup

1. Add a ScrapeHero credential with API access and ensure the ScrapeHero Google Maps Search API is enabled for your account.
2. Add an OpenAI credential for the Chat Model used in the workflow (gpt4o-mini) or change the model to one available in your account.
3. Add a Google Sheets credential, then set the target spreadsheet document URL/ID and sheet tab for the append operation.
4. Update the Google Maps search text, targetService, and maxPages values in the search-configuration step before running the workflow.