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

All 14 output fields from the TikTok Shop Categories scraper are included: url, product_id, category_url, category_name, sub_categories, title, 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 categories into Google Sheets?

Each shop categories 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 Categories into Google Sheets

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

Step-by-step guide

Choose the TikTok Shop Categories scraper

Navigate to the TikTok Shop Categories 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 14 structured fields like url, product_id, category_url, category_name, and more. New jobs append additional rows automatically.

Cost per record

1 credit

Output fields

14 fields

Destination

Google Sheets

Sample Output

Preview the data you'll receive — 5 sample records

Record 1 of 5

Url

sample_url

Product Id

sample_product_id

Category Url

sample_category_url

Category Name

sample_category_name

Sub Categories

sample_sub_categories

Title

How We Scaled to 1M Users

Initial Price

1,000

Final Price

1,000

Currency

sample_currency

Product Rating

1,000

Sold

1,000

Position

Software Engineer III

Product Image

sample_product_image

Data Dictionary

14 fields returned per record

Product URL (100.00% fill rate)

Product ID (100.00% fill rate)

Category URL (100.00% fill rate)

The category name (100.00% fill rate)

The sub categories of the main category (0.00% fill rate)

Sub-fields

nameTextSub-category name

urlTextSub-category URL

The product's title (100.00% fill rate)

The product's initial price (100.00% fill rate)

The product's final price (100.00% fill rate)

Currency of the price (100.00% fill rate)

The product rating (100.00% fill rate)

The number of products sold (100.00% fill rate)

The product's position on the page (100.00% fill rate)

The product image URL (100.00% fill rate)

All categories the product belongs to (100.00% fill rate)

Sub-fields

nameTextCategory name

urlTextCategory URL

Frequently Asked Questions

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

Ready to connect TikTok data to Google Sheets?

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

Go to TikTok Shop Categories scraper Browse all integration guides

No code requiredAuto-delivery to Google Sheets14 data fields