How to fill views, likes and comments into an influencer campaign tracking sheet in Google Sheets
· Nolyn research team
How do I automatically fill views, likes and comments into my campaign tracking sheet in Google Sheets, in the same row order as my links?
There are three ways: an Apps Script that calls the platforms' official APIs, a tracking platform, or pasting the sheet into a bulk reader and pasting the result back. As of November 12, 2026, only YouTube's official API returns views, likes and comments for any public link (1 quota unit per call, 10,000 units a day by default). TikTok's Display API only returns videos of a user who authorized your app, up to 20 IDs per request, and Instagram's API reads other accounts only by username. For a mixed list of TikTok, Reels and Shorts links from creators you do not manage, the third way is the one that works today, and it is a paste, not a live sync.
For agency and brand teams who keep one row per creator post in Google Sheets and fill in the numbers by hand. This page compares the three routes honestly, including what our own tool does not do: it does not write into your live sheet.
Three ways to get views, likes and comments into the sheet
The routes differ in which links they can read and in who does the work. A script on official APIs keeps the sheet updating by itself, but only YouTube's API reads any public video. A tracking platform reads all three platforms and keeps the numbers in its own dashboard. A bulk reader takes your rows, reads each public link and gives the same rows back with the numbers, and you paste them in.
All three read the same public counters. None of them returns reach, unique viewers or watch time for a creator's post: those are only in the creator's own analytics, so they have to be sent by the creator or read through an API the creator has authorized.
| Route | What it can read | Same row order | Updates by itself | What it takes |
|---|---|---|---|---|
| Apps Script + official APIs | YouTube: any public video. TikTok: only videos of users who authorized your app. Instagram: professional accounts by username, not by post link | Yes, the script writes next to each link | Yes, on a time-driven trigger | A Google Cloud API key and a script you maintain; for TikTok and Instagram, a developer app and creator authorization |
| Tracking platform | Public posts on TikTok, Instagram and YouTube, by creator or by link | In the vendor's dashboard; your sheet needs an export and a match by link | Yes, inside the dashboard | A monthly plan, for example Modash from $199 a month or Shortimize from $99 a month (prices checked November 12, 2026) |
| Paste into a bulk reader, paste back | Any public TikTok, Reels or Shorts link, mixed in one list | Yes, the returned table has every row in its original place | No. Each read is a snapshot; a weekly re-read delivers a new file | Credits per link, no setup: about 1 per TikTok or YouTube link and 2 per Reel on Nolyn |
Limits read from each platform's developer documentation on November 12, 2026. We did not test the tracking platforms; check with the vendor whether a plan can sync to Google Sheets.
Route 1: Apps Script and the official APIs, and where they stop
For YouTube links this route is complete. The YouTube Data API's videos.list method returns statistics.viewCount, likeCount and commentCount for public videos, Shorts included, with an API key and no creator login. Each call costs 1 quota unit, and a project gets 10,000 units a day by default. The id parameter takes a comma-separated list of video IDs; the reference does not state a maximum, so test your batch size. A newer method, videos.batchGetStats, also returns statistics without authentication for public videos.
In Apps Script, enable the YouTube advanced service or call the API with UrlFetchApp. The script reads the link column, takes the video ID out of each link, asks for the statistics, and writes views, likes and comments into the same row, which is how the row order is kept. An installable time-driven trigger runs it on a schedule, from every minute to once a month. Apps Script's own limits are generous for this job: 6 minutes per execution, 20,000 URL Fetch calls a day on a consumer account and 100,000 on Workspace.
Know what the number is. YouTube's API reference says that from August 24, 2026, viewCount counts a view the moment a video begins to play, for long-form, live and Shorts. A count read before and after that date is not the same measure.
TikTok is where the script stops. The Display API's /v2/video/query/ endpoint takes an authorized user's token and a list of video IDs, checks that the videos belong to that user, and returns view_count, like_count, comment_count and share_count for up to 20 IDs per request. It cannot read a video from a creator who has not authorized your app. The Research API reads public videos, but TikTok says creators, advertisers and commercial users are not eligible. TikTok's oEmbed endpoint returns embed code and no counts. We found no official TikTok API that returns public counts for any link for commercial use.
Instagram sits in between. Media insights are for your app users' own media. Business Discovery lets an app read basic metrics about other professional accounts: you look the account up by username and get its media with like_count, comments_count and view_count, and Meta notes that view_count includes paid and organic views. There is no lookup by post link, so the script has to page through each creator's media and match the post. Personal accounts and age-gated accounts are not returned. It needs your own professional account, a Meta app, a token with the right permissions, and it falls under the platform rate limit of 200 calls an hour per user. Instagram's oEmbed returns embed HTML only, and Meta's terms for it rule out deriving analytics from it.
Route 2: a tracking platform
Tracking platforms read creators' public posts on a schedule and show them in a dashboard, usually with a client report. That fits teams that track the same creators every week and want the numbers refreshed without touching a sheet. The cost is a monthly plan sized by tracked creators or tracked videos: Modash lists $199 a month for 100 tracked creators, and Shortimize lists $99 a month for its Launch plan, both checked on November 12, 2026.
The numbers live in the vendor's product, not in your sheet. To bring them into a tracking sheet you export and match rows by link, unless the plan has a Google Sheets sync; we did not test one. We compare these tools, with what each tracks and what it costs, in Shortimize alternatives and Modash alternatives.
Route 3: paste the sheet into a bulk reader and paste the result back
This is the route for a mixed list of links from creators you do not manage. With Nolyn's bulk views checker, you copy the rows from Google Sheets, header included, and paste them into the form, or download the sheet as Excel or CSV and upload it (up to 3 MB and 5,000 rows per sheet). It finds the link column by itself and reads each public post: views, likes, comments, and shares and saves where the platform shows them.
The same table comes back: same rows, same order, same columns, blank rows still blank. If your sheet has empty columns named Views, Likes, Comments, Shares or Saves, the numbers go into them. If those columns already hold numbers, yours stay and the new reading arrives in checked_views, checked_likes and so on, to the right. Every row also gets check_status and check_note, which say why a link could not be read or that it repeats an earlier row.
Then the paste. Download the returned file and bring it into the same spreadsheet as a new tab with File, Import. Copy the stat columns and paste them over the same columns in your tracking tab with Edit, Paste special, Paste values only (Ctrl + Shift + V). Google's help says paste special works only within a single spreadsheet, which is why the import comes first. Because the row order never changed, one paste lines up with every link.
What it does not do: it does not connect to Google Sheets, write into the live sheet or keep formulas and formatting in the returned file. Each run is a snapshot. To keep a campaign current you can schedule one more read 7 days later or a re-read every Monday next to the returned file; each delivers a new file with the views gained since the last read, and you paste again. Each run spends credits.
What comes back: four rows from a real sheet
These four rows are from a 16-post tracker of creator posts for Owala's summer bags launch, read on November 3, 2026. They show what the stat columns look like when the table comes back: one row per link, in the order of the sheet.
Two cells show why a returned table needs text as well as numbers. Instagram does not show share counts publicly, so that cell says "not public". One creator hides like counts, so that cell says "not shown". Sums and averages in Sheets skip both. The full 16 rows are in the influencer tracking spreadsheet template, which also has the engagement rate and cost per 1,000 views formulas.
| Creator | Platform | Views | Likes | Comments | Shares |
|---|---|---|---|---|---|
| @jenna_bariatricbestie | TikTok | 238,806 | 15,691 | 61 | 440 |
| @miss.zamor | TikTok | 27,706 | 287 | 4 | 104 |
| @alyssarafael | 90,438 | not shown | 25 | not public | |
| @katielynnteaches | 191,411 | 6,795 | 35 | not public |
Public counts read November 3, 2026 (run 24cf91ca).
Which route fits which sheet
If the sheet holds only YouTube links, write the script: it is free, official and updates by itself. If you track the same roster every week and report from a dashboard, a tracking platform earns its monthly fee. If the sheet is a campaign list of mixed TikTok, Reels and Shorts links that you fill at reporting time, paste it into a bulk reader.
Whichever you use, write the read date next to the numbers. Public counters keep moving, and a count is only true for the moment it was read. For what each platform counts as a view, and why reach cannot be filled in from a link, see influencer campaign report metrics.
How to fill a Google Sheets tracker with a bulk reader
Put one link per row
Keep one row per post, with the public post link in its own column. Add empty columns named Views, Likes, Comments, Shares and Saves if you want the numbers to land there.
Copy the rows or download the sheet
Select the rows with the header and copy them, or use File, Download to save the sheet as Excel or CSV.
Paste or upload, then sign in
Paste the cells or upload the file in the form on this page. Check the credit estimate and run it.
Download the returned table
It has every row in its original order, with the numbers filled in and a status for each link.
Import it as a new tab
In your tracking spreadsheet, use File, Import to add the returned file as a new sheet.
Paste values only
Copy the stat columns from the new tab and paste them over the same columns in your tracker with Ctrl + Shift + V. Write the read date in the sheet.
Paste your sheet's cells and get the numbers back in the same rows
Copy the rows from Google Sheets, header included, and paste them here, or upload the sheet as Excel or CSV. Running it needs a sign-in; new accounts get 100 free credits, no card, and free accounts can read up to 20 links in bulk; a plan (Plus $19/month, 1,500 credits) reads longer lists. It takes about 1 credit per TikTok or YouTube link and 2 per Instagram Reel, plus a few for the written summary. The table comes back in the same row order; it is not written into your live Google Sheet.
Or start from a scenario:
Questions
Not from an official source that we could find. Google documents IMPORTXML and IMPORTHTML for structured pages and tables. TikTok's and Instagram's oEmbed endpoints return embed code without view or like counts, and the official APIs that do return counts need the creator's authorization on TikTok and a username lookup of a professional account on Instagram. Checked November 12, 2026.
Yes. Shorts are videos in the YouTube Data API, so videos.list with part=statistics returns their viewCount, likeCount and commentCount with an API key. A call costs 1 quota unit and the default quota is 10,000 units a day, checked on November 12, 2026. From August 24, 2026, viewCount counts a view the moment a video begins to play.
No. There is no Google Sheets connection. You paste the cells or upload the sheet as Excel or CSV, and you get the same table back as a file, with every row in its original order. You then import that file into your spreadsheet and paste the columns as values.
Use a method that works row by row and never sorts. A script should write each result into the row it read the link from. Nolyn's returned table keeps every row in place, including blank rows, rows with no link and links that could not be read, so the stat columns can be pasted over your own in one go.
With a YouTube script, yes: a time-driven trigger re-reads the links on a schedule. With Nolyn, you can turn on a re-read every Monday, or one read 7 days later, next to the returned file. Each run delivers a new file with the views gained since the last read; it does not change your Google Sheet, so you paste the new columns in. Each run spends credits.
No. Reach, impressions, unique viewers and watch time are not shown on a public post, so no outside tool can read them from a link. Ask the creator for a screenshot or export from their analytics, or use an API the creator has authorized.
On Nolyn, about 1 credit per TikTok or YouTube link and 2 per Instagram Reel, plus a few for the written summary, so 150 TikTok links take a little over 150 credits. New accounts get 100 free credits with no card, and free accounts can read up to 20 links in bulk; the Plus plan is $19 a month with 1,500 credits. A repeated link and a failed lookup are not charged.
Sources
- YouTube Data API: Videos: list (quota cost of 1 unit; the id parameter takes a comma-separated list of video IDs; page last updated 2026-11-10) · checked November 12, 2026
- YouTube Data API: Videos resource (statistics.viewCount, likeCount, commentCount; from August 24, 2026 viewCount counts a view the moment a video begins to play, for all formats) · checked November 12, 2026
- YouTube Data API Overview (default quota of 10,000 units per day for endpoints other than search.list and videos.insert) · checked November 12, 2026
- YouTube: Implement authorization (an API key is enough for requests that only retrieve public data) · checked November 12, 2026
- YouTube Data API: Videos: batchGetStats (no authentication needed for public videos; statistics part) · checked November 12, 2026
- Google Apps Script: Quotas for Google Services (URL Fetch 20,000 calls a day on consumer accounts and 100,000 on Workspace, 6 minutes per execution, triggers 90 minutes or 6 hours a day; last updated 2026-09-03) · checked November 12, 2026
- Google Apps Script: Installable Triggers (time-driven triggers, from every minute to once a month) · checked November 12, 2026
- Google Apps Script: YouTube Service (advanced service for the YouTube Data API; must be enabled before use) · checked November 12, 2026
- TikTok for Developers: Query Videos, /v2/video/query/ (verifies the videos belong to the authorized user; up to 20 video IDs per request; video.list scope; last updated August 24, 2026) · checked November 12, 2026
- TikTok for Developers: Research API (qualified researchers in the U.S., Europe, Canada and Brazil; non-commercial basis) · checked November 12, 2026
- TikTok for Developers: Research API FAQ (creators, advertisers and commercial users are not eligible; last updated September 1, 2026) · checked November 12, 2026
- TikTok for Developers: Embed Videos, oEmbed (returns embed code and basic information, no view or like counts; last updated October 23, 2026) · checked November 12, 2026
- Meta for Developers: Instagram Platform insights (insights for your app users' own media and professional accounts) · checked November 12, 2026
- Meta for Developers: Business Discovery (basic metadata and metrics about other Instagram professional accounts, looked up by username; view_count includes paid and organic; age-gated accounts are not returned) · checked November 12, 2026
- Meta for Developers: Embed an Instagram Post, oEmbed (embed HTML only; up to 1,000 requests an hour; not to be used to derive analytics) · checked November 12, 2026
- Meta for Developers: Graph API rate limiting (calls within one hour = 200 × number of users) · checked November 12, 2026
- Google Docs Editors Help: Copy and paste text and images (Edit, Paste special, Paste values only; paste special works only within a single spreadsheet) · checked November 12, 2026
- Google Docs Editors Help: Keyboard shortcuts for Google Sheets (Paste values only: Ctrl + Shift + V, ⌘ + Shift + V on Mac) · checked November 12, 2026
- Google Docs Editors Help: Import data sets & spreadsheets (File, Import) · checked November 12, 2026
- Google Docs Editors Help: Use both Excel & Sheets (File, Download as Excel or CSV) · checked November 12, 2026
- Modash pricing (Essentials $199/mo with 100 tracked creators, Performance $499/mo with 250; 14-day trial) · checked November 12, 2026
- Shortimize pricing (Launch $99/mo or $79 billed yearly, Scale $249 or $199, Enterprise custom) · checked November 12, 2026
- Nolyn: public counts of 16 creator posts from Owala's summer bags launch, read on November 3, 2026 (run 24cf91ca); the four rows shown here are from that saved read · checked November 12, 2026
Influencers and UGC (brands and agencies)
All guidesTool
Ecommerce Ad Angle GeneratorTurn buyer problems into testable advertising angles. Get evidence, proof requirements and a testing matrix before spending on new creative.
Tool
UGC Brief GeneratorGive creators a practical shooting brief grounded in buyer questions: hooks, demonstrations, shot order, deliverables and claims that still need proof.
Tool
Influencer Gifting StrategyPlan product seeding before sending samples. Assess creator fit, shortlist uncertainties, sample costs and a pilot measurement plan without assuming gifts earn posts.
Guide
Influencer campaign report metricsWhat views, reach, impressions, engagement rate, saves and shares mean on TikTok, Reels and Shorts, which are public, and how to total them in a client report.
Guide
Influencer outreachHow to do influencer outreach: where to reach creators (only 7 of 66 we checked list an email), what to say, 5 email and DM templates, follow-ups and FTC rules.
Guide
Product seedingWhat product seeding is, how to run a seeding campaign step by step, and how it looks on TikTok: 45% of 263 US product videos we read had a commission label.
