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.
You can do a lot more and get much more with Amigo which lets you scrape Yelp business data and reviews using Yelp reviews API. And not just that, you can automatically retrieve data from Yelp and pull them to Google Sheets.
So let’s learn how to import Yelp reviews to Google Sheets. But first the steps:
How to import Yelp reviews to Google Sheets
Here’s a step-by-step guide on how to import Yelp Reviews to Google Sheets using Yelp Reviews API.
Install the Amigo Data extension in Google Sheets
Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace to scrape Yelp reviews and business data. Follow the link below to install it.
Alternatively, you can get it from Google Sheets.
- Open Google Sheets
- Go to Extensions→Add-ons→Get add-ons
- Search for Amigo Data and install it.
Get the Yelp Reviews API endpoint
We’ll use a Yelp Reviews API on RapidAPI, an API marketplace, to scrape and import Yelp reviews to Google Sheets.
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 use the Yelp API and import Yelp reviews to Google Sheets.
Click Endpoints to go back to the Yelp Reviews API documentation. On the left are the available endpoints that we can use to scrape Yelp data. Click on any one of these, say Business Reviews.
In the middle are the headers and parameters which we can fill with values of our choice to scrape the Yelp reviews for a particular business.
The only required parameter is the business_id which we need to fill with the business ID of interest.
The business ID can be found in the URL of the Yelp page for the business. For example, in the URL https://www.yelp.com/biz/liebert-and-associates-cpa-new-york, liebert-and-associates-cpa-new-york is the business ID for Liebert & Associates CPA.
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.
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 Yelp reviews API URL along with the parameters and the headers. Change the language from 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 to scrape Yelp reviews and import the Yelp reviews to Google Sheets.
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.
You’ll be presented with a list of sources to connect to. Choose Custom API.
Paste the endpoint URL in the API URL field. Do not include the apostrophes. (Likewise for the headers.)
Then expand the Details tab and enter the header given in the Code Snippets. The headers are:
Header 1 Name: X-RapidAPI-Key Value: YOUR_API_KEY (replace this with your key) Header 2 Name: X-RapidAPI-Host Value: yelp-reviews.p.rapidapi.com
Click the PREVIEW button to retrieve the Yelp reviews to import to Google Sheets.
Flatten and expand the nested datasets and delete the columns that you don’t need. Then click IMPORT.
The Yelp business reviews will be imported into Google Sheets in a moment. Below is a snippet of the imported data.
Automatically retrieve Yelp reviews
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 this link to learn how to set a refresh schedule and set up alerts in Amigo Data.
Visit our blog 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