Skolsynk vs TubeSheet for YouTube™ Stats & Analytics

Skolsynk for Google configures how users and student groups are retrieved from Google Workspace. Then choose which schools are to be synced to which educational service providers. ● Secure - Only Google Workspace administrators can access Skolsynk. ● Provide providers support-access for configuration assistance. ● Your school units are automatically retrieved from Statistics Sweden's school unit register. If anything is missing, contact the support for each supplier. ● Flexible filtering tools handle many different forms and structures in Google Workspace. ● Student groups can be retrieved, based on Google Groups or organizational units. ● During the process, you can download CSV files to help you understand what your data looks like and what will be synced. ● Possible to sync to the service providers test environment first. With Skolsynk for Google, school data from Google Workspace to service providers is synced in 5 easy steps 1❳ For each school unit, create a filter for which users belong to the school unit. 2❳ Create filters for which users are students and teachers respectively. 3❳ Create a filter for how groups are retrieved. 4❳ Select which school units are to be synchronized to which supplier. 5❳ Activate sync to service providers. Always contact the service providers's support first to discuss e.g. personal data assistant agreement. If a sync is started without the supplier's knowledge, the school's operations can be negatively affected as it e.g. can create duplicate accounts for existing users if the email addresses do not match.

With TubeSheet, you can export public real-time YouTube™ video/channel analytics to Google sheet™. All you have to do is pasting the video/channel ID to the first column of the sheet, TubeSheet will do the rest. TubeSheet is fast 🚀 as it uses YouTube™ Data APIs to pull data. A test run proved it exports 1000 video details in approximately 57 seconds. You can paste video/channel IDs in bulk to the sheet to pull the data. You can also export stats of all the videos from a channel to a sheet in descending order of upload time. With the help of a config, you can update the metrics on a set schedule automatically in the background. TubeSheet supports auto-update every 1/2/5/10/24 hours. You can get the updated numbers using Google Sheets™ API. With an option to disable, you can auto-refresh the metrics whenever you open the sheet. You can pick the list of parameters you want to export to the sheet. You can choose to abbreviate the counts. 🏆 Some use cases: ----------------------------- If your work involves YouTube™ video/channel analytics, you will be much productive with TubeSheet. - Your own or competitor's channel analytics. - View all thumbnails of the tracked videos in one place. - Subscriber counter using scheduled update configuration. 📃 List of fields TubeSheet can export: ----------------------------- Following video stats, Title, Description, Channel Name, Channel ID, Published on, Thumbnail, (Standard, Max Res, Medium, Default, High quality) thumbnail URL, Duration, Is Licensed, Is Live now, Live Viewers, Live Start Time, Live End Time, Live Scheduled Start Time, Live Scheduled End Time, Caption Available, Tags, number of views, likes, dislikes, comments. Following channel metrics, Title, Description, Published on, Thumbnail, (Medium, Default, High quality) thumbnail URL, number of videos, views, subscribers. 🎁 Features: ----------------------------- ➤ Export stats of any public YouTube™ video/channel. ➤ All exported data is in real-time. ➤ Refresh numbers periodically automatically in the background. ➤ Export all videos uploaded by any particular channel to a sheet. ➤ Refresh data on demand. ➤ Abbreviate counts with a config. ➤ Pick and export the data fields you are interested in. ➤ Auto-refresh the sheet data on open, with an option to disable via config. 🔐 Needed permissions explained: ----------------------------- ➤ View your YouTube™ account This is the least sensitive permission the add-on must have to fetch any public YouTube™ data. TubeSheet doesn’t fetch any personal YouTube™ data. ➤ See, edit, create and delete your spreadsheets in Google Drive™ As the metrics are exported to a spreadsheet, this permission is needed. TubeSheet doesn’t delete or create any spreadsheet. ➤ Connect to an external service TubeSheet makes requests to the developer’s backend to check if you are a premium user. ➤ Allow this application to run when you are not present Auto-refresh on open feature needs this permission to work. TubeSheet won’t ever run on its own in the background when the sheet is closed. ➤ Display and run third-party web content in prompts and sidebars inside Google™ applications If you want premium features, payment can be made within the sheet. To run PayPal in the sidebar, this permission is required. 🤔 How to use: ----------------------------- 1. After installing, select Extensions → TubeSheet → Track YouTube™ Videos/Channels. 2. Wait for a few seconds. A sheet will be generated with a template. 3. Add video IDs/channel IDs to the first column of the sheet to start tracking. 💫 Premium: ----------------------------- TubeSheet is free to use with some limitations in its functionality. However, you can upgrade to premium to use it without any limitations. For example, you can only add 25 videos for statistics in the videos sheet and 10 channels in the channels sheet in the free version. Select Extensions → TubeSheet → Buy Premium to unlock premium features. ℹ️ Resources ----------------------------- YouTube™ video - https://youtu.be/1V34z9tOxxE Documentation for the product - https://syncwithtech.com/tubesheet/docs 🙋 Feature Requests ----------------------------- I constantly work to improve the add-on. If you want any new features, feel free to drop a mail at [email protected].