Extracting Google Reviews for Home Services Businesses with OpenAI

Fatima G. · 2025-11-30T09:22:50.993Z

Hey guys So I have a list of home services businesses exporting using apollo I want to extract the number of reviews each business has on Google. I want to do this using my openAI credits, anyone has done this before, if so , what prompts did yall use

Extracting Google Reviews for Home Services Businesses with OpenAI | Clay

Clay Support
APP
·
·
You have two options for getting Google review counts:
Option 1: Use our Google Business Reviews enrichment - Add the "Find Business Reviews Information with Google" enrichment to your table. It pulls review counts directly from Google's API using company name, website, or address. [1]
Option 2: Use AI with web research - Add a "Use AI" column, select "Web research" use case, choose your OpenAI model, then prompt it to search for and extract Google review counts for each business. [2]
For the AI prompt, try something like: "Search Google for [business name] and extract the total number of Google reviews displayed."
The first option is more reliable since it uses Google's official data, but the AI approach gives you more flexibility with your OpenAI credits.
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with extracting Google review counts or using your OpenAI credits, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any challenges you’re facing?
Fatima G.
·
·
what model do you recommend? i dont want to use more than 1 credits
Clay Support
APP
·
·
For staying under 1 credit, GPT-3.5 Turbo or Claude Haiku are your most cost-effective options. [1] These models are specifically mentioned as the most cost effective choices.
Clay's proprietary models (Neon, Helium, Argon) cost 2-3 credits each, so they'd exceed your budget.
You can also connect your own OpenAI API key to use GPT models without any Clay credits - this cuts costs by up to 90%. [2]
Clay Support
APP
·
·
Was this helpful?
Fatima G.
·
·
whats the best option for this specific prompt
Clay Support
APP
·
·
For extracting Google review counts specifically, GPT-3.5 Turbo or Claude Haiku are your best options under 1 credit. [1]
However, since this is a simple web research task (finding a specific data point), you could also try Claygent Helium which costs around 1 credit and is described as "the best Claygent model at its price-performance." [2]
For this straightforward extraction task, the cheaper models should work fine - you don't need the advanced reasoning of more expensive models. [3]
Clay Support
APP
·
·
Did that answer your question?
Fatima G.
·
·
i dont see gpt 3.5 turbo in my options
Clay Support
APP
·
·
GPT-3.5 Turbo might not be available in your current model dropdown. The available models include GPT-4o, Claude Opus, Claude Sonnet, Claude Haiku, and our proprietary models like Claygent Neon. [1]
For your budget of under 1 credit, Claude Haiku is your best option - it's specifically mentioned as one of the most cost effective choices.
You can also connect your own OpenAI API key to access GPT models without using any Clay credits, which could save you up to 90% on costs. [2]
Clay Support
APP
·
·
Does this clarify your options?
Fatima G.
·
·
okay give me the best prompt again
Clay Support
APP
·
·
For extracting Google review counts with web research, use this prompt structure:
"Search Google for [business name] and extract the total number of Google reviews displayed. Return only the numerical count."
Make it specific - include the business name column reference and specify you want just the number. [1]
You can also use our AI help tool by clicking "Help me" in the Use AI configuration to generate a tailored prompt automatically. [2]
Clay Support
APP
·
·
Is that what you were looking for?

28 comments