All Workflows
Analyze YouTube Video Performance and Generate Daily Reports to Google Sheets
This workflow helps you monitor and analyze your YouTube channel's recent performance on a automated daily basis. You can customize the reporting period, the number of videos analyzed, and the specific performance metrics tracked to align with your content strategy. It uses the YouTube Data and Analytics APIs to collect video-level statistics and engagement trends, then saves the organized data into a dedicated Google Sheet. In this example, the workflow identifies up to 10 videos published in the last week to calculate engagement rates and watch time. It provides you with a structured performance log and a summary of top-performing content alongside actionable growth recommendations.
What it does
1
Identify the authenticated YouTube channel and fetch up to 10 videos published within the last seven days.
2
Collect video-level statistics including views, likes, comments, and subscribers gained using YouTube APIs.
3
Retrieve deep analytics such as total watch time and average view duration for each verified video.
4
Calculate engagement rates and identify top-performing content based on audience interaction.
5
Create or update a Google Sheet report with a daily breakdown of video performance and an aggregate overview.
6
Generate a summary report featuring key observations, performance patterns, and recommended next actions for the creator.
How to use
1
Use the template
Click "Use this template" to open this workflow in Kuse and start from a ready-made setup.
2
Customise
Adjust the search criteria, output format, or schedule to fit your specific use case. All fields are editable.
3
Activate
Turn on the schedule or trigger the workflow manually from your Workflows dashboard to run it for the first time.
