How do I connect Google Sheets to Scrapernode?

Connect your Google account in Scrapernode's integration settings, then select the target spreadsheet and sheet. Scrapernode auto-maps scraper output fields to columns.

What Yelp business reviews data fields are sent to Google Sheets?

All 17 output fields from the Yelp Business Reviews scraper are included: review_id, business_id, business_name, url, Review_author, profile_pic_url, and more. The full payload is sent as structured JSON — no fields are filtered out.

Can I schedule recurring Yelp scrapes to Google Sheets?

Yes. Use the Scrapernode REST API to create scraping jobs programmatically on any schedule. Results are automatically delivered to Google Sheets when each job completes.

How much does it cost to scrape Yelp business reviews into Google Sheets?

Each business reviews record costs 1 credit. Credits start at $9 for 3,000 credits (Starter plan). The Google Sheets integration itself is included free — no additional charges for data delivery.

What happens if the Google Sheets delivery fails?

Your scraped data is always stored in Scrapernode regardless of the integration status. If delivery to Google Sheets fails, you can re-trigger the sync or download results manually as CSV or JSON from the job details page.

YelpGoogle Sheets

How to Scrape Yelp Business Reviews into Google Sheets

Extract business reviews data from Yelp and sync to Google Sheets automatically

Step-by-step guide

Choose the Yelp Business Reviews scraper

Navigate to the Yelp Business Reviews scraper in Scrapernode. Select "Fresh Scrape" for real-time data or "Quick Lookup" for pre-collected records. Each record costs 1 credit.

Set up your Google Sheets connection

Connect your Google account and select the target spreadsheet. Scrapernode will auto-create columns matching the scraper's output fields and append new rows as data arrives.

Provide your Yelp input URLs

Paste the Yelp URLs you want to scrape — one per line, or upload a CSV. Scrapernode accepts direct profile links, search result URLs, and content pages.

Launch the scraping job

Click "Start Extraction" to begin. Scrapernode handles proxy rotation, rate limiting, and anti-bot detection automatically. Jobs typically complete in under 60 seconds per batch.

Receive data in Google Sheets

Once the job completes, results are automatically synced to your spreadsheet. Each row contains one record with 17 structured fields like review_id, business_id, business_name, url, and more. New jobs append additional rows automatically.

Cost per record

1 credit

Output fields

17 fields

Destination

Google Sheets

Sample Output

Preview the data you'll receive — 5 sample records

Record 1 of 5

Review Id

sample_review_id

Business Id

sample_business_id

Business Name

Blue Bottle Coffee

Url

sample_url

Review Author

sample_Review_author

Profile Pic Url

sample_profile_pic_url

Rating

1,000

Date

sample_Date

Date Iso Format

sample_date_iso_format

Content

sample_Content

Review Image

sample_Review_image

Reactions

sample_Reactions

Replies

sample_Replies

Review Order

1,000

Elite Status

sample_elite_status

Check In Status

sample_check_in_status

Recommended Review

Yes

Data Dictionary

17 fields returned per record

Unique identifier for the review (100.00% fill rate)

Unique identifier for the business being reviewed (100.00% fill rate)

Name of the business being reviewed (100.00% fill rate)

URL of the review page (100.00% fill rate)

Information about the review author (100.00% fill rate)

Sub-fields

nameTextReview author name

urlTextAuthor profile URL

locationTextAuthor location

reviews_countNumberAuthor total reviews count

friends_countNumberAuthor friends count

photos_countNumberAuthor photos count

URL of the reviewer's profile picture (95.50% fill rate)

Star rating given by the reviewer (1-5 stars) (100.00% fill rate)

Date when the review was posted (100.00% fill rate)

Review date in ISO format (100.00% fill rate)

The full text content of the review (99.80% fill rate)

Array of image URLs attached to the review (35.20% fill rate)

Array of reactions to the review (useful, funny, cool) (80.50% fill rate)

Sub-fields

typeTextReaction type (useful, funny, cool)

countNumberReaction count

Array of replies from business owner or other users (15.30% fill rate)

Sub-fields

textTextReply text

dateTextReply date

authorTextReply author

Order or position of the review on the page (100.00% fill rate)

Elite status of the reviewer (e.g., 'Elite 2024') (25.40% fill rate)

Check-in information for the reviewer at this business (18.60% fill rate)

Whether this is a recommended review (100.00% fill rate)

Frequently Asked Questions

Common questions about How to Scrape Yelp Business Reviews into Google Sheets

Ready to connect Yelp data to Google Sheets?

Start extracting yelp business reviews data and sync to Google Sheets in minutes.

Go to Yelp Business Reviews scraper Browse all integration guides

No code requiredAuto-delivery to Google Sheets17 data fields