Print

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

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)
    outscraper-billing
  4. Now navigate to your Profile Settings page and click the Generate API token button
    outscraper-token
  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.

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:
    • ApplicationCustom
    • MethodGET
    • Request URLhttps://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-KEYyour_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.
    outscraper-response

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:
    • ApplicationCustom
    • MethodGET
    • Request URLhttps://api.app.outscraper.com/maps/reviews-v3?query=The Diner, Taipei, Taiwan&reviewsLimit=3&async=false
    • Headers:
      • X-API-KEYyour_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.
    outscraper-response2

Part 4: API Documentation

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

5 thoughts on “Scrape Google Maps Places into Google Sheets (Outscraper)”

    • Did you get an error message or just didn't see the review fields in your sheet? Can you please share your request URL so I can test it on this side?

      Reply
  1. The search results came back with three listings but they were all listed in the same row.

    Also I changed the limit to 10 in the request URL but it only gave me three? I know there are certainly more than three in Atlanta, GA

    Reply

Leave a Comment

Jump To