Type what you are looking for and where (e.g. "growth agency in London") and import up to 200 businesses into Google Sheets: name, phone, website, rating, address and attributes.
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.
All the data you can extract
Enrich companies and leads with 12+ data points each.
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
When to reach for it
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.
1Local lead generation: list every dentist, gym or agency in a city for cold outreach in one search.
2Market mapping: count and profile every competitor in an area before you expand.
3Franchise & retail scouting: pull all businesses of a type around candidate locations.
4Review benchmarking: compare ratings and review counts across a category and region.
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 Standard plan up.
"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
"Super easy to enrich linkedin urls using this tool. Both personal and company url data can be easily enriched with a click of a button."
Zaid Bilal
RevOps Professional
"Amazing Tool, I would like to advocate this to my colleagues. So that you can get more users. Keep it Up. 5 Stars!"
Asif Hanzala
Lead Generation Specialist at IdeaPeel
"This app is fantastic. Brilliantly created to help small and mid sized businesses."
Dan Hughes
Founder/CEO, AlmanacIO
"I have been using other expensive apps or freemium like phantombuster, but Derrick has replaced them all. I love the simplicity of the Google sheet add-in, but what is best is the efficiency it delivers."
Julien Walon Cohen
CEO & Co-founder @ Diffly | B2B Sales Advisor
"The LinkedIn scraping and email finder combo is incredibly powerful. I can build a complete prospect list with contact info in under an hour. Absolute must-have for outbound."
Michael Kim
SDR Team Lead at CloudScale
"Have tested over 10+ LI scraper apps, Derrick beats them all. Simple to use, accurate data, and affordable price."
AJ Alexander
Opportunity Prospector
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.
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.
Turn Google Maps into a lead list
Import up to 200 businesses per search, straight into Google Sheets, fully enriched. Available on paid plans.
