Export TikTok comments to CSV without the official API
TikTok has no "download comments" button, and its Research API is limited to approved academic researchers. Yet comments are what marketers, agencies and analysts want most: picking a giveaway winner, reading the reaction to a campaign, collecting text for sentiment analysis. Here is the shortest route I know from a video link to a spreadsheet. One command curl -X POST…
To export TikTok comments to a CSV file without using the official API, a simple command can be used. This command involves sending a POST request to Apify's API, specifying the video link and the desired output format, which is CSV in this case. The command also allows setting a limit on the number of comments per video, with a maximum of 500 per video allowed.
The output from the command includes various details about each comment, such as the date and time it was posted, the number of likes it received, and the text of the comment itself.
The process can be initiated using a Python script with the ApifyClient library, which simplifies the interaction with Apify's services. After running the command, the comments are stored in a CSV file, which can be opened in spreadsheet software or further analyzed. The CSV output allows for easy sorting and filtering, making it convenient for marketers, agencies, and analysts to collect and analyze reactions to TikTok campaigns, create giveaways, or perform sentiment analysis on the comments.
Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.