TikTok Comment and Utterance Tool

What's TikTok Comment and Utterance?

TikTok Comments and Utterances is a Google Sheets add-on that automatically collects audience comments and spoken content (utterances) from TikTok videos and organizes them into a structured spreadsheet. This allows your team to analyze audience reactions and creator messaging together in a single, unified dataset.

Comments capture how audiences react, while utterances reflect what is actually said in the video. Together, they provide clear, actionable insights—helping you identify trends, understand sentiment, validate messaging, and fine-tune campaign strategies.

With everything structured in Google Sheets, you can 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 Social Media Data Fetcher

2. How to run TikTok Comment Fetcher

Step 1: Prepare Your Google Sheet

  • Create a new or open an existing Google Sheet.

  • In Column A, name the header “Links”, then paste the full TikTok video URLs starting from Row 2 (one URL per row).

circle-exclamation

Step 2: Run 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 "TT Comment Fetcher And Utterance"

  • Then click on "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 Csomment" 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_of_[original name]" will appear in your sheet.

    • You’ll receive an email notification confirming completion.

🎥 Visual Walkthrough

For a clear visual demonstration, watch the TikTok Comment and Utterance Instructional Video below:

circle-exclamation

Running Multiple Tasks

circle-info

The fetching process may take approximately 10–20 minutes, depending on workload, video length, and time zone differences.

triangle-exclamation

Limitation:

Last updated

Was this helpful?