Import Yelp Reviews To Google Sheets

Import Yelp reviews to Google Sheets
Reading Time: 4 minutes

Whether you’re looking for customers’ sentiments about your company and how they perceive your brand and business, or looking for competitors’ offerings and how they are received by customers, or looking for a particular offering of a business, Yelp is the one place to go to.

You can do a lot more and get much more with a Google Sheets extension with which you import all the reviews for a particular business, sort them by popularity, age, by a particular keyword, etc. And not just that, you can automatically retrieve the information once you’ve set it up. You can find the installation link below.

So let’s learn how to import Yelp reviews to Google Sheets. But first the steps:

  1. Install Amigo Data Google Sheets extension
  2. Get the endpoint URL
  3. Import the data to Google Sheets

How to import Yelp reviews to Google Sheets

Install the Amigo Data extension in Google Sheets

Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace.

Amigo Data in Google Workspace Marketplace

Click here to install.

Alternatively, you can get it from Google Sheets.

  • Open a new sheet
  • Go to Extensions→Add-ons→Get add-ons
  • Search for Amigo Data and install

Get the endpoint URL

Sign up or log in to RapidAPI.

Once you’re logged in, go to the Yelp Reviews API Documentation page in RapidAPI.

Click on the Subscribe to Test button and subscribe to a plan of your choice, post which you’ll be able to test and import Yelp reviews to Google Sheets.

Subscribing to tet button

Click Endpoints to go back to the API Playground. On the left of the page is the available endpoint–which there’s only one.

In the middle are the headers and parameters which we can fill with values of our choice.

Parameters
The business ID parameter

We can leave the optional parameters blank or use them to filter the results. For this example, we’ll change the sort parameters to HIGHEST_RATED, remove the query parameter to remove filtration by words and leave the rest as they are.

The optional parameters

We can leave the optional parameters blank or use them to filter the results. For this example, we’ll change the sort parameters to HIGHEST_RATED, remove the query parameter to remove filtration by words and leave the rest as they are.

Then we can go ahead and begin pulling the data to Google Sheets. Or click the Test Endpoint button to see the results.

On the right of the screen under Code Snippets, we’ll find the URL along with the parameters and the headers. Change the language to Shell→cURL.

The query parameters are appended in the cURL so that we do not have to enter the parameters manually. Copy the URL and also note the headers. These will be used in the next step.

Import the data to Google Sheets

Open Google Sheets and launch Amigo Data from the sheet into which you want to fill the data. To connect to Amigo Data, click Extensions→Amigo Data→Connect.

Launch Amigo Data

You’ll be presented with a list of sources to connect to. Choose Custom API.

Select Custom API as the source to connect

Paste the endpoint URL in the API URL field. Do not include the apostrophes. (Likewise for the headers.)

Enter the endpoint URL

Then expand the Details tab and enter the header. For the endpoint we’ve selected, the headers are:

Name: X-RapidAPI-Key, Value: YOUR_API_KEY

Name: X-RapidAPI-Host, Value: yelp-reviews.p.rapidapi.com

The data will be imported into Google Sheets in a moment. Below is a snippet of the imported data.

Once the data have been imported into Google Sheets, they can be updated automatically at regular intervals–hourly, daily, weekly or on custom days–should you so wish, and get these data sent to your inbox. Click here to learn how set a refresh schedule and set up alerts in Amigo Data.

Visit our blog for to find out about the kinds of data that you can import to Google Sheets and how you can track stock, find trending hashtags on Instagram, fetch Twitter, Reddit and many more.

Some recommended articles:

Import Zillow Data to Google Sheets

Import Mailchimp Data To Google Sheets

Import Eventbrite Data to Google Sheets