Want to see your YouTube video stats directly in your Creator’s Companion content projects? This is doable, and I’ve set up an automation that will let you do it for free.
This automation support syncing the following stats:
- Views
- Likes
- Comments
- Video Publish Date
- Thumbnail (set as Cover image)
I’ve shared this as a Pipedream workflow, so it functions a bit like a Notion template – I’ve already done most of the work for you, so you just need to set it up.
Here’s a full walkthrough (click here to watch the video directly on Loom). Note: Like many other platforms, Pipedream is always tweaking its design. If something doesn’t appear the same as in the vidoe, I recommend checking out their docs, which include an AI chatbot which may provide you with helpful answers.
Click here to import this workflow into your Pipedream account.
If you don’t have a Pipedream account, you’ll be prompted to create one. You can run this automation on their Free plan without any issues.
The only caveat to that: If you have hundreds of videos, you may run into timeouts because the Notion API’s write speed is fairly slow. I’m still working on ways we can work around this.
Note that we can’t provide full support for automations like this. This automation is considered a free bonus for Creator’s Companion customers. Our support guarantee is for our Notion templates; we currently don’t have budget or staff for experienced developers who can handle support requests.
That said, if you run into issues with this workflow or have new ideas for it, please open a Github Issue at this workflow’s repo. I’ll do my best to address bugs and issues.
Copy link to headingMore Info
Here’s the Stats formula you can add that will display your YouTube stats in a really nice way:
[("👀 " + prop("Views").
replace("(\d+)(\d{3})","$1,$2").
replace("(\d+)(\d{3},\d{3})","$1,$2")
).style("c","b","green","green_background"),
("👍 " + prop("Likes").
replace("(\d+)(\d{3})","$1,$2").
replace("(\d+)(\d{3},\d{3})","$1,$2")
).style("c","b","green","green_background"),
("💬 " + prop("Comments").
replace("(\d+)(\d{3})","$1,$2").
replace("(\d+)(\d{3},\d{3})","$1,$2")
).style("c","b","green","green_background")].join("\n")
Code language: JavaScript (javascript)You may need to delete the prop() references and then type the names of the properties, hitting Enter to insert them. Otherwise, this should work without issue as long as you’ve named your stat properties the same as I have.
If you want to deeply learn how to use these new Notion formulas – and add the Top 3 Videos by Views property to your Channels database, check out my new Formulas masterclass:
I’ve also included a free Formulas practice template that include the full formula, so you can just copy it as well 😉