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 profiles data fields are sent to Google Sheets?

All 29 output fields from the Yelp Business Profiles scraper are included: business_id, yelp_biz_id, name, url, overall_rating, reviews_count, 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 profiles into Google Sheets?

Each business profiles 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 Profiles into Google Sheets

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

Step-by-step guide

Choose the Yelp Business Profiles scraper

Navigate to the Yelp Business Profiles 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 29 structured fields like business_id, yelp_biz_id, name, url, and more. New jobs append additional rows automatically.

Cost per record

1 credit

Output fields

29 fields

Destination

Google Sheets

Sample Output

Preview the data you'll receive — 5 sample records

Record 1 of 5

Business Id

sample_business_id

Yelp Biz Id

sample_yelp_biz_id

Name

Sarah Chen

Url

sample_url

Overall Rating

1,000

Reviews Count

457

Is Claimed

Yes

Is Closed

Yes

Data Dictionary

29 fields returned per record

A unique identifier for the business (100.00% fill rate)

The Yelp business ID associated with the business (100.00% fill rate)

The name of the business (100.00% fill rate)

The URL or link to the business page (100.00% fill rate)

The overall rating of the business (99.89% fill rate)

The total number of reviews for the business (99.89% fill rate)

Indicates whether the business has been claimed on Yelp (97.28% fill rate)

Indicates whether the business is permanently closed (98.26% fill rate)

Categories or tags associated with the business (97.23% fill rate)

Sub-fields

titleTextCategory display name

aliasTextCategory alias/slug

The website URL of the business (55.64% fill rate)

The contact phone number for the business (96.78% fill rate)

The complete address of the business (99.99% fill rate)

The street address of the business (99.94% fill rate)

Sub-fields

CityTextCity

CountryTextCountry

StateTextState

zip_codeTextZIP code

The ZIP code or postal code of the business location (99.61% fill rate)

The city in which the business is located (99.83% fill rate)

The state or region in which the business is located (99.83% fill rate)

The country in which the business is located (99.83% fill rate)

The ZIP code of the business location (99.51% fill rate)

The latitude coordinate of the business location (83.90% fill rate)

The longitude coordinate of the business location (83.90% fill rate)

The business's operating hours (60.63% fill rate)

Sub-fields

MonTextMonday hours

TueTextTuesday hours

WedTextWednesday hours

ThuTextThursday hours

FriTextFriday hours

SatTextSaturday hours

SunTextSunday hours

The price range associated with the business ($: Inexpensive, $$: Moderate, $$$: Pricey, $$$$: Very expensive) (13.49% fill rate)

Amenities or features offered by the business (45.77% fill rate)

Sub-fields

nameTextAmenity name

availableBooleanWhether the amenity is available

The services offered by the business (48.92% fill rate)

Sub-fields

nameTextService name

availableBooleanWhether the service is offered

Information or a description about the business (42.02% fill rate)

Highlighted features or offerings of the business (0.99% fill rate)

Sub-fields

textTextHighlight text

The geographic area or region served by the business (14.42% fill rate)

Updates or information provided by the business (7.11% fill rate)

Sub-fields

dateTextUpdate date

textTextUpdate text content

imageTextUpdate image URL

URLs for images and videos (27.32% fill rate)

Sub-fields

urlTextMedia URL

typeTextMedia type (image or video)

captionTextMedia caption

Frequently Asked Questions

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

Ready to connect Yelp data to Google Sheets?

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

Go to Yelp Business Profiles scraper Browse all integration guides

No code requiredAuto-delivery to Google Sheets29 data fields