Open navigation

Yelp Reviews connection guide

Use this guide to connect Yelp Reviews to Supermetrics, and pull up to 100 of a business' most recent reviews.


If you need to connect this data source to one of our data warehouse or cloud storage destinations, explore our prerequisite and filling guides.


Before you begin

You need a business' Yelp Business ID before you can pull its review data from Yelp Reviews.


You can find any Yelp Business ID by copying the text that comes after /biz in the URL for any business' Yelp page.


For example, if you opened the Yelp page for a business called Article Example Business, its URL would end with /biz/article-example-business. Here, the business's Yelp Business ID is article-example-business.


Instructions

For Excel users

If your team uses Supermetrics for Excel, you'll see different options for managing and sharing data source connections in that destination. Learn more.


Google Sheets Data StudioExcel

Make sure you've installed the Supermetrics add-on before you connect.

  1. Open a new Google Sheets file.
  2. Navigate to ExtensionsSupermetricsLaunch to open the Supermetrics sidebar.
  3. Click Create query.
  4. Under Data source, select Yelp Reviews.
  5. Click Start.
  6. Navigate to Report configuration.
  7. Enter the business' Yelp Business ID.

Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Google Sheets.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.