Scrape Google Maps Places into Google Sheets (Outscraper)

In this guide, we’ll walk through how to scrape Google Maps place information and Google Maps reviews directly into Google Sheets, using the API Connector add-on for Sheets and the scraping service Outscraper.

Outscraper is a service that scrapes public data out of Google Maps and packages it into an API. Fetching data from Outscraper is quite a bit easier than fetching it from the official Google Maps API.

Contents

• Before You Begin
• Part 1: Get Outscraper API Key
• Part 2: Scrape Google Maps Search Results into Sheets
• Part 3: Scrape Google Maps Reviews into Sheets
• Part 4: API Documentation

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your Outscraper API Key

1. Navigate to https://outscraper.com/ and click Join Free Tier
2. Fill out the form to create an account, and click the account verication email to confirm it.
3. You should now be logged in to Outscraper. Navigate to the Billing Information page and add a payment method (you can use this service to fetch up to 500 places for free but still need to add a card)
   
4. Now navigate to your Profile Settings page and click the Generate API token button
   
5. You should now see your token! Congrats, you can now fetch data from Google Maps (and the other services provided by Outscraper). Copy and keep it safe as we'll need it shortly.
   

Part 2: Scrape Google Maps Search Results into Sheets

For this example, we'll get a list of restaurants in Manhattan. Substitute in your own API token and location of interest.

1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
2. In the request form enter the following:
   • Application: Custom
   • Method: GET
   • Request URL: https://api.app.outscraper.com/maps/search-v2?query=restaurants, Manhattan, NY, USA&limit=3&async=false&fields=query,name,full_address,site,type,logo,description,category,rating,reviews,photo_count,working_hours,business_status,range
   • Headers:
     • X-API-KEY: your_api_token
   • Report style: Compact (under Output options)
3. Create a new tab and click Set current to use that tab as your data destination.
4. Name your request and click Run. A moment later you’ll see a list of three Google Maps search results populate your sheet.
   
   

Part 3: Scrape Google Maps Reviews into Sheets

We'll now get reviews for a restaurant of interest. As above, substitute in your own restaurant and API token.

1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
2. In the request form enter the following:
   • Application: Custom
   • Method: GET
   • Request URL: https://api.app.outscraper.com/maps/reviews-v3?query=The Diner, Taipei, Taiwan&reviewsLimit=3&async=false
   • Headers:
     • X-API-KEY: your_api_token
   • Report style: Compact (under Output options)
3. Create a new tab and click Set current to use that tab as your data destination.
4. Name your request and click Run. A moment later you’ll see a list of three reviews populate your sheet.
   

Part 4: API Documentation

Official API documentation: https://app.outscraper.com/api-docs#tag/Google-Maps