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

All 14 output fields from the TikTok Comments scraper are included: url, post_url, post_id, post_date_created, date_created, comment_text, 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 comments into Google Sheets?

Each comments 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 Comments into Google Sheets

Extract comments data from TikTok and sync to Google Sheets automatically

Step-by-step guide

Choose the TikTok Comments scraper

Navigate to the TikTok Comments 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, post_url, post_id, post_date_created, 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

Post Url

sample_post_url

Post Id

sample_post_id

Post Date Created

sample_post_date_created

Date Created

2025-12-15

Comment Text

Great analysis! Would love to see a deeper dive on the retention metrics.

Num Likes

Num Replies

Commenter User Name

@techfan_99

Commenter Id

sample_commenter_id

Commenter Url

sample_commenter_url

Comment Id

sample_comment_id

Comment Url

sample_comment_url

Replies

Data Dictionary

14 fields returned per record

URL of the TikTok video (100.00% fill rate)

Post web address (100.00% fill rate)

Unique post identifier (100.00% fill rate)

Date of post creation (95.73% fill rate)

Comment creation date (100.00% fill rate)

Comment content (99.38% fill rate)

Number of likes on the comment (100.00% fill rate)

Number of replies to the comment (100.00% fill rate)

Commenter's username (99.93% fill rate)

Commenter's unique identifier (100.00% fill rate)

Commenter's profile URL (100.00% fill rate)

The unique ID for the comment (55.19% fill rate)

The URL for the comment (55.19% fill rate)

Replies to the comment (0.00% fill rate)

Sub-fields

textTextReply text

usernameTextReply author username

likesNumberReply likes count

timestampTextReply timestamp

Frequently Asked Questions

Common questions about How to Scrape TikTok Comments into Google Sheets

Ready to connect TikTok data to Google Sheets?

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

Go to TikTok Comments scraper Browse all integration guides

No code requiredAuto-delivery to Google Sheets14 data fields