I'd like to get engagement data from our organic TikTok videos - views, likes, and comments - and import this into a Google Sheet each morning. The only trigger or action I see related to TikTok is TikTok Conversions, which is related to ads only (not organic posts/videos).
Hi
Welcome to the Community.
TikTok's API does not officially support fetching data from organic posts or videos, which limits automation options via tools like Zapier. However, there are alternatives to manually tracking TikTok engagement data, including manually entering it into Google Sheets, using third-party analytics services, or utilizing web scraping. The latter may require developer assistance and can be unreliable. It's essential to ensure that any method used complies with TikTok's terms of service and respects user privacy.
If you have any question, please don’t hesitate to ask here in the Community.
Hi
You’re quite right! Currently the only TikTok apps we have available on Zapier relate to ads specifically. But we do have a more video-focused TikTok app on our internal wishlist of apps to have added to Zapier, which could open the door to getting the engagement data you’re after. So I’ve added your vote to that. I can’t make any promises around when it might be added by but we’ll be sure to let you know once it is!
I had a quick look but couldn’t find a specific reporting endpoint on TikTok’s API that wasn’t ads-related but I did come across a Query Videos endpoint that looks like it would give you access to the number of views and likes a specific video has received:
To access the comments you’d need to use a separate call to their Query Video Comments endpoint.
So you might be able to access that information using a Webhooks action. Granted, it’s a bit advanced as you’d need to reference TikTok’s API documentation to ensure the webhook is set up correctly but we have a general guide on how to set up webhook actions that you might find useful: Send webhooks in Zaps.
Hope that helps to get you pointed in the right direction. If you run into any issues or have further questions just let us know!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.