Gopher for Groups vs TubeSheet for YouTube™ Stats & Analytics

Google Groups are a very powerful permissions, communications, and collaboration tool in G Suite for EDU districts, but auditing and managing their access settings can be a challenge at scale. Gopher for Groups lets you gain visibility and control of critical Google Groups access and permissions settings that impact the security of domain resources and communications. Group owners sometimes make risky edits to critical settings like “Who can join” or “Who can post” in ways admins can’t easily discover. Default settings for new groups are likely too permissive for a typical school environment. Group settings are overwhelmingly many, and are extremely time-consuming to update at scale via Google’s user interface. How Gopher for Groups boosts your administrative game: - Quickly import all Google Groups settings available via Google’s APIs. - Filter for key privacy or online safety risks, such as permissive join or posting settings. - Perform advanced group membership analysis to account for all owners and managers, identify nested groups, and look for groups with membership set to “all in domain.” - Make all your group settings right in the sheet. Use the power of Sheets filters to limit which groups you want to update. - Preview all changes before bulk-committing them to Google’s APIs

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].