Collection of TikTok metrics in Google Sheets
201 USD Develop a system for automatic analytics collection from TikTok via the official API and recording the obtained data in Google Sheets.
List of metrics:
For each post, it is necessary to obtain and store the following indicators:
- Link
- Content type (video/photo carousel)
- Hours ago (when it was published)
- Views
- Likes
- Comments
- Reposts
- Saves
- Average watch time (Sec)
- Reach
- % Readers (reach)
- % Non-readers (reach)
- New followers
- % Full view
- % Retention rate
Functional requirements:
- Access via TikTok API – obtaining data through the official TikTok API.
- OAuth2 authorization – implementation of login via OAuth2 (documentation in TikTok for Developers).
- Connecting multiple accounts – the ability to authorize and collect data from multiple TikTok accounts.
- Automatic data collection – updating metrics every 6 hours.
- Long-term updating – data collection for 1 year from the moment of post publication.
- Recording in Google Sheets – automatic recording of data in the specified Google spreadsheet.
- Data must be recorded in table format, where each row is a separate post.
- New data must update existing records if the post is not new.
Deadline - 2 days
-
20 days603 USD
8778 60 0 1 20 days603 USD
Good day. Ready to execute.
I have extensive experience in creating parsers.
I code in Python, I am ranked 2nd on the platform.
I will develop a parser to collect the necessary metrics and record them in a table. I will set up OAuth2 authorization. There will be the possibility to connect multiple accounts. I will integrate the API.
I will implement updates and data collection throughout the year. All processes will be automated.
I will create a user-friendly interface for management. I will optimize.
My portfolio:
Freelancehunt
… Write to me, we will discuss the details and I will get to work.
-
2 days201 USD
4461 102 0 2 days201 USD
Good evening. I will be happy to help. We can discuss the project details!
-
3 days201 USD
1050 22 1 3 days201 USD
Good day
I am interested in your project
I propose to do it on Google Apps Script
-
3 days201 USD
2044 23 0 3 days201 USD
Hello! Do you already have a Google Sheets structure created where data from TikTok needs to be recorded, or do you want me to do that? I will be able to specify a more accurate time and budget in personal correspondence.
How I plan to execute this project:
1. I will use the official TikTok API to obtain data. This will give me access to all the necessary metrics for each post.
2. I will implement OAuth2 authorization for login. This will allow connecting multiple TikTok accounts for data collection.
3. I will develop a system for automatic data collection and recording in Google Sheets every 6 hours. This means that the data will always be up to date.
Thank you for considering my proposal. I am impressed by the opportunity to collaborate with you!
Current freelance projects in the category Data Parsing
A specialist in Telegram promotion is required.
29 USD
Tasks: invite real users from the username database to new chats and send messages to the target database. Only quality traffic and work with a live audience are of interest — performers using bots, fake engagement, or low-quality methods are requested NOT TO DISTURB. Work… Data Parsing, Social Media Marketing (SMM) ∙ 19 hours 14 minutes back ∙ 6 proposals |
Collection of B2B database of companies in Germany
41 USD
Goal: To obtain a list of potential employers (clients) for B2B mailing. Region: Munich (München) + radius of 50 km. Required niches: Construction companies (Bauunternehmen) Food enterprises (Lebensmittelhersteller, meat processing plants, bakeries) Logistics and… Data Parsing, Lead Generation & Sales ∙ 21 hours 31 minutes back ∙ 24 proposals |
Carrier databaseInterested in compiling a database of carriers in Ukraine for the year 2026, including tankers, tarpaulins, grain carriers, and others. It is preferable to develop a table. Information Gathering, Data Parsing ∙ 22 hours 48 minutes back ∙ 28 proposals |
Consultation on parsing Instagram account subscribersHello. It is necessary to conduct a preliminary assessment of the feasibility of the following task. I have a list of Instagram accounts. The goal is to obtain contact information (primarily email addresses) of users who follow these accounts. Previously, I encountered companies… Data Parsing ∙ 4 days 14 hours back ∙ 12 proposals |
A specialist is needed to find contacts of decision-makers in Ukraine.It is necessary to gather a database (or ready database) of contacts of decision-makers (DMs) in companies in Ukraine. Information Gathering, Data Parsing ∙ 4 days 18 hours back ∙ 18 proposals |
Kyiv