TikTok Comment Fetcher Tool
What's TikTok Comment Fetcher?
TikTok Comment Fetcher is a powerful Google Sheets add-on that instantly gathers audience comments from TikTok videos and organizes them in your spreadsheet. With clear, actionable insights at your fingertips, you can spot trends, gauge sentiment, and fine-tune campaign strategies—saving hours of manual work while making smarter, data-driven decisions.
Step-By-Step Instructions
1. Install TikTok Comment Fetcher
Go to the Google Workspace Marketplace, search and install TikTok Comment Fetcher for your Google account.
Or directly install via this provided URL.
2. How to run TikTok Comment Fetcher
Step 1: Prepare Your Google Sheet
Create a new or open an existing Google Sheet.
In the first row (Row 1) of the sheet, paste the full URLs of the TikTok videos you'd like to analyze
Step 2: Launch the Add-On
Click the add-on icon located on the right side of your sheet (typically a puzzle-piece icon or toolbar button).
Select "Start Fetching Comments".
Step 3: Authorize Access
A prompt will guide you to grant access.
Copy sheet-manager email address and share your sheet with that email as Editor permission.
Step 4: Fetch Comments
Return to the sheet and click "Check again" (to confirm permission setup).
Then click "Start fetching comment" once more to initiate the process.
Step 5: Wait for Results
The add-on will process your request. Once data is ready:
A new tab named "result" will appear in your sheet.
You’ll receive an email notification confirming completion.
🎥 Visual Walkthrough
For a clear visual demonstration, watch the TikTok Comment Fetcher Instructional Video below:
You can submit up to 100 TikTok video URLs in a single execution sheet.
Limitation:
The tool fetches up to 100 comments per video in each run. To retrieve additional comments, create a new Google Sheet and start a fresh fetch.
Last updated
Was this helpful?