Google Maps data into Google Sheets
Paste one script, type a search in a cell, data fills the sheet.
What data do you get?
One custom function turns a plain search into a grid of Google Maps data, right inside Google Sheets. Nothing to install from a marketplace, and it runs on any normal Google account.
A real result, not a mockup
This is the actual data a call for coffee shops in Austin returned, in under a second. The script drops these straight into your sheet, one business per row.
| Name | Address | Category | Rating | Reviews |
|---|---|---|---|---|
| Epoch Coffee | 221 W N Loop Blvd, Austin, TX 78751 | Coffee shop | 4.5 | 2506 |
| Terrible Love | 3908 Avenue B, Austin, TX 78751 | Coffee shop | 4.9 | 418 |
| Hometown Coffee - East Austin | 1101 Springdale Rd, Austin, TX 78721 | Coffee shop | 4.9 | 78 |
| Mozart's Coffee Roasters | 3825 Lake Austin Blvd, Austin, TX 78703 | Coffee shop | 4.5 | 10823 |
| Klerje Coffee | 1614 E 6th St Apt 112, Austin, TX 78702 | Coffee shop | 4.8 | 180 |
Here is the raw JSON for the first row, so you can see the exact field names the script reads:
How do you set it up?
This is an Apps Script you paste into your own sheet once, not a native add-on. About two minutes, and there is nothing to install. No key yet? Create a free account first: 3,000 credits a month, no card.
- Open Apps Script In your sheet, click Extensions, then Apps Script. A code editor opens in a new tab.
- Paste the function Delete the sample code, paste the CRUSTMAPS function below, and drop your key into CRUSTAPI_KEY. Click Save.
- Call it in a cell Back in the sheet, type =CRUSTMAPS("dentists in Miami") in a cell. The name, address, phone, category, rating, and review columns fill down and across on their own.
- Change the search Edit the text in the quotes for any city or business type. Add a number for how many results, like =CRUSTMAPS("plumbers in Denver", 30).
Then type the search into any empty cell:
How do columns map to fields?
The real field names from the response above. The script reads the path on the right and writes the column on the left.
| Sheet column | Response field | Value in the sample |
|---|---|---|
| Name | title | Epoch Coffee |
| Address | address | 221 W N Loop Blvd, Austin, TX 78751 |
| Phone | phone | (512) 454-3762 |
| Website | website | http://www.epochcoffee.com/ |
| Category | categoryName | Coffee shop |
| Rating | totalScore | 4.5 |
| Reviews | reviewsCount | 2506 |
The star rating is totalScore, not rating (the highlighted rows). The response also carries city, state, postalCode, location with lat and lng, and openingHours, so you can add more columns by pushing those fields in the same loop.
How much does Maps data cost?
Maps bills 1 credit for each business a call returns. A =CRUSTMAPS call that fills 20 rows costs 20 credits, and an empty search costs nothing. Here is what real sheets cost:
| What you pull | Credits | You pay |
|---|---|---|
| One =CRUSTMAPS call, 20 businesses | 20 | $0, inside the free 3,000 a month |
| A 50-search sheet, ~1,000 businesses | 1,000 | $0, inside the free 3,000 a month |
| 25,000 businesses | 25,000 | $49 ($1.96 per 1,000) |
| 100,000 businesses | 100,000 | $149 ($1.49 per 1,000) |
| 500,000 businesses | 500,000 | $549 ($1.10 per 1,000) |
| 2.5 million businesses | 2,500,000 | $1,999 ($0.80 per 1,000) |
Packs continue up to 250 million credits for $100,000, which is $0.40 per 1,000. Prices ex-tax.
Credits are prepaid and never expire, so an unused pack is still yours next year.
Related: Google Maps API pricing · Docs
Who uses this?
- Lead gen freelancers. Build a client call list in one sheet: names, phones, and websites, ready to work.
- Local SEO agencies. Track every competitor around a client: category, rating, and review count per city.
- Sales ops teams. Fill territory sheets with fresh business lists, no engineer and no CSV imports.
- Founders sizing a market. Count the players in a niche from the tool you already use, one formula per city.
Common questions
Open your sheet, click Extensions then Apps Script, and paste the CRUSTMAPS function from this page. Drop your key into CRUSTAPI_KEY and click Save. Back in the sheet, type =CRUSTMAPS("dentists in Miami") in a cell and the name, address, phone, category, rating, and review columns fill in on their own.
It is a script you paste in yourself, and we say so plainly. You add a small Apps Script to your own sheet once, so there is nothing to install from a marketplace and no extra permissions to manage across your team. Any Google account that can open Extensions and Apps Script can run it.
The sample script returns title, address, phone, website, categoryName, totalScore, and reviewsCount. The response also carries city, state, postalCode, location with lat and lng, and openingHours, so you can add more columns by pushing those fields in the same loop. Note the star rating is totalScore, not rating.
Maps bills one credit per business you get back, so a call that returns 20 places costs 20 credits. Credits are prepaid and never expire, and the free tier is 3,000 a month with no card. Paid packs start at 25,000 for $49.
We read only public Google Maps listings, the same results anyone sees without signing in. There are no fake accounts and no logins involved on our side. What comes back is data that is public to any visitor, delivered as clean JSON.
Pull your first list today
Start on the free 3,000 credits a month, no card needed. Paste the script once, type a search, and watch names, addresses, phones, ratings, and review counts fill your sheet.
Get 3,000 free credits