Generate YouTube Channel Profile Reports in Google Slides with ChannelCrawler & GPT-4

Description

ChannelCrawler API to Google Slides Template

This template shows how you can use the ChannelCrawler API alongside ChatGPT (or any LLM) to generate google slides using images and texts received from the API

How it Works
A user inputs the link to the Youtube channel(s) of their target creators
The list is parsed by a python script, returning it in a format that can be ran in a loop
The workflow iterates over each channel url
The url is passed to the ChannelCrawler API, where it returns a json of the creators profile.
The OpenAI node processes the description and content of the creators profile to create a summary
We retrieve the google slides presentation using the get presentation node.
We use the Google Slides API to duplicate an existing page and pull back the original page as it has a new revision ID
We use the Google Slides API to change the image placeholder of the of the image Presentation
Lastly we update other placeholders in with text from the ChannelCrawler and ChatGPT outputs

How to Use
From executing the workflow, a pop up form will come up where you can insert the Youtube Channel urls
On submission, provided the prerequisites are set up - rest of the workflow will be triggered

Use Cases
You can create profiles on influencers and creators with extensive data points from the ChannelCrawler API and consistent summarisation from GPT

Prerequisites
ChannelCrawler Account - there's a great pay as you go options for access to the API
OpenAI account - the you can access free Open AI credit if you are a first time n8n user! Check the credentials options in the node
Google account (For slides) - You should have a google account or sign up for google with your non google email