Updated August 2026

Paid plans

Google Maps Scraper Local business scraper

Type what you are looking for and where, then import up to 200 businesses: name, phone, website, rating, address and attributes.

Try it for free →

or use it directly in

Claude

or via API

You give

Your list

You get back

name El Bolillo Bakery
type Bakery
rating 4.7

+9 review_count, phone_numbers, website, domain, full_address, opening hours…

Try it01 / 05

Google SheetsClaudeAPI

The output02 / 05

What lands in your columns

12 fields, with a real example of each. You pay when the answer comes back, and never when it does not.

Field Name	Description	Example
name	Business name as shown on Google Maps	`El Bolillo Bakery`
type	Primary business category (plus all sub-categories in a separate column)	`Bakery`
rating	Average star rating	`4.7`
review_count	Number of Google reviews	`3690`
phone_numbers	Phone number(s), written as text so Sheets keeps the leading +	`+1 713-226-8889`
website	Business website URL	`https://www.elbolillobakery.com`
domain	Bare domain, ready for email or tech enrichment	`elbolillobakery.com`
full_address	Full postal address	`2421 Canal St, Houston, TX 77003`
opening hours	Opening hours split into one column per day (Monday to Sunday)	`6:00 AM–8:00 PM`
attributes	Attribute flags grouped per category (payments, accessibility, service options, offerings...)	`Credit cards, Debit cards, NFC mobile payments`
place_id	Google place ID, the canonical identifier for the place	`ChIJo5WzdY-4QIYRSL3AEsOhcYc`
country_code	ISO country code	`US`

Step by step03 / 05

How to use this feature

Get started in 3 simple steps.

Type your search

Write what you are looking for and where, e.g. "agence seo marseille" or "growth agency in London". No need to open Google Maps or copy a URL.

Select Google Maps by prompt

Open the Derrick add-on, choose Google Maps by prompt, and type your search.

Get the full business list instantly

A new sheet fills with up to 200 businesses: contact, rating, address, opening hours and attributes, ready to use.

When to reach for it04 / 05

Google Maps Scraper use cases

Type a search like "growth agency in London" and Derrick imports up to 200 businesses into Google Sheets - name, category, phone, website, rating, address, opening hours and attributes. No URL to copy, no scraping tool to maintain.

Local lead generation

list every dentist, gym or agency in a city for cold outreach in one search.
Market mapping

count and profile every competitor in an area before you expand.
Franchise & retail scouting

pull all businesses of a type around candidate locations.
Review benchmarking

compare ratings and review counts across a category and region.

Used by Local SEO agencies Field sales teams Market researchers

For your stack05 / 05

Use Google Maps Scraper via the API and the MCP

Google Maps Scraper isn't tied to the Google Sheets sidebar. Every Derrick enrichment - this one included - is also exposed through the REST API and the MCP server, so you can run it from your CRM, your data pipeline, an AI assistant, or any no-code tool (Zapier, Make, n8n). Same credit cost as the add-on, same data. API access is included from the PLUS plan up.

Read the API docs → Set up the MCP server →

Customer stories

Loved by sales teams worldwide

See what our customers say about Derrick.

323 reviews

"This app saved me so much time and effort. Great for anyone looking to build a contact list or network at scale quickly. As a start-up it's been invaluable."

Alex Clark

Director | SaaS GTM Leader

"Working pretty nifty compared to Snov.Io. Price wise it does give a fair shake, and IMO better interface since it's google sheets."

David Sire

Mortgage Broker at Zero Point Mortgage

"Derrick is a very simple and user-friendly app to enrich your contacts database. Best thing: you can test it for free. And then the price is so low, it's a no brainer."

Etienne Grange

CEO Form'actions

Turning a Google Maps search into a usable prospect list is a chore most teams still do by hand: scroll the map, copy each business, paste name, phone and website one row at a time. Derrick does it from a plain text search you type in a Google Sheet - "growth agency in London", "agence seo marseille" - and writes back every business it returns, up to 200 in one call, each on its own row: name, category, rating and review count, phone, website and domain, full address, opening hours split per day, and Google attributes grouped per category (payments, accessibility, service options and more). No URL to copy, no scraping tool to maintain.

From there it is one step to a pipeline: enrich the domains with verified emails and mobiles, or crawl each website for contacts. Available on paid plans, 1 credit per place returned (up to 200 per search). See the Derrick pricing page.

Turn Google Maps into a lead list

Import up to 200 businesses per search, straight into Google Sheets, fully enriched. Available on paid plans.

Add to Google Sheets Connect to Claude Use the API

1 credit per place

Up to 200 places returned per search

No code just type what & where

Do I need to install anything to use Google Maps Scraper?

Just the Derrick Google Sheets add-on (one click, no API keys, no developer setup). Once installed, Google Maps Scraper is one of the workflows available from the Derrick sidebar inside any Sheet. The same feature is also available via REST API and via the Derrick MCP server for Claude / ChatGPT.

Can I use Google Maps Scraper on a list of 1,000+ rows?

Yes - Google Maps Scraper runs as a batch job inside Google Sheets, with progress tracking and per-row credit accounting. The workflow scales linearly: 10 rows or 10,000 rows, the steps are identical and you can step away while it runs.

Where does the data behind Google Maps Scraper come from?

Derrick aggregates 10+ public-data sources (LinkedIn graph, company websites, registry data, web crawl, third-party providers) and runs a multi-source lookup for Google Maps Scraper. The first source that returns a confident match wins; if no source is confident enough, the cell is left blank rather than guessed.

Is Google Maps Scraper GDPR-compliant?

Yes. Derrick only enriches public data, doesn't store personal records beyond the duration of the lookup, and supports full deletion on request. The Sheets add-on runs inside Google's OAuth-protected environment so your data stays private to your account.

Can I trigger Google Maps Scraper automatically when I add a row?

Yes - set up a Google Sheets onEdit trigger (Apps Script, takes 2 minutes) so a new row in column A automatically runs Google Maps Scraper into column B. Pair with Zapier / Make / n8n to push CRM contacts directly into the sheet for hands-free enrichment.