Export TikTok Post Commenters to a Spreadsheet
Extract all commenters from any TikTok video. Paste a fetch() from DevTools to scrape usernames, comment text, likes, and profile info with automatic pagination.
Key Takeaways
- Scrape any TikTok video's commenters - Extract everyone who commented on a TikTok post with one workflow
- Rich profile data - Captures username, nickname, bio, follower count, and verification status
- Comment context - Preserves the comment text, likes, reply count, and timestamp for each commenter
- Automatic pagination - Loops through all comment pages (20 per page) with rate limiting
- Saves as you go - Each page of commenters is written to Google Sheets in real time
What This Workflow Does
This workflow scrapes all commenters from any TikTok video. You copy a network request from your browser's DevTools while viewing a video's comments, paste it into the workflow, and it handles pagination automatically. Each commenter's profile info and their comment are exported to your Google Sheet.
Use cases:
- Building lead lists from commenters on viral TikTok videos
- Identifying engaged audiences on competitor or industry content
- Collecting user feedback and sentiment from video comments
- Finding potential influencers or brand advocates by follower count
- Market research by analyzing who engages with specific content
How It Works
| Step | What Happens |
|---|---|
| 1. Manual trigger | You paste the fetch() request copied from TikTok DevTools |
| 2. Parse fetch request | Extracts the URL, headers, cookies, and video ID from the pasted request |
| 3. Pagination loop | Iterates through comment pages (20 per page, max 200 pages) |
| 4. Build page URL | Updates the API URL with the current pagination cursor |
| 5. Wait 3 seconds | Pauses between TikTok API calls to avoid rate limiting |
| 6. HTTP request | Fetches the current page of comments from TikTok's API |
| 7. Extract commenters | Parses the response to get usernames, bios, comments, and follower counts |
| 8. Save to Google Sheets | Writes the extracted data to your spreadsheet |
| 9. Check pagination | Determines if there are more comment pages and continues the loop |
Workflow Nodes
| Node | Role |
|---|---|
| Manual Trigger | Accepts the pasted fetch() request from DevTools |
| Code (Parse Fetch) | Extracts URL, headers, cookies, and aweme_id (video ID) from the fetch request |
| Loop | Iterates through comment pages (condition: hasMore and page < 200) |
| Code (Build URL) | Constructs the API URL with the current cursor offset |
| Wait (3s) | Delays 3 seconds between TikTok API calls |
| HTTP Request | Sends a GET request to TikTok's comment list API |
| Merge | Combines the HTTP response with the build context |
| Code (Extract Commenters) | Parses TikTok response to get commenter profiles and comment data |
| AI Agent (Gemini Flash) | Saves the extracted commenters to Google Sheets |
| Merge | Combines save results with pagination data |
| Code (Prepare Loop End) | Extracts hasMore and cursor for the next loop iteration |
Data Exported Per Commenter
| Column | Field | Description |
|---|---|---|
| A | username | TikTok username (@handle) |
| B | nickname | Display name |
| C | tiktok_url | TikTok profile URL |
| D | comment_text | The actual comment they left on the video |
| E | comment_likes | Number of likes on the comment |
| F | replies | Number of replies to the comment |
| G | bio | TikTok profile bio / signature |
| H | followers | Follower count |
| I | created_at | Comment timestamp (ISO format) |
| J | page | Which page of comments this came from |
Setup Instructions
- Add the "Export TikTok Post Commenters to a Spreadsheet" template to Needle
- Go to TikTok and navigate to the target video
- Click to view the comments section
- Open browser DevTools (F12) and go to the Network tab
- Scroll down in comments to trigger pagination
- Filter by "comment/list" in the Network tab
- Find the
api/comment/listrequest - Right-click the request, then select Copy, then Copy as fetch
- Paste the copied fetch() into the Manual Trigger node
- Update the Google Sheet URL in the AI Agent node prompt
- Connect your Google Sheets account via the Pipedream connector
- Run the workflow
Customization
| What You Can Change | How |
|---|---|
| Google Sheet columns | Update the column mapping in the AI Agent prompt |
| Target spreadsheet | Update the sheet URL in the AI Agent prompt |
| Page delay | Change the Wait node duration (default: 3 seconds) |
| Max pages | Change the loop condition (default: page < 200) |
| AI model | Change the model in the AI Agent node (default: Gemini Flash) |
FAQ
Q: How do I find the right network request?
A: After opening DevTools and the Network tab, scroll down in the comments section of any TikTok video. Filter by "comment/list" — you should see requests to tiktok.com/api/comment/list. Pick any one and copy as fetch.
Q: Why does TikTok stop working sooner than Instagram?
A: TikTok's anti-bot tokens (X-Bogus, X-Gnarly, msToken) tend to expire faster than Instagram cookies (roughly 1-2 hours vs 24 hours). If requests start failing, just re-copy a fresh fetch() from DevTools.
Q: Can I scrape replies to comments too?
A: This template only scrapes top-level comments. Reply scraping would require a separate API call per comment. The replies column shows how many replies each comment has.
Q: How many comments can I scrape? A: Up to 4,000 comments (200 pages x 20 per page). Most videos have fewer comments than this. You can increase the page limit in the loop condition if needed.
Q: Can I combine this with LinkedIn enrichment? A: Yes! Use the "Scrape Instagram Commenters and Enrich with LinkedIn" template as a reference. You can replace the AI save node with an enrichment node that searches LinkedIn for each commenter before saving.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
