Google Maps Business Data to Notion
Search any location on Google Maps and save business data — ratings, reviews, hours, contact info, and more — directly to your Notion database. No coding required.
How It Works
Connect your Notion workspace to Harvist. We'll create a places database with 32 columns for all Google Maps data.
Type the business type (e.g. 'coffee shops') and the location (e.g. 'San Francisco, USA'). Choose how many results to extract.
Click 'Run' and Harvist will search Google Maps, extract detailed data for each place, and save structured entries to your Notion database.
Your Notion database now has a row for each place with ratings, reviews, contact info, hours, and a rich page with up to 12 sections. Re-running updates existing places by Place ID.
What Makes This Template Special
Extract comprehensive Google Maps business data into a structured Notion database — no code, no API keys needed.
32 Data Fields
Rating, reviews, phone, hours, coordinates, images, and more — all saved to Notion columns.
Batch Extraction
Up to 50 places per search in one run. Enter a keyword and location, get a full database.
Smart Upsert
Re-run the same search to update existing places. No duplicates — matched by Place ID.
Location Targeting
Search any city, region, or street address. Target exactly the area you need.
Reviews & Ratings
Star distribution, recent reviews with owner responses. Optional — toggle off for faster results.
Contact Data
Phone, website, email, booking links, menu URLs — everything needed for outreach.
What You Get in Notion
Harvist creates a Notion database with these columns, automatically populated with business data from Google Maps:
| Property | Type | Description |
|---|---|---|
| Name | title | Business/place name |
| Category | select | Primary Google category |
| Rating | number | Average rating (0-5 scale) |
| Reviews Count | number | Total number of reviews |
| Price Level | select | Price level indicator ($-$$$$) |
| Status | select | Open / Temporarily Closed / Permanently Closed |
| Phone | phone_number | Formatted phone number |
| Website | url | Business website URL |
| Full Address | text | Complete formatted address |
| City | select | City name |
| State | select | State or province |
| Country | select | ISO country code |
| Google Maps URL | url | Direct Google Maps link |
| Search Term | text | The query that found this place |
| Search Rank | number | Position in search results |
| Updated At | date | When the data was last collected |
| Place ID | text | Google unique place identifier |
Upsert key: Place ID — if an entry with the same place id exists, it will be updated instead of duplicated.
Who Uses This
Marketers building local business databases for outreach
Researchers analyzing location-based business data
Sales teams generating leads from Google Maps
SEO agencies tracking local business listings
Pricing
Each run costs 1 credit per result. The free plan includes monthly credits — no credit card required. Upgrade anytime for more credits.
Frequently Asked Questions
Related Templates
Extract & Summarize Web Articles to Notion
Extract and summarize any web article or blog post. AI processes the content, pulls key points, and writes structured data to your Notion database.
Local Business Lead Generator to Notion
Generate enriched local business leads from Google Maps with auto-priority scoring, email & social media enrichment, and CRM-ready Notion pages. No coding required.
Have a suggestion?
Need more fields, a different output format, or additional data? Let us know how to improve this template.
How It Works
- 1
Connect Notion
Connect your Notion workspace to Harvist. We'll create a places database with 32 columns for all Google Maps data.
- 2
Enter search keywords and location
Type the business type (e.g. 'coffee shops') and the location (e.g. 'San Francisco, USA'). Choose how many results to extract.
- 3
Run the template
Click 'Run' and Harvist will search Google Maps, extract detailed data for each place, and save structured entries to your Notion database.
- 4
Check Notion
Your Notion database now has a row for each place with ratings, reviews, contact info, hours, and a rich page with up to 12 sections. Re-running updates existing places by Place ID.
Who Uses This
Marketers building local business databases for outreach
Researchers analyzing location-based business data
Sales teams generating leads from Google Maps
SEO agencies tracking local business listings
Frequently Asked Questions
- What is the best free Google Maps scraper for Notion?
- Harvist.ai is the best free Google Maps scraper that saves business data directly to Notion. Search any location and keyword, and Harvist extracts ratings, reviews, phone numbers, hours, and 30+ data fields per place into a structured Notion database.
- How does Harvist compare to the Google Places API?
- The Google Places API requires developer setup, API keys, billing configuration, and code to parse JSON responses. Harvist provides the same data (and more, like reviews and popular times) with zero coding — just enter a search query and location, and structured data flows into your Notion database.
- What data does Harvist extract from Google Maps?
- Harvist extracts 32 data fields per place including business name, category, rating, review count, phone number, email, website, full address, GPS coordinates, opening hours, popular times, reviews, images, and more. Each place also gets a rich Notion page with up to 12 content sections.
- How many Google Maps results can I scrape per run?
- Free plan users can scrape up to 10 places per run. Starter and Pro plan users can scrape up to 50 places per run. Each run costs 3 credits regardless of the number of results.
- Can I use this for lead generation?
- Yes. Harvist is ideal for local business lead generation. Search for any business type in any location to build a Notion database of leads with phone numbers, websites, emails, and addresses. Re-running the same search updates existing entries and adds new ones.
- Does it scrape Google Maps reviews?
- Yes. Harvist extracts up to 5 recent reviews per place, including the reviewer name, star rating, review text, date, and any owner response. Review distribution (1-5 stars) and review tags are also captured.