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: no card needed.
- 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 the Maps rate for each business a call returns. A =CRUSTMAPS call that fills 20 business rows costs $0.0392 at standard prices. Empty searches are free. Here is the deposit pricing:
| Deposit | Google Search / 1,000 requests | Maps / 1,000 businesses | LinkedIn Profiles / 1,000 | LinkedIn Companies / 1,000 | LinkedIn Posts / 1,000 requests | People, Jobs, Refresh / 1,000 units |
|---|---|---|---|---|---|---|
| $10+ | $1.00 | $1.96 | $4.00 | $3.00 | $6.00 | $1.96 |
| $149+ | $0.76 | $1.49 | $3.00 | $2.50 | $4.50 | $1.49 |
| $549+ | $0.56 | $1.10 | $2.50 | $2.00 | $3.30 | $1.10 |
| $1,999+ | $0.41 | $0.80 | $2.00 | $1.75 | $2.45 | $0.80 |
| $6,500+ | $0.33 | $0.65 | $1.75 | $1.60 | $1.95 | $0.65 |
| $27,500+ | $0.28 | $0.55 | $1.60 | $1.50 | $1.65 | $0.55 |
| $50,000+ | $0.26 | $0.50 | $1.50 | $1.50 | $1.50 | $0.50 |
| $100,000+ | $0.20 | $0.40 | $1.50 | $1.50 | $1.50 | $0.40 |
Every eligible account gets $6 of free usage monthly. Each deposit keeps its prices until spent; paid funds never expire. People and Jobs bill per successful search, Refresh per accessible profile. Full profiles in People use the read rate per full profile. See all billing details.
Larger deposits unlock lower endpoint prices. Each deposit keeps its prices until spent. See the full deposit table on the pricing page. Prices in USD, ex-tax.
Funds 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 costs $1.96 per 1,000 businesses at standard prices, down to $0.40 for the largest deposit. Empty and failed searches are free. Every eligible account gets $6 of free usage monthly. Paid funds never expire.
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 free, no card needed. Paste the script once, type a search, and watch names, addresses, phones, ratings, and review counts fill your sheet.
Try for free