Browse All Videos

How to Send YouTube Stats to Notion - With No Code! (Notion API)

by Thomas Frank Explains
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