
Completed
Posted
Paid on delivery
I am launching a small (20-member, soon larger) WhatsApp engagement group for TikTok creators and I need a fast, transparent way to see who actually comments on every reposted video. What I need built • A Google Sheet or Excel file that lets me paste each day’s repost link and, in minutes, shows a green “commented” or red “missed” flag for every member—comments only, no like or watch-time data. • Automated comment retrieval from the public TikTok posts, but with manual override fields so I can fix false negatives on the spot. • A running summary that counts misses per member and instantly highlights anyone who’s fallen behind. • An optional alert (email, in-sheet pop-up, or lightweight WhatsApp message—whatever is simplest) that pings non-active members once the sheet detects a miss. How the workflow should feel 1. I manually add member names once. 2. Each day I drop the new repost URL into a cell. 3. The script pulls public comments, matches usernames, colour-codes results, and updates the dashboard. 4. Total daily admin time stays under an hour—even as the group grows. Deliverables • Fully functioning sheet with all formulas/scripts signed in my account • Clear, step-by-step doc (or short screen-recording) showing how to add new links, adjust the member list, and trigger notifications • Brief support window after delivery to be sure everything runs smoothly I value speed, fairness, and simplicity, so clean code, minimal manual clicks, and an intuitive layout are more important to me than fancy visuals. If you have a proven way to scrape TikTok comment data into Sheets/Excel and can set up the alert logic, let’s talk.
Project ID: 40210823
32 proposals
Remote project
Active 5 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Dedicated Freelancer Ready to Elevate Your Project for TikTok Engagement Tracking Sheet. I have a solid background in Data Entry, Google Sheets, Excel, Data Scraping, Automation, PHP, API Integration and Software Architecture, I bring valuable expertise to your project. I have successfully completed many projects with 100% client satisfaction. Clear and timely communication is my priority. I believe in keeping you informed throughout the project lifecycle. I am available for a discussion at your earliest convenience. Please feel free to contact me to further discuss your project details. Thank you for considering my bid. I am excited about the opportunity to contribute to the success of your project. Please visit my portfolio to check my previous work samples, here - https://www.freelancer.com/u/GraphicsHub2k24?page=portfolio&w=f&ngsw-bypass= Best regards, Muhammad Asim Khan
$30 USD in 1 day
4.5
4.5
32 freelancers are bidding on average $132 USD for this job

Hi there, I’ve read your TikTok Engagement Tracking Sheet brief and I’m confident I can deliver a fast, transparent workflow that scales as your group grows. The core idea, automatic, public TikTok comment retrieval with a reliable manual override, fits perfectly with a lightweight Google Sheets (or Excel) solution that remains under your stated admin time. What I’ll build for you - A clean, add-on-free Google Sheet (or Excel workbook) that: you paste daily repost URLs, and in minutes shows a green "commented" or red "missed" per member, focused on comments only. - Automated retrieval of public TikTok comments (via simple, compliant scraping or API-based approach) with manual override fields to fix false negatives instantly. - A running per-member misses dashboard with a highlight for anyone who falls behind, plus a daily/monthly summary. - Optional alerting: email, in-sheet alert, or lightweight WhatsApp ping when a member misses, configurable per day. How I’ll approach it - Lightweight automation: small, robust scripts that run in Sheets/Excel, designed for speed, minimal maintenance, and easy onboarding. - Clear, self-explanatory doc or short screen-recording showing how to add members, drop new links, and trigger notifications. - Quick-start plan: I’ll setup the first 15-20 members and a 7-day trial window to validate the workflow, then scale as you grow. Deliverables - Fully functioning sheet/workbook with all formulas/scripts signed in your account. - Step-by-step d
$100 USD in 5 days
6.6
6.6

السلام عليكم;;;;;;; I can accurately populate your workbook, align everything to your formatting guidelines, and return a clean, polished .xlsx file within the same day once the data is received. If you need speed, precision, and zero rework, I’d be happy to take this on and deliver immediately. ;;;; I’m a Certified Excel VBA Programmer, Certified in Business Analytics, and hold an MBA, with a strong track record in fast, error-free data handling.
$50 USD in 1 day
6.4
6.4

We can build a Google Sheet or Excel tracker that automatically flags which members comment on each TikTok repost. Using TikTok’s public comment API or lightweight scraping scripts, the sheet will colour-code “commented” vs “missed,” tally misses per member, and allow manual overrides for accuracy. Optional alerts (email, in-sheet pop-up, or WhatsApp) can ping non-active members instantly. The workflow will be simple: add members once, paste daily repost URLs, and see instant results—all designed to scale as your group grows. Can you share whether you prefer Google Sheets with Apps Script or Excel with VBA, and if real-time alerts are essential from day one?
$200 USD in 7 days
7.1
7.1

Hello! I understand you're looking for an efficient way to track engagement in your TikTok WhatsApp group. I can develop a Google Sheet or Excel file that seamlessly retrieves comments from public posts, with a user-friendly interface to easily manage member data and repost URLs. This will include clear indicators, green for "commented" and red for "missed", along with a summary of engagement that flags any inactive members. Additionally, I will integrate a simple alert system to notify non-active participants. Please see my portfolios for similar projects. Regards, Davide
$230 USD in 3 days
5.3
5.3

⭐Hey Maxim, I’m ready to assist you right away!⭐ I believe I’d be a great fit for your project since I specialize in Excel automation, data scraping, and creating intuitive layouts for efficient workflows. My experience in API integration and software architecture enables me to deliver the automated comment tracking system you need quickly and accurately. I ensure a fast, transparent method for tracking TikTok engagement in a Google Sheet, with color-coded flags indicating comments from each member. This system will provide you with a clear daily summary of member activity and prompt alerts for non-active members to keep the group engaged. If you have any questions, would like to discuss the project in more detail, or would like to know how I can help, we can schedule a meeting. Thank you. Maxim
$30 USD in 5 days
5.0
5.0

Hi there, I'm Kristopher Kramer from McKinney, Texas. I’ve worked on similar projects before, and as a senior full-stack and AI engineer, I have the proven experience needed to deliver this successfully, so I have strong experience in Automation, API Integration, Data Scraping, Google Sheets, PHP, Excel, Data Entry and Software Architecture. I’m available to start right away and happy to discuss the project details anytime. Looking forward to speaking with you soon. Best regards, Kristopher Kramer
$120 USD in 3 days
4.8
4.8

As an experienced IT strategist with a strong background in web development and an emphasis on fast, efficient solutions, I am confident that I can create the perfect tracking system for your TikTok engagement group. My proficiency in PHP - a versatile language used to handle and automate tasks - ensures that I can streamline the workflow of retrieving comments, matching usernames, and updating the dashboard on your Google Sheet or Excel file. Moreover, my familiarity with web scraping techniques will enable me to retrieve public TikTok post comments in a timely manner - allowing you to have a comprehensive view of each member's engagement level. Additionally, I understand the need for manual override options in case of false negatives, and can seamlessly include this functionality in the system. Beyond technical proficiency, what separates me is my deep commitment to client satisfaction. With efficiency as one of your core values for this project, you can rely on me to deliver clean code, minimal manual clicks, and an intuitively laid out interface. I pledge to provide clear documentation or even short screen recordings if needed so you can easily manage the system independently while knowing that my support window will be open to ensure everything runs smoothly. Let's collaborate on bringing this impressive project vision to life!
$200 USD in 5 days
4.5
4.5

Dear Hiring Manager, I’m pleased to submit my proposal to build a fast, transparent tracking system that clearly shows which members of your WhatsApp TikTok engagement group are actually commenting on each reposted video. I understand your priorities are speed, fairness, and simplicity, and I would design the solution to minimise daily effort while remaining reliable as the group scales. The system would be centred around a Google Sheet or Excel file enhanced with scripts/automation, giving you clear visibility within minutes of adding a new link. ➡ Structured Google Sheet or Excel setup where member names are added once and reused automatically ➡ Simple daily workflow: paste the repost URL and trigger automated processing ➡ Automated retrieval of public TikTok comments and matching against member usernames ➡ Clear visual status per member using green (commented) and red (missed) indicators ➡ Manual override fields to instantly correct false negatives without breaking automation ➡ Running summary that counts misses per member and highlights underperforming participants ➡ Optional lightweight alerts (email, in-sheet notification, or WhatsApp where feasible) for missed comments ➡ Scalable logic designed to handle growth beyond the initial 20 members ➡ Clean, maintainable scripts with minimal manual clicks required ➡ Fully functional file delivered under your account with ownership of all formulas and scripts Best Regards, Mayank Saluja
$125 USD in 5 days
4.9
4.9

Hi there! I see you need a fast and easy way to track TikTok engagement for your WhatsApp group. Keeping a clear record of who comments daily can be time-consuming without automation, especially as your group grows. I have experience building automated Google Sheets and Excel trackers that pull data from social media platforms, match usernames, and instantly flag activity with color-coded results. I can create a sheet that retrieves TikTok comments, marks “commented” or “missed,” counts misses per member, and even sends simple alerts via email or WhatsApp. My setup will save you time and keep your engagement tracking accurate and transparent. Check our work https://www.freelancer.com/u/ayesha86664 Do you want the alerts to go directly through WhatsApp or just email for simplicity? Let me know if you’re interested & we can discuss it. Best Regards, Ayesha
$140 USD in 5 days
4.1
4.1

Hey — saw your post about the TikTok Engagement Tracking Sheet for your WhatsApp group. With 20 creators (and soon more), the big headache is usually keeping the sheet clean and making sure people actually log/track engagement without it turning into chaos. Quick question before I suggest a structure: Do you want this fully automated with formulas and filters, or mostly manual entry with simple checks so anyone can use it easily? I’ve set up tracking sheets for social/content teams before, with clear views by user, day, and performance so it doesn’t fall apart once more people join. If you share your current sheet (or a rough idea of the columns you want), I can review it and tell you exactly how I’d set it up for your group.
$140 USD in 7 days
3.7
3.7

Hello, I appreciate the opportunity to bid on your project to create a streamlined engagement system for your TikTok creators' WhatsApp group. Your need for a transparent way to monitor comments and engagement is clear, and I can help you achieve a fast and efficient solution. I have extensive experience in developing automated Google Sheets and Excel systems, particularly for social media analytics. I am well-versed in scripting and data retrieval, and I have successfully implemented similar projects that required real-time data management and user notifications. To ensure your project runs smoothly, I propose the following approach: - Develop a Google Sheet that allows for easy daily input of repost URLs, automatically retrieving and analyzing comments. - Implement a color-coded system to indicate engagement status (commented/missed) for each member. - Create a running summary for tracking engagement over time and flagging members who may need a reminder. - Set up a lightweight alert system, such as email or in-sheet notifications, to encourage non-active members to engage. I am eager to get started on this project, confident in my ability to deliver a functional and user-friendly solution that meets your needs. I am happy to discuss any further details and can begin immediately. Thank you for considering my proposal!
$140 USD in 7 days
3.5
3.5

Hello, I am a full-stack AI developer with 8 years of rich experience in software development, with Google Sheets, Excel, Apps Script automation, data scraping, API integration, and lightweight alert workflows.. I can build a Google Sheet where you paste each TikTok repost URL, an Apps Script pulls public comments, matches usernames to your member list, color-codes commented/missed with manual overrides, and updates a running dashboard plus optional email/WhatsApp-style alerts for misses. This project is a perfect fit for my skills and I am sure I can delivery this with high quality. Thanks for considering my proposal — Lautaro
$250 USD in 1 day
3.2
3.2

Hi, I read your brief and can deliver a lightweight Google Sheet (Apps Script) that pulls public TikTok comments for each repost link, matches usernames to your 20-member list, and shows green “commented” or red “missed” flags with manual-override fields. I’ll add a running miss counter with conditional highlighting and an optional alert (email, in-sheet pop-up, or a simple WhatsApp ping) while keeping daily admin under an hour. I prioritize clean, commented code, minimal clicks, and an intuitive layout. I also have practical experience with LLMs, Transformers, chatbots, classification, and vector search and understand the full pipeline from data ingestion to deployment and monitoring. I’ll provide the signed-in sheet, a short step-by-step guide or screen recording, and a brief support window after handoff. Which alert method do you prefer (email, in-sheet pop-up, or WhatsApp), and if WhatsApp, do you have access to a WhatsApp Business API or would you prefer a simpler forwarding option? Thanks, Andrew
$155 USD in 3 days
2.3
2.3

I can build a clean Google Sheet powered by Apps Script that pulls public TikTok comments per repost link, auto-matches usernames, and flags each member green/red in minutes. Manual overrides are built in so corrections take seconds, not rework. You’ll get a live dashboard counting misses per member, plus optional alerts for non‑commenters. I’ll deliver a ready-to-use sheet, clear setup steps, and short post‑launch support so it scales smoothly as your group grows.
$70 USD in 7 days
1.5
1.5

Hi, I am excited about your TikTok Engagement Tracking project. I will create a dynamic Google Sheet that allows you to paste repost links daily and instantly track member engagement with clear flags for commented or missed posts. With my extensive experience in data scraping and Google Sheets automation, I will implement a robust script that pulls public comments and matches usernames, ensuring an efficient workflow. Additionally, I will include a user-friendly guide and support to ensure seamless operation. Let’s ensure the tool remains intuitive and simple, meeting your needs as your group grows. What specific features do you want highlighted in the user guide for the engagement sheet?
$50 USD in 2 days
0.0
0.0

Hello, as a software architect experienced in automation and data scraping, I can provide a solution for your TikTok engagement tracking needs. Based on your project details, I understand the necessity for a fast and transparent system to monitor member engagement efficiently. My relevant experiences align perfectly with the requirements you outlined, ensuring a seamless workflow for tracking comments and identifying engagement gaps. Looking forward to working with you and delivering a solution that simplifies your daily administrative tasks while enhancing member engagement.
$30 USD in 6 days
0.0
0.0

Hello, As a highly skilled software developer with eight years of experience, I have the expertise and knowledge needed to create your TikTok engagement tracking sheet. I specialize in AI-powered solutions and automation, both of which are critical for retrieving and analyzing comments from public TikTok posts. With proficiency in Google Sheets and Excel, I can design a tool that not only automates the process but also allows for manual overrides to address any false negatives promptly. I also possess significant experience in backend systems and distributed architectures - an area crucial for building scalable, high-performance applications. This will ensure your Google Sheet or Excel file functions efficiently as your WhatsApp engagement group expands in members. My core focus when developing applications is creating clean, secure, and maintainable code. You won't have to worry about complex or sloppy code that hinders future maintenance. Lastly, I understand the value of optimization and speed in your project. Rest assured that not only will I deliver a fully-functioning sheet with all formulas/scripts signed on your account, but also provide you with clear step-by-step documentation or even short screen-recordings for ease of use. Beyond completing this project, my commitment extends to offering robust support during the implementation process to guarantee your system runs smoothly. Choose me as your freelancer; together we wil Thanks!
$155 USD in 4 days
0.0
0.0

Commitment to Quality and Timely Delivery I understand that accuracy is your priority, and I focus on delivering error-free work while maintaining efficient turnaround times. I am ready to complete a sample batch so you can evaluate my work quality and formatting consistency before moving forward with the full project.
$140 USD in 7 days
0.0
0.0

Hi there, this seems like an interesting project. And to help you better may I know if there is a defined cutoff window for counting comments (within 24 hours of repost), or should the script keep checking until a manual stop or the next day’s link is added? I think we should take a look at Brand24 which is for "social listening." It alerts you whenever specific keywords or brand names are mentioned in public TikTok comments across the platform. Let's discuss further over chat. Regards, Abdul M
$300 USD in 15 days
0.0
0.0

Hi there, I'm excited to help you automate TikTok engagement tracking for your growing WhatsApp creator group. With solid experience in Google Sheets automation and data scraping, I’ve worked on similar engagement-tracking workflows. I’ll deliver a fast, transparent daily view that flags each member as "commented" (green) or "missed" (red) based on public TikTok comments—no likes or watch-time data. What you’ll get: - A Google Sheets (or Excel) solution where you paste each day’s repost URL and see results in minutes. - Automated comment retrieval from public posts, plus manual override fields to fix misses on the spot. - A running misses-per-member dashboard with instant highlights for anyone behind. - An optional alert (email, in-sheet popup, or lightweight WhatsApp) when someone goes non-active. Deliverables: - Fully functioning sheet with all formulas/scripts signed in your account - Clear setup doc or short screen-recording - Brief post-delivery support window Do you have a preferred alert channel (email vs WhatsApp) and any privacy or compliance considerations I should account for when scraping TikTok public comments? Best regards,
$180 USD in 5 days
0.0
0.0

Ha’il, Saudi Arabia
Payment method verified
Member since Feb 5, 2026
$18.5 USD / hour
€30-250 EUR
$10-30 USD
₹600-1500 INR
$10 AUD
€30-250 EUR
$30-250 USD
$10-30 USD
€30-250 EUR
₹750-1250 INR / hour
$14-30 NZD
₹600-1500 INR
₹1500-12500 INR
₹600-1500 INR
₹750-1250 INR / hour
$43 USD / hour
₹750-1250 INR / hour
$10-85 USD
$8-15 USD / hour
$250-750 USD