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

All 36 output fields from the TikTok Shop Products scraper are included: url, title, available, description, currency, initial_price, and more. The full payload is sent as structured JSON — no fields are filtered out.

Can I schedule recurring TikTok 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 TikTok shop products into Google Sheets?

Each shop products 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.

TikTokGoogle Sheets

How to Scrape TikTok Shop Products into Google Sheets

Extract shop products data from TikTok and sync to Google Sheets automatically

Step-by-step guide

Choose the TikTok Shop Products scraper

Navigate to the TikTok Shop Products 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 TikTok input URLs

Paste the TikTok 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 36 structured fields like url, title, available, description, and more. New jobs append additional rows automatically.

Cost per record

1 credit

Output fields

36 fields

Destination

Google Sheets

Sample Output

Preview the data you'll receive — 5 sample records

Record 1 of 5

Url

sample_url

Title

How We Scaled to 1M Users

Available

Yes

Description

Enterprise-grade data pipeline platform with real-time processing and 99.99% uptime SLA.

Currency

sample_currency

Initial Price

1,000

Final Price

1,000

Discount Percent

1,000

Initial Price Low

1,000

Initial Price High

1,000

Final Price Low

1,000

Final Price High

1,000

Sold

1,000

Colors

sample_colors

Sizes

sample_sizes

Shipping Fee

1,000

Specifications

sample_specifications

Reviews Count

457

Reviews

475

Store Details

sample_store_details

Images

sample_images

Domain

sample_domain

Videos

sample_videos

Data Dictionary

36 fields returned per record

Product URL (100.00% fill rate)

Product title (100.00% fill rate)

Whether the product is available for purchase (100.00% fill rate)

Product description (98.00% fill rate)

Currency of the product price (100.00% fill rate)

Original price before discount (96.00% fill rate)

Final price after discount (96.00% fill rate)

Discount percentage applied to the product (100.00% fill rate)

Lowest initial price in a price range (18.00% fill rate)

Highest initial price in a price range (2.00% fill rate)

Lowest final price in a price range (96.00% fill rate)

Highest final price in a price range (18.00% fill rate)

Total number of units sold (100.00% fill rate)

Available colors for the product (38.00% fill rate)

Available sizes for the product (21.00% fill rate)

Shipping fee for the product (68.00% fill rate)

Product technical specifications (73.00% fill rate)

Sub-fields

titleTextSpecification name

valueTextSpecification value

Total number of product reviews (89.00% fill rate)

Customer reviews for the product (49.00% fill rate)

Sub-fields

nameTextReviewer name

ratingTextReview rating

reviewTextReview text

itemTextItem variant reviewed

dateTextReview date

imagesArrayReview images

Details about the seller store (100.00% fill rate)

Sub-fields

nameTextStore name

urlTextStore URL

num_of_itemsNumberNumber of items in store

ratingNumberStore rating

num_soldNumberTotal items sold by store

followersNumberStore followers count

badgeTextStore badge or certification

Product images (100.00% fill rate)

Domain of the product listing (100.00% fill rate)

Product videos (14.00% fill rate)

Product category (65.00% fill rate)

URL of the product category page (69.00% fill rate)

Unique product ID (100.00% fill rate)

Unique seller ID (93.00% fill rate)

Overall product rating (44.00% fill rate)

Product position in search results (0.00% fill rate)

Product variations (size, color, etc.) (91.00% fill rate)

Sub-fields

skuTextSKU identifier

sku_sales_propsArraySKU sales properties

stockNumberStock quantity

purchase_limitNumberMaximum purchase quantity

initial_priceNumberOriginal price for this variation

final_priceNumberFinal price for this variation

currencyTextCurrency

discount_percentNumberDiscount percentage

imageTextVariation image URL

Whether the product is in stock (21.00% fill rate)

Promotional bundle items (2.00% fill rate)

Detailed product description (21.00% fill rate)

Related TikTok videos featuring this product (5.00% fill rate)

Sub-fields

linkTextVideo link

likesNumberNumber of likes

user_nameTextCreator username

commission_paidBooleanWhether commission was paid

Primary product video link (0.00% fill rate)

Shop performance metrics (21.00% fill rate)

Sub-fields

metricTextMetric name

valueTextMetric value

Frequently Asked Questions

Common questions about How to Scrape TikTok Shop Products into Google Sheets

Ready to connect TikTok data to Google Sheets?

Start extracting tiktok shop products data and sync to Google Sheets in minutes.

Go to TikTok Shop Products scraper Browse all integration guides

No code requiredAuto-delivery to Google Sheets36 data fields