Marketing Data Extractor Icon

Pull TikTok Data Into Google Sheets - No Code, No API Keys

Paste TikTok usernames or hashtags. Click extract. Get structured follower counts, video views, and engagement data in your spreadsheet in seconds.

Install Free - 30 Credits, No Credit Card Works with any Google account. Free forever tier.
No developer needed
Works in Google Sheets
Free to start
Built on Google Workspace Marketplace
35+ Data Fields Extracted
Free to install, no credit card

The Old Way

  • Open TikTok in browser, navigate to each creator profile manually
  • Copy follower count, paste. Copy average views, paste. Copy engagement rate, paste. Repeat.
  • Do this for 50 creators. Lose 4 hours. Miss the creators that actually matter.
  • Client asks for trending hashtag analysis. You have no system for it.
  • Try TikTok's API. Realize you need a developer and a TikTok for Business account.

~4 hours per week

With Marketing Data Extractor

  1. Paste TikTok usernames or hashtags into a column in Google Sheets
  2. Open the add-on from Extensions, select your data fields
  3. Click "Extract". Profile data and video metrics populate instantly.

~60 seconds

(Yes, really.)

Everything You Can Extract from TikTok

35+ data fields. Pull exactly what you need, nothing more.

TikTok Profile Data

Extract follower count, following count, total videos, total likes, bio text, verified status, and business category for any public TikTok profile.

Hashtag Video Search

Pull top-performing videos for any TikTok hashtag. See view counts, engagement rates, top creators, and trending content in your niche right now.

Bulk Username Processing

Paste a full column of TikTok usernames. Extract profile data and video metrics for all of them in a single click. No repetition, no navigating to each account.

35+ Customizable Data Fields

Choose exactly what you need: followers, video views, likes, comments, shares, video duration, caption text, hashtags used. No data you don't want cluttering your sheet.

Video-Level Performance Data

Go beyond profile totals. Extract individual video metrics — views, likes, comments, shares, duration — for up to 200 videos per account. See exactly what's performing.

Country Filter & Sort Controls

Filter by country, sort by latest or most viewed, include or exclude reposts and pinned posts. Data lands in clean, sortable columns ready for analysis.

3 TikTok Workflows Marketers Run Every Week

FOR SOCIAL MEDIA MANAGERS

TikTok Creator Vetting at Scale

You're evaluating 50 TikTok creators for a campaign. Paste their @handles → extract follower count, average video views, and engagement rate → filter by performance in Sheets → shortlist in 20 minutes.

What used to take a full day takes one coffee break.

Saves ~5 hours per campaign

FOR MARKETING OPS

Weekly Competitor TikTok Tracking

Monitor 15 competitor TikTok accounts weekly. Paste their handles → extract posting frequency, total likes, and recent video performance → track who's growing fast and what content is landing.

Know what your competitors are doing before your CMO asks.

Saves ~3 hours per week

FOR MARKETING AGENCIES

TikTok Audits & Viral Content Research

Client wants to know what's trending on TikTok in their niche. Extract top hashtag videos → see which content formats are getting views → build a data-backed content brief. All in Sheets. All in 20 minutes.

Data-backed TikTok strategy. No guesswork, no hours lost.

Saves ~8 hours per client audit

Pay Only for What You Extract

No monthly subscription. No seat fees. Credits never expire. Replace your $49/month tool with what you actually use.

Free

$0

30 credits included

  • Works with any Google account
  • TikTok profile extraction
  • Hashtag video search
  • 35+ data fields
  • No credit card required
Install Free
Best Entry Point

Starter

$9 one-time

600 credits

  • Everything in Free
  • Bulk username processing
  • Video-level metrics
  • Credits never expire
Get Started
Most Popular

Professional

$19 one-time

1,500 credits

  • Everything in Starter
  • Best value per credit
  • One purchase, use for months
  • 1,500 extractions
Get Professional

Need more? Business ($29 / 2,500 credits) and Enterprise ($49 / 4,500 credits) available. See all pricing tiers →

Common Questions

Not at all. If you know how to use Google Sheets, you can use Marketing Data Extractor. There's no terminal, no API keys, no JSON configuration. You paste usernames or hashtags, select your fields, and click extract.

No. The add-on handles all of that behind the scenes. You don't need a TikTok developer account, TikTok for Business access, or any technical setup whatsoever. Just your Google account.

Yes. It installs as an add-on and adds itself to your Extensions menu. It works inside any new or existing spreadsheet on your Google account.

No. Credits are permanent. Buy once, use whenever. There's no subscription and no monthly lock-in. Your $9 starter credits will still be there 6 months from now if you haven't used them.

You can paste a full column of TikTok usernames and extract all of them in one click. For video data, you can pull up to 200 videos per account per extraction. Volume depends on your credit balance.

No. Marketing Data Extractor only extracts publicly available data from public TikTok profiles, hashtags, and videos — the same data visible to anyone on TikTok.com without logging in. Private accounts are not accessible.

Start Extracting TikTok Data in 60 Seconds

30 free credits. No credit card. Install directly from Google Workspace Marketplace.

Install Free - No Credit Card

Built by Smacient. Made for marketers.

Contact Us