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

All 38 output fields from the TikTok Profiles scraper are included: account_id, nickname, biography, awg_engagement_rate, comment_engagement_rate, like_engagement_rate, 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 profiles into Google Sheets?

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

TikTokGoogle Sheets

How to Scrape TikTok Profiles into Google Sheets

Extract profiles data from TikTok and sync to Google Sheets automatically

Step-by-step guide

Choose the TikTok Profiles scraper

Navigate to the TikTok 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 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 38 structured fields like account_id, nickname, biography, awg_engagement_rate, and more. New jobs append additional rows automatically.

Cost per record

1 credit

Output fields

38 fields

Destination

Google Sheets

Sample Output

Preview the data you'll receive — 5 sample records

Record 1 of 5

Account Id

sample_account_id

Nickname

Sarah

Biography

sample_biography

Awg Engagement Rate

1,000

Comment Engagement Rate

1,000

Like Engagement Rate

1,000

Bio Link

sample_bio_link

Predicted Lang

sample_predicted_lang

Is Verified

Yes

Followers

28,401,080

Following

278

Likes

34,108

Videos Count

1,000

Create Time

sample_create_time

ACoAABcXYZ123

Url

sample_url

Profile Pic Url

sample_profile_pic_url

Like Count

1,000

Digg Count

1,000

Is Private

Yes

Profile Pic Url Hd

sample_profile_pic_url_hd

Secu Id

sample_secu_id

Short Id

sample_short_id

Ftc

sample_ftc

Relation

sample_relation

Open Favorite

Yes

Comment Setting

sample_comment_setting

Duet Setting

sample_duet_setting

Stitch Setting

sample_stitch_setting

Is Ad Virtual

Yes

Room Id

sample_room_id

Is Under Age 18

sample_is_under_age_18

Data Dictionary

38 fields returned per record

A unique identifier for the TikTok account (100.00% fill rate)

The username or display name of the TikTok user (99.98% fill rate)

The bio or description provided by the TikTok user in their profile (36.70% fill rate)

The average engagement rate for the user's content (66.53% fill rate)

The engagement rate specifically related to comments on the user's content (66.53% fill rate)

The engagement rate specifically related to likes on the user's content (66.53% fill rate)

The link provided in the user's bio (3.23% fill rate)

The predicted language of the user's content (98.82% fill rate)

Indicates whether the TikTok account is verified (100.00% fill rate)

The number of followers the TikTok user has (100.00% fill rate)

The number of accounts that the TikTok user is following (100.00% fill rate)

The total number of likes received by the TikTok user (100.00% fill rate)

The total number of videos uploaded by the TikTok user (100.00% fill rate)

The timestamp indicating when the TikTok account was created (84.27% fill rate)

A unique identifier associated with the TikTok user (100.00% fill rate)

The URL or link to the TikTok user's profile (85.31% fill rate)

URL to the profile picture of the TikTok user (89.24% fill rate)

The total number of likes received by the user's content (84.32% fill rate)

The total number of "Digg" interactions received by the user's content (89.24% fill rate)

Indicates whether the TikTok account is private (84.32% fill rate)

URL to the profile picture (89.24% fill rate)

A identifier associated with the TikTok user (88.20% fill rate)

A shorter identifier associated with the TikTok user (0.00% fill rate)

Federal Trade Commission (0.04% fill rate)

Relation information (0.04% fill rate)

Information about open favoriting settings (88.21% fill rate)

Comment settings chosen by the user (5.20% fill rate)

Duet settings chosen by the user (11.71% fill rate)

Stitch settings chosen by the user (11.60% fill rate)

Indicates whether the user is associated with virtual advertising (85.30% fill rate)

The ID associated with the user's TikTok room (0.02% fill rate)

Indicates whether the user is under the age of 18 (0.01% fill rate)

Information about the user's top-performing videos (44.38% fill rate)

Sub-fields

video_idTextVideo ID

share_countNumberNumber of shares

playcountNumberNumber of plays

diggcountNumberNumber of likes (diggs)

commentcountNumberNumber of comments

create_dateTextVideo creation date

video_urlTextVideo URL

cover_imageTextVideo cover image URL

favorites_countNumberNumber of times added to favorites

The signature or tagline provided by the TikTok user (33.40% fill rate)

Automatic data point sending from the discovery, not needed in the case of manual execution (84.26% fill rate)

Sub-fields

search_urlTextDiscovery search URL

countryTextCountry filter for discovery

Indicates whether the user is a commerce user (84.25% fill rate)

Information about the user's top-performing posts (42.17% fill rate)

Sub-fields

post_urlTextPost URL

post_idTextPost ID

descriptionTextPost description

likesNumberNumber of likes

hashtagsArrayPost hashtags

create_timeTextPost creation time

post_typeTextType of post

Pinned posts data (5.47% fill rate)

Sub-fields

urlTextPinned post URL

descriptionTextPinned post description

thumbnail_urlTextPinned post thumbnail URL

Frequently Asked Questions

Common questions about How to Scrape TikTok Profiles into Google Sheets

Ready to connect TikTok data to Google Sheets?

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

Go to TikTok Profiles scraper Browse all integration guides

No code requiredAuto-delivery to Google Sheets38 data fields