Overview
In this no-code tutorial, we'll automatically pull view counts, thumbnail, and other information from YouTube to Notion via the Notion API.
📝WRITTEN VERSION (Find all formulas and reference material here)
https://thomasjfrank.com/notion-automation-youtube-data/
🎥 CREATOR'S COMPANION (My complete Notion system for content creators - use code FALL50 at checkout to get $50 off)
https://thomasjfrank.com/creators-companion/
📸 PUBLIC DEMO (My demo copy of Creator's Companion where you can see the results of this tutorial!)
https://ultimatebrain.notion.site/Thomas-Frank-Explains-c48153a196494d419eea9e714ee4e53e
🎬 SAMPLE TEMPLATE (This free template will let you skip Part 1 of this tutorial)
https://thomasfrank.notion.site/YouTube-to-Notion-Sample-Data-dc056a8920464dd6be5cf3d75f5143e1
🔗 ADDITIONAL VIDEO LINKS:
- Make.com (this is my referral link): https://thomasjfrank.com/make/
- Google Cloud Console: https://console.cloud.google.com/
- Notion Formula Reference: https://learn.thomasjfrank.com/notion-formula-reference/
- Notion Regular Expressions Guide: https://learn.thomasjfrank.com/notion-formula-reference/reference/regular-expressions-in-notion-formulas
- Notion Databases (Complete Beginner's Guide): https://thomasjfrank.com/notion-databases-the-ultimate-beginners-guide
📚 NOTION FUNDAMENTALS (Free & Complete Notion Beginner's Course)
https://thomasjfrank.com/fundamentals/
🧠 ULTIMATE BRAIN (Full Second-Brain Template):
https://thomasjfrank.com/brain/
🛠 MORE COURSES AND RESOURCES:
https://thomasjfrank.com/templates/
https://thomasjfrank.com/courses/
💪GET STARTED WITH NOTION:
https://thomasjfrank.com/usenotion/ - (this is my referral link)
🐦Connect with me:
Twitter ➔ https://twitter.com/tomfrankly (best way to interact with me)
Instagram ➔ https://instagram.com/tomfrankly
---
⏱ TIMESTAMPS:
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:
replace(prop("URL"), "^.*?v=(.*)", "$1")
Views Label formula:
"👀: " + replace(replace(format(prop("Views")), "(\\d{1})(\\d{3})$", "$1,$2"), "(\\d{1})(\\d{3},\\d{3})", "$1,$2")
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
From the same author
Want to level up your Notion skills?
We explore and write about all things Notion. From useful tips and tricks, to hand-curated lists of templates and tools, we cover everything for you.
Blog
Deep dive into Notion.
Read our best articles, including templates roundups and Notion tutorials.
Notion World
Get your directory of the best 150+ resources and tools to master the world of Notion.