Youtube Chronicle

#n8n #ai #technology
This n8n workflow authenticates users, retrieves data from TH-cam channels, and generates a dynamic webpage summarizing the latest TH-cam videos from the user's favorite channels. The workflow is designed for efficient automation with error handling and session management.
/ @attiladeri4817
• Complete Gouid How to ...
This workflow integrates the following tools and APIs:
n8n for workflow automation.
Google Sheets / Firestore / Supabase for database management.
TH-cam API for video and transcript retrieval.
Groq (or other LLM API) for transcript summarization.
Features
1. User Authentication
Supports user login via Google Sheets, Firestore, or Supabase databases.
Credentials (username and password) must be pre-created in the database.
If login fails, the user is notified and redirected to the login page with the option to retry.
2. Main Page Functionality
After successful login, the user is presented with a main page containing an accordion menu with 5 input fields for TH-cam channel handles.
The user specifies their favorite TH-camrs by providing channel handles in these fields.
Upon submission, the data is stored in the database for future sessions.
3. Data Collection and Processing
On subsequent logins, the workflow retrieves:
The two latest videos for each TH-cam channel specified.
Transcripts of the videos using the TH-cam Transcript community node.
Summaries of the video transcripts are generated and presented on the webpage, organized by TH-camr.
Links to the original videos and channels are provided for easy access.
4. Dynamic and Configurable
The number of videos retrieved can be adjusted by changing the maxResults parameter in the workflow.
The workflow is fully dynamic, allowing additional favorite channels to be configured.
5. Session Management
Logout: Users can log out using the logout button, returning to the login page, and terminating the workflow.
Inactivity: If the user spends more than 5 minutes on the page, the submit button becomes disabled, and the workflow automatically terminates.
Window Closure: If the browser window is closed or left open for too long, the same behavior as inactivity occurs.
6. Error Handling
Basic error handling is implemented to manage invalid TH-cam channel handles or API errors.
Prerequisites
To set up and run this workflow, you will need:
Google OAuth for TH-cam API.
Google Sheets or Firestore (optional if using Supabase for user data).
Supabase API Key (if using Supabase for database management).
LLM API Key (e.g., Groq, though this can be replaced with another provider).
Data Storage
The workflow utilizes two database tables:
1. User Credentials Table: Stores usernames and passwords for authentication.
2. User Preferences Table: Stores the user's favorite TH-cam channel handles.
Github: github.com/acc...
Music: Cream Of The Earth (Nothing Surpasses The Original) by Wobbler: www.amigaremix...