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.

RouteWhat it can readSame row orderUpdates by itselfWhat it takes
Apps Script + official APIsYouTube: any public video. TikTok: only videos of users who authorized your app. Instagram: professional accounts by username, not by post linkYes, the script writes next to each linkYes, on a time-driven triggerA Google Cloud API key and a script you maintain; for TikTok and Instagram, a developer app and creator authorization
Tracking platformPublic posts on TikTok, Instagram and YouTube, by creator or by linkIn the vendor's dashboard; your sheet needs an export and a match by linkYes, inside the dashboardA 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 backAny public TikTok, Reels or Shorts link, mixed in one listYes, the returned table has every row in its original placeNo. Each read is a snapshot; a weekly re-read delivers a new fileCredits 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.

CreatorPlatformViewsLikesCommentsShares
@jenna_bariatricbestieTikTok238,80615,69161440
@miss.zamorTikTok27,7062874104
@alyssarafaelInstagram90,438not shown25not public
@katielynnteachesInstagram191,4116,79535not 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

  1. 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.

  2. 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.

  3. 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.

  4. Download the returned table

    It has every row in its original order, with the numbers filled in and a status for each link.

  5. Import it as a new tab

    In your tracking spreadsheet, use File, Import to add the returned file as a new sheet.

  6. 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.

Check the public views, likes, comments, shares and saves of each video, one row per link in my order, with engagement rate, unreadable and repeated links marked, and a summary of what to check before . Video links to check in bulk (one per line), or the sheet I attach:

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

Influencers and UGC (brands and agencies)

All guides

Tool

Ecommerce Ad Angle Generator

Turn buyer problems into testable advertising angles. Get evidence, proof requirements and a testing matrix before spending on new creative.

Tool

UGC Brief Generator

Give creators a practical shooting brief grounded in buyer questions: hooks, demonstrations, shot order, deliverables and claims that still need proof.

Tool

Influencer Gifting Strategy

Plan 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 metrics

What 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 outreach

How 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 seeding

What 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.