00:00 - Intro
00:26 - Project End Result Preview
01:18 - Table of Contents and Written Version
01:58 - Tutorial Overview and Requirements
04:35 - PART 1: Prep your Notion Database
04:53 - 1a: Create the Stat Properties
07:18 - 1b: Create the YT ID Formula Property
10:18 - 1c: Add the "Label" Properties
14:04 - PART 2: Get a Google API Key
15:32 - 2a: Create a Google Cloud Project
15:58 - 2b: Enable the YouTube Data API
17:08 - 2c: Create Your API Key
18:20 - 2d: Add an API Key Restriction
19:10 - PART 3: Build the Automation on Make
19:50 - 3a: Make.com Free Plan Limits
21:35 - 3b: Final Scenario Preview
23:55 - 3c: Create Your Scenario and Connect to Notion
25:20 - 3d: Notion Permissions Review
28:01 - 3e: Configure the Notion "Search Objects" Module
28:33 - 3f: How to Find Your Database ID
29:21 - 3g: Add Filters to the Query
31:07 - 3h: Run the Notion Module
32:25 - 3i: Set up the HTTP Module
33:34 - 3j: Reviewing the YouTube Data API Docs
34:19 - 3k: Setting the GET Request URL
36:05 - 3l: Setting up the Query String Parameters
39:06 - 3m: Parse the Response as JSON
39:52 - 3n: Test the Scenario
40:13 - 3o: How Bundles Work on Make.com
42:58 - 3p: Add the Notion "Update Database Item" Module
43:54 - 3q: Configure the Property Fields
45:56 - 3r: Test the Scenario and See Results
46:46 - 3s: Add Thumbnails as Page Covers
47:15 - 3t: Create a Router
47:55 - 3u: Add the Notion "Update a Page" Module
49:01 - 3v: Add a Filter to the "Update a Page" Path
50:30 - 3w: Run the Final Test
51:35 - 3y: Schedule and Enable the Scenario
52:46 - Tutorial Recap
53:24 - Alternative Tool: Pipedream (Low-Code)
54:15 - Creator's Companion (Template)
55:40 - Notion Tips Newsletter and Outro
---
🧪 FORMULA CODE:
YT ID formula (this is the video version; I recommend using the updated one below):
replace(prop("URL"), "^.*?v=(.*)", "$1")
Or use this better YT ID, which DOES handle short youtu.be links:
if(test(prop("URL"), "youtu.be"), replace(prop("URL"), "^.*(?:\\.be)/([^?&]*)\\?*.*", "$1"), replace(prop("URL"), "^.*(?:\\?v=|shorts/)([^?&]*)\\?*.*", "$1"))
For Likes Label and Comments Label, simply edit the prop() value and the emoji as needed.
👐 BUSINESS:
Please contact my agent at thomasfrank@standard.tv
🎞 SPECIAL THANKS
Video clips supplied by Getty Images
💰 I'm fortunate enough to work with great sponsors who support my work, so I don't use Patreon or any other crowdfunding service. However, if you'd like to support a worthy cause, consider donating to help more children get access to a high-quality education: https://fundraise.pencilsofpromise.org/fundraiser/1489730