Infine

YouTube Statistics Analyzer
Explore the docs »

View Demo · Report Bug · Request Feature

Table of Contents

1. About The Project
   • Built With
2. Getting Started
   • Spreadsheet setup
   • YouTube Advanced Service setup
   • Making a local copy
   • Apps Script trigger setup
3. Usage
   • Functions
4. Roadmap
5. Contributing
6. License
7. Contact
8. Acknowledgements

About The Project

![Product Name Screen Shot][product-screenshot]

Infine is a project created to analyze YouTube videos and channels. This project can monitor the changes in a youtube video or a channel added to the database or the videos of the user uploads. This project is created in the purpose of automating the reseach work done around youtube statistics.

You can use this project freely and contribute to make it better

Built With

• Google Apps Script
• YouTube Data API V3
• Google Sheets API V4

Getting Started

To get a local copy up and running follow these simple steps.

Spreadsheet setup

1. Make of copy of the spreadsheet here. It already contains the Apps Script code from this repository.
2. Change the name of the Project to aything you want.

YouTube Advanced Service setup

1. From the spreadsheet, open the script editor by selecting Extensions > Apps Script.
2. In the left-hand navigation pane, select + next to Services.
3. Choose the YouTube Data API service, and click Add.
4. Then Choose the Google Sheets API service, and click Add.

Making a local copy

Clone the Infine

  git clone https://github.com/HarshaAbeyvickrama/Infine.git

Apps Script trigger setup

1. From the script editor, navigate to the left-hand vertical toolbar, and choose Triggers.
2. In the bottom right-hand corner, click the +Add Trigger button.
3. Under Run, select the updateVideoStatsTrigger function.
4. Under Select event source, choose Time-driven.
5. Under type, select Hour timer.
6. Then select Every Hour. (This will run every hour of the day and update the view,like & comment count of videos)
7. Optionally, adjust the Failure notification settings to configure how and when you are contacted by email if your triggered function fails.
8. Click Save.
9. Repeat from step 3 to 8 for the triggers updateChannelVideoStatsTrigger , updateUserChannelTrigger & updateChannelsTrigger .
10. For updateUserChannelTrigger & updateChannelsTrigger use a weekly trigger.

Usage

Functions

1. addUserVideos() : Add your uploads to the sheet to track.
2. getUserVideos() : Returns a JSON response of all user uploaded videos.
3. addPublicVideo(url,type) : Add a video with the link to the sheet to track.
4. getPublicVideos() : Returns a JSON response of all videos that are added to the sheet with addPublicVideo() function
5. getVideoStats(videoID) : Returns a JSON response of a particular video that is currently available in the database
6. addNewChannel(ChannelLink) : Add a YouTube channel to the sheet to monitor. This function will add all videos in that channel to the database and it will monitor their views, comments & like count seperately.
7. getChannel(channelID) : Returns a JSON response with the details a particular channel

Here, a separate sheet will be created with the name of the video ID for every video added to the sheet. This is applicable for all user videos and addition of channels

Roadmap

See the open issues for a list of proposed features (and known issues).

Contributing

Contributions are what make the open source community such an amazing place to be learn, inspire, and create. Any contributions you make are greatly appreciated.

1. Fork the Project
2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
3. Commit your Changes (git commit -m 'Add some AmazingFeature')
4. Push to the Branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

License

Distributed under the MIT License. See LICENSE for more information.

Contact

Harsha Abeyvickrama - @VHAbeyvickrama - harshaabeyvickrama@gmail.com

Project Link: https://github.com/HarshaAbeyvickrama/Infine

Acknowledgements

• Virange Gunarathne
• Awantha Irushan