Social Video Performance Tracker

Overview

Manual tracking of video performance across Instagram, TikTok, and Facebook is time-consuming and error-prone. This workflow automates data scraping and updates Google Sheets with clean, unified video metadata and engagement stats, eliminating tedious manual entry and accelerating data-driven decisions.

The Impact

Automate data fetching. Eliminate manual scraping and entry for social video metrics.
Unify multi-platform data. Standardize Instagram, TikTok, and Facebook stats into one format.
Speed up reporting. Instantly update Google Sheets with fresh insights for real-time analysis.
Reduce errors. Remove human mistakes from repetitive data transcription tasks.

Who This Is For

Social Media Managers Automate daily updates of video engagement metrics for dashboard monitoring.
Content Analysts Batch archive historical video data for performance analysis and reports.
Marketing Teams Track competitor video stats regularly to benchmark and strategize.
Data Specialists Streamline multi-platform video data extraction and consolidation.

How It Works

Read and Parse Sheet Rows
Fetch all rows from Google Sheets and convert spreadsheet data strings into structured objects.

Iterate Rows and Extract URLs
Process each video URL row-by-row to prepare for platform classification.

Classify Platform
Identify whether the URL belongs to Instagram, TikTok, or Facebook to select the correct scraping API.

Fetch and Extract Metrics
Call the corresponding API to retrieve raw JSON, then extract title, release time, views, likes, comments, and shares.

Clean Data and Update Sheet
Format titles and timestamps, then write the consolidated data back into the original Google Sheets row.

What You'll Need

Before using this template, make sure you have:

A Google Sheets spreadsheet with headers: Url, title, timer, play, like, comment.

Google OAuth credentials configured for reading and writing the Google Sheets.

RapidAPI API key for accessing Instagram, TikTok, and Facebook scraping endpoints.

Correct API hosts configured for Instagram and TikTok, default values provided.

Spreadsheet ID and worksheet (tab) name for precise data targeting.

How to Use

Step 1. Prepare Your Sheet

Set up your Google Sheet with the required headers and fill video URLs starting from the second row.

Step 2. Configure Credentials

Set Google OAuth credentials for sheet access and input your RapidAPI key and hosts.

Step 3. Input Parameters

Fill in ApiKey, SheetId, SheetBookName, and optionally RowIndex if updating specific rows.

Step 4. Run the Workflow

Trigger the workflow to scrape and process video metrics automatically.

Step 5. Verify Results

Check your Google Sheet to confirm titles, release dates, views, likes, and comments have updated correctly.

FAQs

How does the workflow determine which social platform a URL belongs to?

It uses the "Classify Platform" node to analyze the URL pattern and assign it to Instagram, TikTok, or Facebook scraping branches.

What happens if the API response format changes?

The extraction nodes rely on fixed JSON paths. If the API response changes, the workflow might fail to extract correct fields until updated accordingly.

Can this workflow handle bulk updates of hundreds of video links?

Yes. It iterates over each row, processing URLs one by one, suitable for batch updating large datasets.

How are timestamps converted into readable dates?

The "Process Title And Time" node converts UNIX timestamps into a "YYYY年MM月DD日" format string, removing line breaks from titles as well.

What if a video URL is invalid or the API call fails?

Fail defaults and error handling are set to avoid workflow crashes. The problematic row may be skipped or left unchanged, but errors won't halt the entire process.

Updated on: Aug 21, 2026

Was This Page Helpful?