1

Data Sources

The cross-check compares your latest video check results (from the Dashboard) with the Google Spreadsheet.

Website Check Results
Loading...
Google Spreadsheet
Ready to fetch
Leave empty to use the default spreadsheet from server config.
2

Run Cross-check

Fetch the spreadsheet, match video titles, and identify status mismatches.

Matching Rules

↓ Video in spreadsheet marked "In PRODUCTION" but not on website → revert to "Ready to Live"
↑ Video on website but spreadsheet status is not "In PRODUCTION" → change to "In PRODUCTION"
✓ Everything else → leave as-is
Setup: How to enable "Apply Changes" (one-time setup)

What does "Apply Changes" do?

It only updates the Status column in your Google Spreadsheet to match reality. For example:

  • If a video is marked "In PRODUCTION" in the spreadsheet but is not on the website → it changes the status back to "Ready to Live"
  • If a video is on the website but marked "Ready to Live" in the spreadsheet → it changes the status to "In PRODUCTION"

It does NOT publish or remove any videos on the live Kingdomland website. It only keeps your spreadsheet tracking in sync.

How to set it up (one-time)

You need to deploy a small Google Apps Script inside your spreadsheet so this tool can update it:

1
Open the Kingdomland spreadsheet

Go to your Google Spreadsheet in your browser.

2
Open the Apps Script editor

In the spreadsheet menu bar, click Extensions → Apps Script. This opens a new tab with the script editor.

3
Paste the script code

In the script editor, delete everything in the code area. Then open the file google-apps-script.js from this project folder, copy the entire contents, and paste it into the editor.

The file is at: kingdomland-video-checker/google-apps-script.js

4
Deploy as a Web App

In the script editor, click the blue Deploy button (top right) → New deployment.

  • Click the gear icon next to "Select type" and choose Web app
  • Set "Execute as" to Me (your Google account)
  • Set "Who has access" to Anyone
  • Click Deploy

Google may ask you to authorize — click Review permissions, choose your account, and click Allow.

5
Copy the Web App URL

After deploying, you'll see a URL like:
https://script.google.com/macros/s/AKfyc.../exec

Click the copy icon to copy this URL.

6
Add the URL to your .env file

Open the .env file in the project folder (kingdomland-video-checker/.env) and add this line:

GSHEET_WEBAPP_URL=https://script.google.com/macros/s/AKfyc.../exec

Replace the URL with the one you copied in Step 5.

7
Restart the server

Stop the running server (press Ctrl+C in the terminal) and start it again with node server.js. The "Apply Changes" button will now work!