Yelp Business Review Scraper

🌟 Yelp Business Review Scraper

Yelp Business Review Scraper is an easy-to-use tool that allows fetching ratings and reviews for any business listed on Yelp - simply provide one or more Yelp business URLs, business IDs, or aliases. Reviews are stored as both CSV and JSON.

For each review, the scraper extracts:

• Star rating (1-5)
• Full review text
• Review date and language
• Images attached to the review
• Feedback counts (useful, funny, cool)
• Business owner reply (if any)
• Reviewer information (name, location, profile URL, review count, etc.) when sensitive data is enabled

Additional features:

• Filter by language - retrieve reviews in a specific language (24 languages supported)
• Sort reviews - by newest, oldest, highest rated, lowest rated, Yelp default, or elite reviews
• Limit results - set a maximum number of reviews per business
• Automatic pagination - fetches all available review pages automatically

Custom plans

Looking to retrieve a lot of reviews or business details? Reach out to sales@beatanalytics.org for Enterprise plans.

Input fields

Required

• urls: List of Yelp URLs, business IDs, or business aliases for the businesses you want to retrieve reviews for, e.g. https://www.yelp.com/biz/the-old-fashioned-madison.

Optional

• language: Filter reviews by language (ISO 639-1 code). Supported languages: English, Spanish, French, German, Italian, Dutch, Portuguese, Russian, Japanese, Chinese (Simplified), Chinese (Traditional), Korean, Turkish, Arabic, Danish, Finnish, Norwegian, Swedish, Hebrew, Thai, Polish, Czech, Hungarian, Greek. Defaults to en.
• sortBy: How to order the reviews. Options: newest, oldest, yelp (Yelp default), highestRated, lowestRated, elites. Defaults to newest.
• maxReviews: Maximum number of reviews to fetch per business. Defaults to 100.
• includeSensitiveData: Include reviewer personal information (name, location, profile URL, friend count, photo count, review count, elite year) in the output. Defaults to false.

Output format

CSV file

Scraped reviews are stored in a CSV file named reviews.csv. The file contains the following columns:

• business_id: Yelp business ID
• business_alias: Yelp business alias (URL slug)
• business_url: Link to the Yelp business page
• review_id: Unique review identifier
• review_url: Link to the review on Yelp
• rating: Star rating (1-5)
• text: Full review text
• language: Review language (ISO 639-1 code)
• date: Review date
• image_count: Number of images attached to the review
• feedback_useful: Number of "useful" votes
• feedback_funny: Number of "funny" votes
• feedback_cool: Number of "cool" votes
• reply_id: Business owner reply ID (if any)
• reply_text: Business owner reply text (if any)
• reply_date: Business owner reply date (if any)

When includeSensitiveData is enabled, the following columns are also included:

• reply_user_name: Name of the business owner who replied
• reply_user_role: Role of the replying user (e.g. "Business Owner")
• user_id: Reviewer's Yelp user ID
• user_url: Link to the reviewer's Yelp profile
• user_name: Reviewer's display name
• user_location: Reviewer's location
• user_friend_count: Number of friends the reviewer has
• user_photo_count: Number of photos the reviewer has posted
• user_review_count: Number of reviews the reviewer has written
• user_elite_year: Year the reviewer achieved Yelp Elite status (if applicable)

Example CSV output

business_id,business_alias,business_url,review_id,review_url,rating,text,language,date,image_count,feedback_useful,feedback_funny,feedback_cool,reply_id,reply_text,reply_date
RJNAeNA-209sctUO0dmwuA,the-old-fashioned-madison,https://www.yelp.com/biz/the-old-fashioned-madison,abc123,https://www.yelp.com/biz/the-old-fashioned-madison?hrid=abc123,5,"Absolutely loved this place! The cheese curds were perfectly crispy and the Old Fashioned cocktail was top-notch. Great atmosphere right on the Capitol Square.",en,2024-08-12,2,4,1,2,,,
RJNAeNA-209sctUO0dmwuA,the-old-fashioned-madison,https://www.yelp.com/biz/the-old-fashioned-madison,def456,https://www.yelp.com/biz/the-old-fashioned-madison?hrid=def456,4,"Solid Wisconsin comfort food. The Friday fish fry is a must-try. Only downside is the long wait times on weekends - get there early!",en,2024-07-28,0,2,0,1,reply789,"Thanks for the kind words! We're glad you enjoyed the fish fry. Pro tip: reservations help with the weekend rush!",2024-07-30

Apify Dataset

The results are stored in a dataset which you can find in the Storage tab. Each item in the dataset represents a single review.

Example JSON output

{
  "business_id": "RJNAeNA-209sctUO0dmwuA",
  "business_alias": "the-old-fashioned-madison",
  "business_url": "https://www.yelp.com/biz/the-old-fashioned-madison",
  "review_id": "abc123",
  "review_url": "https://www.yelp.com/biz/the-old-fashioned-madison?hrid=abc123",
  "rating": 5,
  "text": "Absolutely loved this place! The cheese curds were perfectly crispy and the Old Fashioned cocktail was top-notch. Great atmosphere right on the Capitol Square.",
  "language": "en",
  "date": "2024-08-12",
  "images": [
    {
      "url": "https://s3-media0.fl.yelpcdn.com/bphoto/example1/o.jpg",
      "caption": "Wisconsin cheese curds"
    },
    {
      "url": "https://s3-media0.fl.yelpcdn.com/bphoto/example2/o.jpg",
      "caption": null
    }
  ],
  "feedback": {
    "useful": 4,
    "funny": 1,
    "cool": 2
  },
  "businessOwnerReply": null,
  "user": null
}

Example JSON output with sensitive data enabled

When includeSensitiveData is set to true, the user field is populated with reviewer information:

{
  "business_id": "RJNAeNA-209sctUO0dmwuA",
  "business_alias": "the-old-fashioned-madison",
  "business_url": "https://www.yelp.com/biz/the-old-fashioned-madison",
  "review_id": "def456",
  "review_url": "https://www.yelp.com/biz/the-old-fashioned-madison?hrid=def456",
  "rating": 4,
  "text": "Solid Wisconsin comfort food. The Friday fish fry is a must-try. Only downside is the long wait times on weekends - get there early!",
  "language": "en",
  "date": "2024-07-28",
  "images": [],
  "feedback": {
    "useful": 2,
    "funny": 0,
    "cool": 1
  },
  "businessOwnerReply": {
    "id": "reply789",
    "text": "Thanks for the kind words! We're glad you enjoyed the fish fry. Pro tip: reservations help with the weekend rush!",
    "date": "2024-07-30",
    "user": {
      "id": "owner123",
      "name": "The Old Fashioned",
      "role": "Business Owner",
      "image": "https://s3-media0.fl.yelpcdn.com/bphoto/owner/ms.jpg"
    }
  },
  "user": {
    "id": "user456",
    "url": "https://www.yelp.com/user_details?userid=user456",
    "name": "Sarah M.",
    "location": "Madison, WI",
    "image": "https://s3-media0.fl.yelpcdn.com/photo/user456/ms.jpg",
    "friendCount": 42,
    "photoCount": 15,
    "reviewCount": 87,
    "eliteYear": 2023
  }
}