Google Maps has no button that sends listings to Sheets
Google Maps and Google Sheets are both Google products, but there's no button to send listings from one to the other, and the old IMPORTXML and Apps Script tricks break often because Maps loads its results dynamically. The reliable path is a tool built for the job that gives you a CSV Sheets imports directly.
Maps Harvest runs in your browser, with no add-on to install and no script to maintain, and your account never gets the same business twice, so the sheet doesn't fill up with repeats.
How to get Google Maps into Sheets in 4 steps
Scrape your list in Maps Harvest
Sign up free, pick a business category and locations, and run the search. You get the matching Google Maps listings, with no business twice.
Download as CSV
From the download menu, pick CSV. The file is UTF-8 with a byte-order mark, so accented characters and special symbols stay intact in Sheets. Or skip the import: the same menu can create a new Google Sheet in your own Drive (up to 50,000 rows).
Import into Google Sheets
In Google Sheets: File → Import → Upload → select your CSV → 'Insert new sheet' or 'Replace current sheet'. Every column maps cleanly, one business per row.
Filter, sort, and share
Use Sheets filters to sort by rating or review count, split by city, or share the live sheet with your team and dialer.
A webhook can fill the sheet for you
Don't want to import a CSV every time? On every plan, Maps Harvest can send results to a webhook automatically when a search finishes. Point that webhook at Zapier or Make with a “Create Spreadsheet Row” action, and every search lands in your Google Sheet with no manual step. There are also ready-made n8n and Make templates for Google Sheets at mapsharvest.com/integrations. They use the API, so they work on the Free plan's 50 credits.
Four habits for a clean sheet
Set filters before you run the search+
Filters on rating, review count, website and phone run during the search, so only matching leads reach your sheet and you're only charged for those.
Pick only the columns you need+
The Data Fields picker controls which columns export, so your sheet stays short and ready for a dialer.
Import as UTF-8+
Maps Harvest CSVs are UTF-8 with a byte-order mark, so names with accents import correctly. Use File → Import → Upload rather than copy-paste to keep every column.
Use a fresh tab per scrape+
Import each scrape into its own sheet tab so you can keep niches or cities separated and merge later with QUERY or filters.
Get Google Maps data into Sheets now
50 free leads on the Free plan. No card needed.